By Alexander Chigrik – Should you have connection problems, review this troubleshooting checklist to find potential solutions.
Tag: sql server
Purging Merge Metadata
MSmerge_contents causes problems for anyone that is running merge replication for any length of time. The problem is that MSmerge_contents will grow forever unless you manage it. Merge replication makes very heavy use of MSmerge_contents which can cause problems as the size grows. This is normall
FIX: Merge Publications Cannot Synchronize on SQL Server 2000 SP3
You will experience one or more of the following problems when you publish a database with a binary collation for merge replication on a prior build of SQL Server and you upgrade to SQL Server 2000 SP3, or when you try to publish a database with binary collation for merge replication, after you inst
ON Technology Releases Java Application Developers Kit
ON Technology (Nasdaq: ONTC), a leading provider of enterprise infrastructure management solutions, announced the immediate availability of the ON Application Developers Kit (ADK). The new offering provides a series of open programming interfaces that significantly reduce implementation time by all
The OS: More Important Than You Know
By Brian Moran – Remember the OS? It’s that boring piece of software that our database engines run on. We database professionals strive for performance improvement. But while we’re worrying about tweaks, we forget about the easy changes.
Report: SQL Server Experiences Growth in Database Market
By Keith Furman – According to a new report from research firm Gartner, the database market experienced a decline in sales in 2002, but Microsoft SQL Server experienced a substantial increase in sales and market share. In 2002, economic troubles hit the database market, which saw sales decline 7 per
Make SQL Server Respond to an ORDER BY Clause
by Susan Harkins, Martin W. P. Reid – SQL Server Views don’t support the ORDER BY clause, but that shouldn’t stop you from bringing order to your data. This article teaches you how to sort the results of a View, despite this small limitation.
Row Count and Memory Utilization
Want to figure out how big your data tables are? SQL Server Magazine’s Brian Moran shows you how to query the system tables for this info without perform COUNT* functions on every table in the database.
Moving entire SQL Server user databases
by Eli Leiba – Here are several procedures that you can use to “move” all of your user databases from one SQL Server to another with ease.
SQL Server DTS Best Practices
By Vyas Kondreddi – Microsoft released Data Transformation Services (DTS) along with SQL Server 7.0. A very powerful, easy to use, graphical tool for importing, exporting and transforming data, which is only available as a costly add-on in other RDBMS products like Oracle. Prior to SQL Server 7.0, a
