2001-05-13
2,560 reads
2001-05-13
2,560 reads
2001-05-13
2,906 reads
2001-05-11
3,009 reads
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,830 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,380 reads
2001-05-11
2,296 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,046 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,481 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,102 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,529 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers