Fragmentation in SQL Server is a huge debate. Does it matter? How much is too much? What should you do? In any case, new author Nicholas Cain has put together a system that allows him to keep track of the levels of fragmentation as well as defragment those tables when he feels they are getting too spread apart.
2007-10-02 (first published: 2004-06-04)
34,730 reads
2004-06-02
1,743 reads
2004-06-01
867 reads
Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.
2004-06-01
11,663 reads
2004-05-28
1,481 reads
2004-05-27
2,046 reads
2004-05-26
1,822 reads
2004-05-25
2,008 reads
Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.
2004-05-24
13,472 reads
2004-05-21
1,934 reads
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Which of these inputs is the smaller input to a hash join?
See possible answers