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

SQL SERVER – Fast Track Data Warehouse for SQL Server 2008

June 26, 2010

Best Practices, Business Intelligence, Data Warehousing

I recently attended a wonderful training session organized by Microsoft on Fast Track Data Warehouse Reference Architectures. If you are regular reader of my blog, you will be well aware of the fact that I am more of the Relational guy than a Business Intelligence professional. I was initially a…

SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer

June 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Documentation, SQL Download

Microsoft has released wonderful tool SQL Server 2008 R2 Best Practices Analyzer. I have previously used this tool and found it quite helpful. Here is the latest version which you can download from MS site. Microsoft SQL Server 2008 R2 Best Practices Analyzer However, I received quite a few emails…

SQL SERVER – Find Largest Supported DML Operation – Question to You

June 16, 2010

Pinal Dave

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

Best Practices

SQL Server is very big and it is not possible to know everything in SQL Server but we all keep learning. Recently I was going over the best practices of transactions log and I come across following statement. The log size must be at least twice the size of largest…

SQL SERVER – Enumerations in Relational Database – Best Practice

March 22, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, Software Development, SQL Documentation

Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1…

SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

February 21, 2010

Pinal Dave

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

Best Practices, SQL Scripts

Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click…

SQL SERVER – Stored Procedure Optimization Tips – Best Practices

February 16, 2010

Pinal Dave

SQL Performance

Best Practices, SQL Coding Standards, SQL Scripts, SQL Server, SQL Stored Procedure

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles.

SQLAuthority News – SQL Server Migration QuickStart

January 13, 2010

Pinal Dave

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

Best Practices, Database, SQL Documentation, SQL Download

The SQL Server Migration QuickStart includes a comprehensive set of technical content including presentations, whitepapers and demos that are designed to help you get details about how to approach your customers who want to improve the return on investment from their data platforms by migrating to SQL Server from their…