SQL Performance Archives - Page 49 of 100 - SQL Authority with Pinal Dave

SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10

November 22, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

There are many performance counters available in SQL Server which can be used to monitor various parameters of SQL Server engine. Have you ever been into a situation where you want to see value in performance counter for a query which you have returned? Imagine a situation where you want…

SQL SERVER – Performance Counter Missing: How to Get Them Back?

November 7, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Of the thousands of mails I receive every day about SQL Server problems, I was recently pinged by a friend who reported a weird problem. He started with a simple question. He said that he wants to monitor SQL Server Performance counters for complete day to send a report back…

SQL SERVER – Search Records with Single Quotes – SQL in Sixty Seconds #075

October 22, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL Server Management Studio

Earlier I wrote two blog posts about Search Records with Single Quotes in two parts. Refer the blog posts over here. Search Records with Single Quotes Search Records with Single Quotes – Part 2 Though I had clarified that all the methods displayed in these two blog posts have the exact same…

SQL SERVER – Do You Know Your Data’s Classification? – Notes from the Field #050

October 16, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field

[Notes from Pinal]: Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that developers do not know their data, they are often confused with the same and not sure how to answer that. My…

SQL SERVER – Row Offset in SQL Server For Different Version

October 10, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years old product and I encounter is less and less every day on…

SQL SERVER – Performance Dashboard – Historic Information

September 26, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Reports

There are a lot of games that I play with my daughter in spare time. Some of them are for just for fun and a lot of them are fun filled with some learning. As she started to grow up, it was important for me to weave learning into her…

SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047

September 25, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field

[Notes from Pinal]: There are few things which confuse us when we encounter first time, however, there are few concepts which confuses us even though we face them multiple times. One of the such subjects is database taking a long time to create. Think about it, if you see a…