SQL Scripts Archives - Page 310 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Good, Better and Best Programming Techniques

April 28, 2007

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger

A week ago, I was invited to meeting of programmers. Subject of meeting was “Good, Better and Best Programming Techniques”. I had made small note before I went to meeting, so if I have to talk about or discuss SQL Server it can come handy. Well, I did not get…

SQL SERVER – Query to Retrieve the Nth Maximum Value

April 27, 2007

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Joins, SQL Scripts, SQL Server

Replace Employee with your table name, and Salary with your column name. Where N is the level of Salary to be determined. Let us see a query to retrieve the Nth Maximum Value.

SQL SERVER – Locking Hints and Examples

April 27, 2007

Pinal Dave

SQL Tips and Tricks

SQL Lock, SQL Scripts, SQL Server

Locking Hints and Examples are as follows. The usage of them is the same but the effect is different. Let us learn it today together.

SQL SERVER – SELECT vs. SET Performance Comparison

April 27, 2007

Pinal Dave

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

SQL Download, SQL Scripts, SQL Server Security

Usage: SELECT : Designed to return data. SET : Designed to assign values to local variables. While testing the performance of the following two scripts in query analyzer, interesting results are discovered. SET @foo1 = 1; SET @foo2 = 2; SET @foo3 = 3; SELECT @foo1 = 1, @foo2 =…

SQL SERVER – Difference Between Unique Index vs Unique Constraint

April 26, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts

Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both. Add Unique Constraint ALTER TABLE dbo.<tablename> ADD CONSTRAINT <namingconventionconstraint> UNIQUE NONCLUSTERED ( <columnname> ) ON [PRIMARY] Add Unique Index CREATE UNIQUE NONCLUSTERED INDEX <namingconventionconstraint> ON dbo.<tablename> ( <columnname> ) ON [PRIMARY] There…

SQL SERVER – Enable xp_cmdshell using sp_configure

April 26, 2007

Pinal Dave

SQL

Powershell, SQL Advanced Option, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Utility

The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.

SQL SERVER – ERROR Messages – sysmessages error severity level

April 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security

SQL ERROR Messages

Each error message displayed by SQL Server has an associated error message number that uniquely identifies the type of error. The error severity levels provide a quick reference for you about the nature of the error. The error state number is an integer value between 1 and 127; it represents information about the source that issued the error. The error message is a description of the error that occurred. The error messages are stored in the sysmessages system table.