Have an older workstation with only a little hard drive space? Tired of the SQL Server tools taking about a hundred megs on your most precious drive? If you answered yes to either one of those questions, then this quick tip is for you.
2001-05-11
2,825 reads
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,368 reads
2001-05-11
2,281 reads
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
17,020 reads
Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.
2001-05-10
6,457 reads
Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.
2001-05-10
6,090 reads
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,398 reads
In this article, Brian Knight shows you how to convert data stored in DB2 to SQL Server using DTS.
2001-05-09
7,159 reads
A response from Great Plains Software on the use of the sa account in Dynamics software.
2001-05-09
4,472 reads
Were you aware that the act of populating a temporary table can cause system-wide bottlenecks on your server? Problems can occur both with SQL Server 6.5 and 7.0/2000 in different ways, and in this article Neil Boyle discusses how best to avoid them.
2001-05-08
8,976 reads
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
I am not understanding why this command completes "successfully" and it seems correct to...
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Which of these indexes is superseded by another?
See possible answers