Best Practices Archives - Page 19 of 24 - SQL Authority with Pinal Dave

SQLAuthority Download – SQL Server Cheatsheet

June 25, 2008

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

Best Practices, Database, DBA, Software Development, SQL Cheat Sheet, SQL Download

I think this is most popular question I receive in email, if I have SQL Server cheat sheet. Well, SQL Server is very wide subject and covering all the main topics of SQL Server will take 100 pages book as cheat sheet. I have tried to create one page cheat…

SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance

May 21, 2008

Pinal Dave

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

Best Practices, Database

I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering…

SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks

May 19, 2008

Pinal Dave

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

Best Practices, Data Warehousing, Database, DBA, Software Development, SQL Server Security

Note : Download PPT by Microsoft Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks The Windows Live Security team shares best practices – from platform and network security to incident management – in providing security for web applications and infrastructure. Organizations across the globe face…

SQL SERVER – Download FAQ Sheet – SQL Server in One Page

April 28, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, Software Development, SQL Cheat Sheet, SQL Download

One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page.…

SQL SERVER – Query Analyzer Shortcuts – Part 2

April 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Shortcut

I enjoy reader’s articles to read as much as I enjoy expert’s articles. One of blog reader Praveen Barath always have good ideas to share. Here is Praveen Barath’s comment on my previous article Query Analyzer Shortcuts. MSSQL server 2005 is a database platform , Platform because from one window…

SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article

April 26, 2008

Pinal Dave

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

Best Practices, Database

This article has been written by blog reader and SQL Server Expert Praveen Barath in response to my previous article SQL SERVER – Optimization Rules of Thumb – Best Practices. Well Query Optimizations rules are not limited. It depends on business needs as well, For example we always suggest to…

SQL SERVER – Optimization Rules of Thumb – Best Practices

April 25, 2008

Pinal Dave

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

Best Practices, SQL Index

There are few rules for optimizing slow running query. Let us look at them one by one see how it can help. Rule # 1 : Always look at query plan first. I always start looking at query plan. There is always something which catches eyes. I pay special attention…