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.
SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS)
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…
Read More
SQLAuthority News – Best Compliment – DBA Survivor: Become a Rock Star DBA
Today’s blog post is about the best compliment I have ever received. I am very, very happy and would like to share my feelings with you.
Thomas Larock (Blog | Twitter) (known as SQLRockstar) keeps the excellent ranking of the blogger in the SQL Server Arena. I am a big fan of this list and have been referring lots of people.
SQLAuthority News – Tips for Traveling to Nepal
If you are a regular reader of this blog, you might know that I travel nearly 20+ days out of 30 days in a month. There are cases when I don’t have a chance to go home for an entire month and my family has to travel to different cities just to meet me. During my recent visit, one of my acquaintances suggested that I should blog about my travel experiences as well. This can be helpful to others who are traveling to the country or city. This blog post is about Nepal.
SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing
What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process…
Read MoreSQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005
This article was written as a response to T-SQL Tuesday #005 – Reporting. The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about how to get more details about these three most important components using the Management Data…
Read MoreSQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005
If you are following my blog, you already know that I am more of “T-SQL and Performance Tuning” type of person. I do have a good understanding of Business Intelligence suit and I also do certain training sessions on the same subject. When I was writing the blog post for…
Read More