Welcome to SqlAdvice Sign in | Join | Help

Browse by Tags

All Tags » Tips And Tricks » How To's   (RSS)

Using Virtualization to fight ... Virtualization

Posted Thursday, April 20, 2006 4:54 PM by michael.k.campbell
VPN Software should come with big warning labels: "WARNING: Does not play well with others." As a consultant I frequently need to gain access to remote networks via VPN. This means I'm frequently hosing myself by installing yet another VPN client. That, Read More...
1 Comments

SQL Server Unit Testing: Sprocs

Posted Thursday, April 06, 2006 9:41 AM by michael.k.campbell
As a consultant, it's not uncommon for me to need to rewrite a poorly performing query or sproc without a full understanding of the underlying biz rules or context. Improved performance is the stated goal, but data fidelity is implied as critical. Enter Read More...
1 Comments

Nibbling Deletes - Intro

Posted Tuesday, September 20, 2005 11:10 PM by RepeatableRead
So, your application was a success. You're getting oodles and oodles of traffic. Only, it's building up faster than you had anticipated, and after a bit of calculation, you've determined that if the present trends persist, you'll have 24 TB of data within Read More...
10 Comments

Max Degree of Parallelism

Posted Tuesday, May 24, 2005 5:59 PM by RepeatableRead
In a previous life (actually two previous lives), I was a production DBA. One of the environments that I inherited had some ... issues. There were a number of Clustered SQL Server installations -- oodles of hardware, all churning to keep product inventory, Read More...
1 Comments

Custom Templates

Posted Monday, June 07, 2004 9:35 PM by RepeatableRead
Custom T-SQL Templates not only allow you to accomplish your job in a jiffy... they're awesome mnemonic tools. Read More...
2 Comments