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

SQL SERVER – Copy Column Headers in Query Analyzers in Result Set

May 1, 2007

Copy Column Headers in Query Analyzers in Result Set. In Query Analyzer go to Menu >> Tools >> Options >> Results Select Default results Target: Results to Text Results output format:(*): Tab Delimited Print column headers(*): Checkbox ON(check) [youtube=http://www.youtube.com/watch?v=BL5GO-jH3HA] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Server Interview Questions and Answers Complete List Download

April 21, 2007

Pinal Dave

SQL Interview Questions and Answers

Best Practices, Database, SQL Scripts, SQL Server

This is summary blog post for SQL Server Interview Questions and Answers. Click here to get free chapters (PDF) in the mailbox.

SQL SERVER – CASE Statement/Expression Examples and Explanation

April 14, 2007

Pinal Dave

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

Best Practices, SQL Scripts

CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions. Two basic formulations for CASE expression 1) Simple CASE…

SQL SERVER – Stored Procedures Advantages and Best Advantage

April 13, 2007

Pinal Dave

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

Best Practices, SQL Stored Procedure

There are many advantages of Stored Procedures. I was once asked what do I think is the most important feature of Stored Procedure? I have to pick only ONE. It is tough question. I answered : Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached…

SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

April 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Error Messages, SQL Server DBCC

Error Received: Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns SQL Server 2000 supports table with maximum 1024 columns. This errors happens when we try to create table with 1024 columns or try to add columns to table which exceeds more than 1024. Fix/Solution/WorkAround:…

SQL SERVER – Performance Optimization of SQL Query and FileGroups

April 5, 2007

Pinal Dave

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

Best Practices, SQL Download, SQL Index

It is suggested to place transaction logs on separate physical hard drives. In this manner, data can be recovered up to the second in the event of a media failure. In SQL 2005 When database is created without specifying a transaction log size, the transaction log will be re-sized to…

SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP)

March 31, 2007

Pinal Dave

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

Best Practices, Software Development, SQL Download

Microsoft has released a tool called the Microsoft SQL Server Best Practices Analyzer. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data from Microsoft Windows and SQL…