Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit

October 15, 2012

Rick Morelan and I were discussing earlier this month that what we can give back to the community. We believe our books are very much successful and very well received by the community. The five books are a journey from novice to expert. The books have changed many lives and…

SQL SERVER – Find First Non-Numeric Character from String

October 14, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

It is fun when you have to deal with simple problems and there are no out of the box solution. I am sure there are many cases when we needed the first non-numeric character from the string but there is no function available to identify that right away. Here is…

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

October 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL System Table

5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it. This is one of the script which every developer would like to keep it handy. I have…

SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

October 12, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

DQS, SQL Utility

There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data. In addition to the…

SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB

October 11, 2012

Pinal Dave

SQL Tips and Tricks

NuoDB

As regular readers know I’ve been spending some time working with the NuoDB beta software. They contacted me last week and asked if I would give you a chance to try their new web-based console for their scalable, SQL-compliant database. They have just put out their final beta release, Beta…

SQL SERVER – Find Rows and Index Count – SQL in Sixty Seconds #029 – Video

October 10, 2012

Pinal Dave

SQL Performance

Clustered Index, Database, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server Management Studio

There are a few questions I often get asked. I wonder how interesting is that in our daily life all of us have to often need the same kind of information at the same time. Here is the example of the similar questions about index count:

SQL SERVER – Identify Numbers of Non Clustered Index on Tables for Entire Database

October 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Here is the script which will give you numbers of non clustered indexes on any table in entire database. SELECT COUNT(i.TYPE) NoOfIndex, [schema_name] = s.name, table_name = o.name FROM sys.indexes i INNER JOIN sys.objects o ON i.[object_id] = o.[object_id] INNER JOIN sys.schemas s ON o.[schema_id] = s.[schema_id] WHERE o.TYPE IN…