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

SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index

May 12, 2010

This blog is in response to the ongoing communication with the reader who had earlier asked the question of SQL SERVER – Disable Clustered Index and Data Insert. The same reader has asked me the difference between ALTER INDEX ALL REBUILD and ALTER INDEX REBUILD along with disabled clustered index.…

SQL SERVER – Size of Index Table for Each Index – Solution 2

May 9, 2010

Pinal Dave

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

SQL Data Storage, SQL Index, SQL Scripts

Earlier I had ran puzzle where I asked question regarding size of index table for each index in database over here SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table. I had received good amount answers and I had blogged…

SQLAuthority News – MSDN Flash Mentions – TechNet Flash Mention – Top Community Contributors (Annual) Winner

May 8, 2010

Pinal Dave

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

I was going over my email to reach the famous Inbox (0), and I happened to come across TechNet Flash and MSDN Flash emails. I had kept them because those email editions had my names mentioned in them. Immediately, I took the screenshot of these. I am posting them here…

SQLAuthority News – List of Master Data Services White Paper

May 7, 2010

Pinal Dave

SQL

Master Data Services, SQL Documentation, SQL Download, SQL Server, SQL White Papers

Since my TechEd India 2010 presentation I am very excited with SQL Server 2010 Master Data Services. I just come across very interesting white paper on Microsoft site related to this subject. Here is the list of the same and location where you can download them. They are all written by Top Experts at Microsoft.

SQLAuthority News – SQL Server 2008 R2 Hosted Trial

May 6, 2010

Pinal Dave

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

SQL PASS

This is a bit old news but for me but it will new for many of you know. SQLPASS, Dell, Microsoft and MaximumASP has come together and build hosted environment for free to all of us to use and experiment with. Register now to try out up to seven labs:…

SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password

May 6, 2010

Pinal Dave

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

SQL Server Security

In the last week, I have received calls from friends who told me that they have got strange emails from me. To my surprise, I did not send them any emails. I was not worried until my wife complained that she was not able to find one of the very…

SQL SERVER – Get Latest SQL Query for Sessions – DMV

May 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts

In recent SQL Training I was asked, how can one figure out what was the last SQL Statement executed in sessions. The query for this is very simple. It uses two DMVs and created following quick script for the same. SELECT session_id, TEXT FROM sys.dm_exec_connections CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle) AS ST While…