From the category archives:

SQL Server

Query Optimization Statistics used by SQL SERVER

Thumbnail image for Query Optimization Statistics used by SQL SERVER April 13, 2011

Recently I came across a user request to create statistics on few newly created indexes. Index names were not provided to use so we had to figure out the indexes created in last 2 days and them create statistics on those indexes.Also, AUTO_CREATE_STATISTICS option was OFF when these indexes were created. I noticed three things [...]

0 comments Read the full article →

Looking forward to 24 hours of PASS – The Professional Association for SQL Server

Thumbnail image for Looking forward to 24 hours of PASS – The Professional Association for SQL Server March 15, 2011

At last the wait seems to be over  – 24 hours of PASS is here with an exceptional lineup of SQL Server and BI experts from around the world.If you missed this -  There is still time and you can register here. The event is on March 15-16, 2011 (Check for timezones here) This week [...]

1 comment Read the full article →

Downgrade SSIS 2008 package to 2005 | SQL Server Integration Services

Thumbnail image for Downgrade SSIS 2008 package to 2005 | SQL Server Integration Services January 14, 2011

Recently I came across few SSIS packages that were upgraded to SSIS 2008. Since the database server that hosts these packages is still 2005, We had to figure put some way to downgrade the package. As it turned out,there is no way for downgrading a package from SQL 2008 to SQL 2005. The only option [...]

1 comment Read the full article →

Installing AdventureWorks for SQL Server 2011 (Denali) – Problems and Solutions

Thumbnail image for Installing AdventureWorks for SQL Server 2011 (Denali) – Problems and Solutions December 10, 2010

I installed SQL Server 2011 – Code Named Denali CTP 1 yesterday on my personal machine. And tried installing sample database AdventureWorks2008R2 Database for Denali.Its available as a separate download. I tried installing it on my server using the following code: CREATE DATABASE AdventureWorks2008R2 ON (FILENAME = ‘J:\SQL SERVER TRAINING\SQL Server 2011\AdventureWorks2008R2_Data.mdf’) FOR ATTACH_REBUILD_LOG ; [...]

0 comments Read the full article →

Next Entries →