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

SQL SERVER – Query Analyzer Shortcuts – Part 2

April 27, 2008

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…

SQLAuthority News – Authors Personal Bookmarks

April 25, 2008

Pinal Dave

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

Database, DBA, SQL Download

Just like everybody else I also keep my personal bookmarks of websites. Recently I have reorganized my bookmarks in two categories. Please visit them and let me know your opinion. SQLAuthority BEST Articles SQLAuthority FAVORITE Articles Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Download Microsoft Office Visio 2007 Professional SQL Server Add-In

April 24, 2008

Pinal Dave

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

SQL Documentation, SQL Download

Note : Download Microsoft Office Visio 2007 Professional SQL Server Add-In by Microsoft Visio Infrastructure for SQL Servers is a tool which is meant for IT administrators who require constant interactions with the users for the installations of the SQL server in any IT infrastructure. Visio Infrastructure for SQL Servers…

SQL SERVER – 2008 – Update Resolving Conflict Between SQL Server 2005 and SQL Server 2008

April 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

I have been receiving many complains where user has installed SQL Server 2008 and when trying to install SQL Server 2005 after that installation never completed. Well, Microsoft has provided solution for this issue. Download the patch and install it first and then try to install SQL Server 2005 and…

SQL SERVER – Identifiers As Valid Object Names

April 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

Previous I wrote blog post about SQL SERVER – Explanation and Example Four Part Name. It was explaining the new feature of SQL Server 2005 of Schema. Few days ago I received email from Chi-Ho, Min of Taiwan, he suggested that he was successfully able to use column without completely…