SQL Server Archives - Page 240 of 393 - 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 – 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…

SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training

May 4, 2010

Pinal Dave

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

SQL Training

Last 3 days to register for the courses. This is one time offer with big discount. The deadline for the course registration is 5th May, 2010. There are two different courses are offered by Solid Quality Mentors 1) Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning – Pinal Dave…