Another excellent blogger here on SSC, Jeffery Yao, has posted up an interesting idea http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2009/04/20/database-administration-literature-criticism.aspx .
As a PASS chapter leader...
2009-04-19
448 reads
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially. If your data set is growing over time you will end up using any memory that is not consumed today.
2009-04-15
3,029 reads
I’ve often described SQL Server to people new to databases as a data pump.
Just like a water pump, you...
2009-04-13
1,217 reads
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially....
2009-04-11
1,402 reads
One of the fun facts about SQL Server and the relation model is the
whole concept of three valued logic. Now...
2009-04-09
1,102 reads
Technorati Tags: SQL Server,I/O"Any technology, no matter how primitive, is magic to those who do not understand it."
freefall
Arthur C. Clarke...
2009-04-05
592 reads
I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.
2008-12-18 (first published: 2008-11-14)
1,255 reads
This is based on Clint Herring's work and was better than what I was using ;). It has one user definded variable @path that is where to store the files generated. It will make one file per database and one master file to restore all user permissions into that database. Used mostly for DR and […]
2005-03-30 (first published: 2004-05-25)
1,015 reads
SQL Server has a rock solid backup and restore routine. However, it is not the most efficient way of handling the backups and restores. Neither in terms of time or space required. A number of software vendors have developed their own additions to SQL Server that accelerate or compress the backups (or both). Wesley Brown has taken four of these products into his environment and run some comparisons. Read about large databases in part 2 of this series.
2004-12-09
7,277 reads
SQL Server has a rock solid backup and restore routine. However, it is not the most efficient way of handling the backups and restores. Neither in terms of time or space required. A number of software vendors have developed their own additions to SQL Server that accelerate or compress the backups (or both). New Author Wesley Brown has taken four of these products into his environment and run some comparisons. Read part one of his review.
2004-12-07
10,756 reads
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Hello there. I have the following Pipeline I want to get the property error...
I'm installing a cluster prior to my 2019 SQL build. Failover Cluster tools...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers