April « 2010 « SQL Server Journey with SQL Authority

Archive for April, 2010

SQL SERVER – When are Statistics Updated – What triggers Statistics to Update

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SQL Statistics on April 21, 2010 | 13 Comments »

Update: Thank you Paul Randal for your comment. With your comment, I think now this post is complete. 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 [...]

Read Full Post »

SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit

Posted in Pinal Dave, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, T SQL, Technology on April 20, 2010 | 5 Comments »

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 the CPU (add the same [...]

Read Full Post »

SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 19, 2010 | 2 Comments »

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 Server. For quick reference he [...]

Read Full Post »

SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2

Posted in Business Intelligence, Pinal Dave, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on April 18, 2010 | 5 Comments »

Microsoft Press has published FREE eBook on the most awaiting release of SQL Server 2008 R2. The book is written by Ross Mistry (@rossmistry) and Stacia Misner. Ross is my personal friend and one of the most active book writer in SQL Server Domain. When I see his name on any book, I am sure [...]

Read Full Post »

SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS)

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 17, 2010 | 15 Comments »

This is tool is pretty old, yet always comes as a handy tip. I had a great trip at TechEd in India. And, during one of my presentations, I was asked if there are any shortcuts to SELECT only TOP 100 records from SSMS. I immediately told him that if he explores the table in [...]

Read Full Post »

« Newer Posts - Older Posts »