|
Solution Search:
|
SQL Server Resource Center
How to configure storage in SQL Server DB with more writes than reads
databases have a record written once and then read, and many times the data is written once but rarely read until it is archived or deleted. These systems...
More...
Nov 25, 2008
Avoid cursors in SQL Server with these methods to loop over records
have beaten up on SQL Server cursors -- database objects that manipulate data in a set on a row-by-row basis -- and I want to add my name to the list of people who wish...
More...
Nov 17, 2008
Tutorial: SQL Server Integration Services (SSIS) best practices
Whether you plan to migrate SQL Server Data Transformation Services (DTS) packages to SQL Server Integration Services (SSIS) or...
More...
Nov 17, 2008
Solve SQL Server errors and more from the DBA trenches -- part 2
mirroring connection error 4 'An error occurred while receiving data: '64(The specified network name is no longer available.)' for 'TCP://IMPORTANTMACHINE...
More...
Nov 13, 2008
SQL Related Articles
Microsoft offers beefed-up backup beta
of Microsoft's real-time backup tools.
Released Wednesday, System Center Data Protection Manager 2006 version 2 now covers several Windows server workloads including Exchange 2000 Server, Exchange Server... More... Sep 27, 2006
Saying yes, no or maybe to stored procedures
was vendor lock-in. In former times, there were quite a number of different data bases to get locked into.
The issue seems to have paled some as the number of mainstream data bases has diminished. We should always be... More... Aug 16, 2006
|