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

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

October 12, 2012

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…

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…

SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan

October 9, 2012

Pinal Dave

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

Database, DBA, SQL PASS

Sri Sridharan is my old friend and we often talk on GTalk. The subject varies from Life in India/USA, movies, musics, and of course SQL. We have our differences when we talk about food or movie but we always agree when we talk about SQL. Yesterday while chatting with him…

SQL SERVER – Recover the Accidentally Renamed Table

October 8, 2012

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

I have no answer to following question. I saw a desperate email marked as urgent delivered in my mailbox. “I accidentally renamed table in my SSMS. I was scrolling very fast and I made mistakes. It was either because I double clicked or clicked on F2 (shortcut key for renaming).…

SQLAuthority News – Download Whitepaper – SQL Server Analysis Services to Hive

October 7, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL White Papers

The SQL Server Analysis Service is a very interesting subject and I always have enjoyed learning about it. You can read my earlier article over here. Big Data is my new interest and I have been exploring it recently. During this weekend this blog post caught my attention and I…

SQL SERVER – 3 Online SQL Courses at Pluralsight and Free Learning Resources

October 5, 2012

Pinal Dave

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

SQL in Sixty Seconds, SQL Training

Usain Bolt is an inspiration for all. He broke his own record multiple times because he wanted to do better! Read more about him on wikipedia. He is great and indeed fastest man on the planet. Usain Bolt – World’s Fastest Man “Can you teach me SQL Server Performance Tuning?”…

SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video

October 3, 2012

Pinal Dave

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

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

During performance tuning conversation the very first question people often ask is what are the queries offending the server or in another word let us identify the queries which are the most resource intensive. The resources are often described as either Memory, CPU or IO. When we talk about the…