After successfully delivering many corporate training as well as the private training we are launching the Public Training in Hyderabad for SQL Server 2008. I will be leading the training on Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training.
SQL SERVER – Attach mdf file without ldf file in Database
Background Story: One of my friends recently called up and asked me if I had spare time to look at his database and give him a performance tuning advice. Because I had some free time to help him out, I said yes. I asked him to send me the details…
Read MoreSQLAuthority News – Free Download – Microsoft SQL Server 2008 R2 RTM – Express with Management Tools – SQL Server 2008 R2 Books Online
This blog post is in response to several inquiry about Free Download of SQL Server 2008 R2 RTM. Microsoft has announced SQL Server 2008 R2 as RTM (Release To Manufacture). Microsoft® SQL Server® 2008 R2 Express is a powerful and reliable data management system that delivers a rich set of…
Read MoreSQL SERVER – T-SQL Script to Take Database Offline – Take Database Online
Blog reader Joyesh Mitra recently left a comment to one of my very old posts about SQL SERVER – 2005 Take Off Line or Detach Database, which I have written focusing on taking the database offline. However, I did not include how to bring the offline database to online in…
Read MoreSQL SERVER – Update Statistics are Sampled By Default
After reading my earlier post SQL SERVER – Create Primary Key with Specific Name when Creating Table on Statistics, I have received another question by a blog reader. The question is as follows: Question: Are the statistics sampled by default? Answer: Yes. The sampling rate can be specified by the…
Read MoreSQL SERVER – Create Primary Key with Specific Name when Creating Table
It is interesting how sometimes the documentation of simple concepts is not available online. I had received email from one of the reader where he has asked how to create Primary key with a specific name when creating the table itself. He said, he knows the method where he can…
Read More
SQL SERVER – When Are Statistics Updated – What Triggers Statistics to Update
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times. When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling questions and more.
SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit
During several recent training courses, I found it very interesting that Worker Thread is not quite known to everyone despite the fact that it is a very important feature. At some point in the discussion, one of the attendees mentioned that we can double the Worker Thread if we double…
Read MoreSQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats
Few days ago, I wrote about SQL SERVER – Find Current Location of Data and Log File of All the Database. There was very interesting conversation in comments by blog readers. Blog reader and SQL Expert Sreedhar has very interesting DMV presented which lists the most active database in SQL…
Read More
SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2
Microsoft Press has published a FREE eBook on the most awaiting releases of SQL Server 2008 R2. The book is written by Ross Mistry and Stacia Misner. Ross is my personal friend and one of the most active book writers in SQL Server Domain. When I see his name on any book, I am sure that it will be high quality and easy to read book.