SQL Scripts Archives - Page 212 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Running Multiple Batch Files Together in Parallel

March 6, 2011

Recently I was preparing a demo for my next technical session, I had to do run a SQL code in parallel. I decided to use Batch File to run the code. I am not the best guy to with command shell so I did it with following setup. Code of…

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…

SQL SERVER – Summary of Month – Wait Stats and Wait Type – Day 28 of 28

February 28, 2011

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Wait Stats

I am glad to announce that the month of Wait Types, Wait Stats and Queues is very successful. I am glad that it was very well received and there was a great amount of participation from the community.

SQL SERVER – 2000 – DBCC SQLPERF(waitstats) – Wait Type – Day 24 of 28

February 24, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Wait Stats

I have received many comments, email, suggestions and motivations for my current series of wait types and wait statistics. One of the questions which I keep on receiving almost every other day is whether all of the discussions I have presented so far are also applicable to SQL Server 2000.…

SQL SERVER – LOGBUFFER – Wait Type – Day 18 of 28

February 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Wait Stats

At first, I was not planning to write about this wait type. The reason was simple- I have faced this only once in my lifetime so far maybe because it is one of the top 5 wait types. I am not sure if it is a common wait type or…

SQL SERVER – WRITELOG – Wait Type – Day 17 of 28

February 17, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Wait Stats

WRITELOG is one of the most interesting wait types. So far we have seen a lot of different wait types, but this log type is associated with log file which makes it interesting to deal with.

SQL SERVER – FT_IFTS_SCHEDULER_IDLE_WAIT – Full Text – Wait Type – Day 13 of 28

February 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Wait Stats

In the last few days during this series, I got many question about this Wait type. It would be great if you read my original related wait stats query in the first post because I have filtered it out in WHERE clause. However, I still get questions about this being…