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

SQL SERVER – Pending IO request in SQL Server – DMV

March 13, 2011

I received following question: “How do we know how many pending IO requests are there for database files (.mdf, .ldf) individually?” Very interesting question and indeed answer is very interesting as well. Here is the quick script which I use to find the same. It has to be run in…

SQLAuthority News – Download – Microsoft SQL Server Compact 4.0

March 12, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix,…

SQL SERVER – Finding Latch Statistics

March 11, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Last month I wrote SQL Server Wait Types and Queues series SQL SERVER – Summary of Month – Wait Type – Day 28 of 28. I had great fun to write the series. I learned a lot and I felt this has created some deep interest on the subject with…

SQLAuthority News – Stay Connected and Social Media

March 9, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I think I have finally gotten back my faith in social media. If you are following my blog I am sure you are aware of my views on social media – SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me. I was not happy about how social…

SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)

March 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Scripts

This blog post is written in response to the T-SQL Tuesday hosted by Jes Schultz Borland. Earlier today, I was presenting a 45-minute session at the Community College about “The Beginning SQL Server Database”. One of the students asked me the following question. What is the difference between COUNT(DISTINCT) vs…

SQL SERVER – Enable PowerPivot Plugin in Excel

March 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

PowerPivot

Recently I had interesting experience at one conference. My PowerPivot plugin got disabled and I had no clue how to enable the same. After while, I figured out how to enable the same. Once I got back from the event, I searched online and realize that many other people online…

SQL SERVER – Running Multiple Batch Files Together in Parallel

March 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

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…