SQL Server DBCC Archives - Page 9 of 13 - SQL Authority with Pinal Dave

SQL SERVER – Refresh Database Using T-SQL

November 7, 2008

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

SQL Scripts, SQL Server DBCC, SQL Stored Procedure

Yesterday I received following questions on blog. Ashish Agarwal asked following question. Hi Pinal, Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query? If yes, can you please tell me the query? Thanks, Ashish Agarwal Answer…

SQL SERVER – 2008 – Interview Questions and Answers – Part 8

September 19, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility

Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What is Data Compression? In SQL SERVE 2008 Data Compression comes in two flavors: Row Compression Page Compression Row Compression Row compression changes the format of physical storage…

SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log

August 21, 2008

Pinal Dave

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

SQL Backup and Restore, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log works and Shrinking of Log works. Question from lauraV Please help me understand. I am taking a…

SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run

July 25, 2008

Pinal Dave

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

SQL Server DBCC

If you are DBA who are involved with Database Maintenance and file group maintenance, you must have experience that many times DBCC SHRINKFILE operations takes long time but any other operations with Database are relative quicker. Rebuilding index is quite resource intensive task but that happens faster than DBCC SHRINKFILE.…

SQL SERVER – Clear SQL Server Memory Caches

July 22, 2008

Pinal Dave

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

SQL Scripts, SQL Server DBCC

If SQL Server is running slow and operations are throwing errors due to lack of memory, it is necessary to look into memory issue. If SQL Server is restarted all the cache memory is automatically cleaned up. In production server it is not possible to restart the server. In this…

SQL SERVER – Find Current Identity of Table

June 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server DBCC

Many times we need to know what is the current identity of the column. I have found one of my developer using aggregated function MAX() to find the current identity. USE AdventureWorks GO SELECT MAX(AddressID) FROM Person.Address GO However, I prefer following DBCC command to figure out current identity. USE AdventureWorks…

SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold

March 4, 2008

Pinal Dave

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

SQL Error Messages, SQL Index, SQL Scripts, SQL Server DBCC

Just a day ago, I received email from regular reader Rajiv Kayasthy about a script which demonstrates the A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold. He found this script on TechNet BOL and was attempting to run on SQL Server…