We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.
SQL SERVER – Quick Note of Database Mirroring
Just a day ago, I was invited at Round Table meeting at prestigious organization. They were planning to implement High Availability solution using Database Mirroring. During the meeting, I have made few notes of what was being discussed there. I just thought it would be interested for all of you…
Read MoreSQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU
This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number…
Read MoreSQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You
We Loaded 1TB in 30 Minutes with SSIS, and So Can You SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009 In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30…
Read MoreSQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
Note: Download SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update) Authored by Microsoft SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is…
Read MoreSQLAuthority News – Download Microsoft SQL Server JDBC Driver 3.0 CTP 1
Note:Â Download Microsoft SQL Server JDBC Driver 3.0 CTP 1 Authored by Microsoft Download the SQL Server JDBC Driver 3.0 CTP, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5. In its continued commitment to…
Read MoreSQL SERVER – Checklist for Analyzing Slow-Running Queries
I am recently working on upgrading my class Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning with additional details and more interesting examples. While working on slide deck I realized that I need to have one solid slide which talks about checklist for analyzing slow running queries. A…
Read More