All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Find Current System Date Time and Time Offset

July 31, 2008

If you want to find current datetime in SQL Server I suggest to read the following post : SQL SERVER – Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()} This post is related to new feature available in SQL Server 2008. In SQL Server 2008 there is…

SQLAuthority News – Author BirthDay – SQL Server Birthday

July 30, 2008

Pinal Dave

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

Database, DBA

It always suprise me how many people remember my birthday and take time from their busy life to call me, email me, wish me or send me their warm greetings. I would like to express my gratitude to them. Today is my birthday and I had decided to take a…

SQL SERVER – SQL SERVER – Simple Example of Recursive CTE – Part 2 – MAXRECURSION – Prevent CTE Infinite Loop

July 29, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTE, SQL Joins, SQL Scripts

Yesterday I wrote about SQL SERVER – SQL SERVER – Simple Example of Recursive CTE. I right away received email from regular reader John Mildred that if I can prevent infinite recursion of CTE. Sure! recursion can be limited. Use the option of MAXRECURSION. USE AdventureWorks GO WITH Emp_CTE AS…

SQL SERVER – Simple Example of Recursive CTE

July 28, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTE, SQL Joins, SQL Scripts

Recursive is the process in which the query executes itself. It is used to get results based on the output of base query. We can use CTE as Recursive CTE (Common Table Expression). You can read my previous articles about CTE by searching at http://search.SQLAuthority.com . Here, the result of…

SQL SERVER – mssqlsystemresource – Resource Database

July 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL System Table

Just a day ago I received following email “Dear Pinal, While I was exploring my computer in directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data I have found database mssqlsystemresource. What is mssqlsystemresource? Thanks, Joseph Kazeka” Simple question like this are very interesting. mssqlsystemresource is Resource Database. It is read only database and…

SQLAuthority News – Readers Selection – Readers Most Favorite Articles

July 26, 2008

Pinal Dave

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

I have been receiving many emails from my readers about their favorite article. Few days ago, I asked in one of my post SQLAuthority News – Updated My Personal Book Mark Pages, which articles are most favorite articles of my readers. I have received tremendous response to my question and…

SQLAuthority News – SQLAuthority T-Shirts, Mug, Hat and Other Product

July 25, 2008

Pinal Dave

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

SQL T-Shirt

I frequently get request for SQLAuthority T-Shirts. After continuous requests from many of loyal readers, I am posting link to SQLAuthoirty Products. SQLAuthority Products I have no intention to make money from this site or any product sale. All the product are sold from the site directly at no profit…

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 – 2005 -Track Down Active Transactions Using T-SQL

July 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table, SQL Transactions

Just a day ago, I was wondering how many active transaction are currently in my database. I found following DMV very useful – very simple and to the point. Following SQL will return currently active transaction. SELECT * FROM sys.dm_tran_session_transactions Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Introduction to Log Viewer

July 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security, SQL Utility

SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 there is facility of the log viewer. It is very useful tool and very easy…