SQL Archives - Page 320 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Concurrency Problems and their Relationship with Isolation Level

March 4, 2011

Concurrency is simply put capability of the machine to support two or more transactions working with the same data at the same time. This usually comes up with data is being modified, as during the retrieval of the data this is not the issue. Most of the concurrency problems can…

SQL SERVER – Demo Script – Keeping CPU Busy

March 3, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently face very interesting situation, during presentations at event, I was asked very famous questions: “My CPU is very high all the time, how can I reduce it?” This is very interesting question and there are many answers and a single blog post is not good enough to justify this…

SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave

March 2, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Earlier this year Lohith (@kashyapa) from Bangalore took my ‘Uncut and Unedited’ video interview. It was really fun to answer his questions as it was very different from regular interview. He asked few personal details few technical details and made me show few secrets. [youtube=http://www.youtube.com/watch?v=k3yLkPt2LIc] I think if you want…

SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart

March 1, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Michael J. Swart is a very unique person. I have often exchanged emails with him and also used a couple of his scripts in my presentations (with his permission). Every time I conduct spatial database presentation, I always start with his script where he has drawn the wonderful image of…

SQL SERVER – Best Reference – Wait Type – Day 27 of 28

February 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

I have great learning experience to write my article series on Extended Event. This was truly learning experience where I have learned way more than I would have learned otherwise. Besides my blog series there was excellent quality reference available on internet which one can use to learn this subject…

SQL SERVER – Guest Post – Glenn Berry – Wait Type – Day 26 of 28

February 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS. He is also an Adjunct Faculty member at University College – University of Denver, where…

SQL SERVER – 2011 – Wait Type – Day 25 of 28

February 25, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

Since the beginning of the series, I have been getting the following question again and again: “What are the changes in SQL Server 2011 – Denali with respect to Wait Types?” SQL Server 2011 – Denali is yet to be released, and making statements on the subject will be inappropriate.…