Tags » Pinal Dave

News About PASS For Week Ending May 2, 2015

Summary

Must read this week is Benefits for Some, All or Only a Few by PASS Board Member Grant Fritchey, and do read the comments as well. 214 more words

Weekly Summary

News About PASS For Week Ending December 20, 2014

Summary

Top things to read this week are Say Anything! PASS Summit Feedback and Ratings and PASS Summit Attendance and Predictions by Dev Nambi. Anyone who has run an event will appreciate the attempt to solve the challenge of guessing attendance for each session and assigning to the appropriate size room. 107 more words

Weekly Summary

SQL SERVER - 28 Links for Learning SQL Wait Stats from Beginning

It has been exact two years since I have written series on SQL Wait Statistics and Queues. I often received quite a few questions related to this subject. 448 more words

SQL Authority

SQL SERVER - FIX : Error 3154: The backup set holds a backup of a database other than the existing database - SSMS

This is a follow up of the blog post I have posted on error 3154 few years ago. I have received quite a few emails that how we can fix the same error with the help of SQL Server Management Studio. 171 more words

SQL Authority

SQL SERVER - Delay Command in SQL Server - SQL in Sixty Seconds #055

Have you ever needed WAIT or DELAY function in SQL Server?  Well, I personally have never needed it but I see lots of people asking for the same. 157 more words

SQL Authority

SQL SERVER - Maximize Database Performance with DB Optimizer - SQL in Sixty Seconds #054

Performance tuning is an interesting concept and everybody evaluates it differently. Every developer and DBA have different opinion about how one can do performance tuning. I personally believe performance tuning is a three step process… 396 more words

SQL Authority