All Articles - SQL Authority with Pinal Dave

SQLAuthority News – SQL SERVER Database Administrator Job Description

May 18, 2008

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

I have previously written article about SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer. I have received quite a lot of request to update it or post something similar. Writing SQL Articles are easier then writing Job description for DBA. I have read many job description…

SQL SERVER – Ideal TempDB FileGrowth Value

May 17, 2008

Pinal Dave

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

SQL Server, SQL TempDB

Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site.

SQL SERVER – Find Table in Every Database of SQL Server – Part 3

May 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL Utility

Previously I wrote two articles about SQL SERVER – Find Table in Every Database of SQL Server SQL SERVER – Find Table in Every Database of SQL Server – Part 2 I recently received email from SQL Expert and Blog Reader Greg Steinkuhler. People like Greg Steinkuhler makes this whole…

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake

May 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQL Backup and Restore, SQL Data Storage, SQL Scripts

It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been long time since I wrote something funny on this blog. Recently, I have came across forum discussion regarding backup misery of one of the developer. I…

SQL SERVER – Orphaned MS DTC Transaction Information

May 14, 2008

Pinal Dave

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

SQL Error Messages, SQL Scripts

Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we figured out the case of it was orphaned MS DTC transaction. When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connection are working…

SQL SERVER – Four Basic SQL Statements – SQL Operations

May 13, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Coding Standards

There are four basic SQL Operations or SQL Statements. SELECT – This statement selects data from database tables. UPDATE – This statement updates existing data into database tables. INSERT – This statement inserts new data into database tables. DELETE – This statement deletes existing data from database tables. If you…

SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2

May 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Temp Table

Some questions never get old. One of them is temp table variable and temp table in SQL Server. I have previously wrote about this indepth here : SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable Recently I received question: Can temporary table have indexes? If yes, are…

SQL SERVER 2005 – Microsoft Will Release SP3 Soon

May 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Service Pack

I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not? Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Function Property – Deterministic or Non-Deterministic

May 10, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I recently received question through email that how to determine if any user defined function is deterministic or non-deterministic? First go through two articles I have written about deterministic and non-deterministic function. SQL SERVER – Deterministic Functions and Nondeterministic Functions SQL SERVER – 2005 – Use of Non-deterministic Function in…

SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

May 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers. Hi Pinal, Recently,…