By Thomas Hundley on 6/14/2008 8:48 PM

 

I only need to do this every so often, but I always forget how to and end up looking it up.  Thus, I'm posting it here for reference.

 

 

Read More »

By Thomas Hundley on 6/14/2008 8:39 PM

Here is a script to rebuild all of your indexes on your database.  I find that indexes are often ignored once an application moves to production.  It's a good idea to evaluate your usage patterns and setup automated maintenance jobs to proactively rebuild indexes before fragmentation has a chance to adversely effect performance.  This is especialy important if you are using guids as primary keys and don't move the clustered index to a more logically sequential column. 

 

 -- Show fragmentation for all tables
EXECRead More »

By Thomas Hundley on 2/3/2008 4:12 PM

Did you know you can connect to SQLServer from your application using SSL?

Read More »

By Thomas Hundley on 2/3/2008 4:10 PM

Quick reference to the Microsoft SQL Server 2005 Whitepaper

Read More »

By Thomas Hundley on 4/21/2007 12:44 AM

Viewing and editing an existing SSIS package is limited to SQL Server Business Intelligence Development Studio (SSBIDS) or Visual Studio 2005 Team Suite (VSTS). Read More »

By Thomas Hundley on 4/21/2007 12:42 AM

I used SQL Server Integration Services (SSIS) Import & Export Wizard from SQL Server Management Studio (SSMS) to create an SSIS package and saved it to the server. I beat my head against the wall trying to find it via SSMS after I saved it. Read More »