Microsoft is continuously releasing System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance
SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions
I earlier wrote about DBA Quiz at All was well few moments before all went wrong – Reasons and Resolutions. I have even announced that I will give away one print book of SQL Wait Stats book. SQL Programming Joes 2 Pros (vol 4) [Amazon] | [Flipkart]- Chapter 13 has…
Read MoreSQL SERVER – Server Side Paging in SQL Server CE (Compact Edition)
SQL Server Denali is coming up with new T-SQL of Paging. I have written about the same earlier. SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison SQL SERVER – Server Side Paging…
Read More
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
In my recent Office Hours, I received a question on how to determine the case sensitivity of the database. Let us learn about how we can Detecting Database Case Sensitive Property using fn_helpcollations().
SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special
Get SQL Wait Stats – Kindle Edition Last month I released my SQL Wait Stats book. This book is the beginning of my journey in wait stats. It has been extremely popular and so far in India it has sold all the print copies twice on Flipkart. This book is…
Read MoreSQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers
This blog post is written in response to the T-SQL Tuesday post of JOIN. This is a very interesting subject. Years ago, I wrote my article about SQL SERVER – Introduction to JOINs – Basic of JOINs, ‑ till date, it is my most favorite article on the blog. Today…
Read MoreSQL SERVER – CE – 3 Links to Performance Tuning Compact Edition
Today, I am going to do webcast online on how to improve performance for SQL CE. Here are three articles which I am going to base my session. Database Design and Performance (SQL Server Compact Edition) Use Database Denormalization Decide Between Variable and Fixed-length Columns Create Smaller Row Lengths Use…
Read More