SQL

Quick links – SQL server

News SQL 2008 Day 2 at Collaborate 2010 http://blogs.technet.com/dataplatforminsider/archive/2010/04/20/day-2-at-collaborate-2010.aspx SQL 2008 R2 SQL Server 2008 R2 Released to Manufacturing! http://blogs.technet.com/dataplatforminsider/archive/2010/04/21/sql-server-2008-r2-released-to-manufacturing.aspx Unisys Releases the First Pre-Packaged Data Warehouse Solution http://blogs.technet.com/dataplatforminsider/archive/2010/04/21/unisys-releases-the-first-pre-packaged-data-warehouse-solution.aspx Other Technical RollUp http://blogs.technet.com/trm/default.aspx Documents SQL 2005 Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques This best practices white paper discusses three many-to-many query performance optimization [...]

The Shrink Operation Is Blocked

Recently I was  shrinking temp DB database files, generally it wont take much time shrink the database however this time it was taking a long time. When checked the SQL server logs found below message. DBCC SHRINKFILE for file <ID> is waiting for the snapshot transaction with timestamp <number>and other snapshot transactions linked to timestamp [...]

Could not connect or execute SQL query

I was installing a SCCM for one of the new site.But this time, it was little bit different.SQL server was on remote server. Though I have added computer account to local administrator group of remote sql box and configured 1433 at firewall, it gave me error “could not connect or execute SQL query” what is [...]