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

SQL SERVER – Disable All the Trigger of Current Database

August 19, 2008

I have previously written article about SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers. This is alternate method to achieve the same task. Following article is sent by Manish Kaushik. I recommend all of you to read original article along with this…

SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks

August 18, 2008

Pinal Dave

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

SQL Error Messages, SQL Scripts, SQL Server Security, SQL Transactions

Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across his two interesting comment on this blog and I would like to share this all of…

SQL SERVER – 2005 – Best Practices Analyzer (August 2008)

August 17, 2008

Pinal Dave

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

SQL Download, SQL Server Security, SQL Utility

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. This download is the August 2008 release of…

SQLAuthority News – Tip of the Minute

August 16, 2008

Pinal Dave

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

Best Practices, Database, DBA

Since my new personal website is launched I have received many comments and emails regarding new section of Tip of the Minute. Right navigation bar of the my personal website https://www.pinaldave.com/ contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip…

SQLAuthority News – Happy Indepedance Day to India

August 15, 2008

Pinal Dave

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

India’s Independence Day is celebrated on August 15 to commemorate its independence on that day in 1947. The day is a national holiday in India. India will celebrate its 61st Independent day on August 15, 2008. Happy Independence Day to India Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2008 – Introduction to Online Indexing Operation

August 15, 2008

Pinal Dave

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

SQL Index, SQL Scripts, SQL Server

When index is created or recreated it usually decreases performance of database. Either SQL takes long time for response or it does not response at all as transactions are blocked. When new table or database goes live it is not possible to find out exactly how many indexes are needed.…

SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website

August 13, 2008

Pinal Dave

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

Database, DBA, MVP

I am very pleased to announce my newly renovated website. I always liked my previous website as it was “Valid XHTML 1.1” and “Valid CSS 2.0”. Since I become MVP last month I have been receiving many emails where people were expecting more from my personal website. My blog http://www.SQLAuthority.com…