SQLAuthority.com

Best Articles
Best Articles Of SQLAuthority
Favorite Articles
Pinal Dave's Preference
Readers' Selections
Readers' Finest Choice
SQL Script Bank
Useful SQL Server Scripts
Search SQLAuthority
Hunt using SQLAuthority
Job SQLAuthority.com
Let your dream come true
All - Articles
All Articles at one instance
MVP Profile
Exceptional Technical Community Leader
IP Address
Find your IP Address
Sitemap
List of Links from the site

Tip of the Minute

IDENTITY columns and timestamp columns can't have defaults bound to them.
--Pinal Dave

Latest Articles

SQL SERVER - 2008 - Introduction to Merge Statement - One Statement for ...
MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based ...
SQLAuthority News - Download SQL Server 2008 Report Builder 2.0 RC1
Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted ...
SQLAuthority News - SQL Server Express 2008 Downloads
Microsoft SQL Server 2008 Express with Tools Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management ...
SQL SERVER - How to Rename a Column Name or Table Name
I often get request from blog reader for T-SQL script to rename database table column name or rename table itself. The script for renaming any column : SP_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]',  ...
SQLAuthority News - Ahmedabad SQL Server User Group Meeting - August 2008
I will be attending Ahmedabad SQL Server Usergroup Meeting on August 30, 2008. I will be taking session about ?SQL Server CTE and Recursive CTE?. The most important part of August Meeting is there will ...
SQLAuthority News - 4 Million Visits - over 675 SQL Server Articles
Thank you to all of my readers for supporting this blog. It has been wonderful journey all the way. I strongly encourage all my readers to actively contribute in discussion and writing article for blog. ...
SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server ...
Everyday I get lots of question regarding error : An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under ...
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Today in this article I would discuss about the Database Mail which is used to send the Email using SQL Server.  Previously I had discussed about SQL SERVER - Difference Between Database Mail and SQLMail. ...
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper ...
I had previously written SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case and I had really enjoyed writing it. Above script converts first letter of each word from sentence ...
SQL SERVER - Behind the Scene of SQL Server Activity of - Transaction ...
Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log ...
SQLAuthority News - Microsoft SQL Server Management Pack for Microsoft ...
The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2008, 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, ...
SQLAuthority News - Find Your IP Address - What Is My IP Address
While developing often my developers need to know which IP address is of local network when looked from outside. I am working in large outsourcing company and we have local intranet setup. When connecting ...
SQL SERVER - Disable All the Trigger of Current Database
I have previously written article about SQL SERVER - Disable All Triggers on a Database - Disable All Triggers on All Servers. This is alternate method to achieve the same task. Following article is sent ...
SQL SERVER - Detailed Explanation of Transaction Lock, Lock Type, Avoid
Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across ...

SQLAuthority.com - Reader's Favorite Articles

SQL Server Interview Questions and Answers Complete List Download
SQL Server Interview Questions and Answers - Introduction
SQL Server Interview Questions and Answers - Part 1
SQL Server Interview Questions and Answers - Part 2
SQL Server Interview Questions and Answers - Part 3
SQL Server Interview Questions and Answers - Part 4
SQL Server Interview Questions and Answers - Part 5
SQL Server Interview Questions and Answers - Part 6
SQL SERVER - Insert Multiple Records Using One Insert Statement
SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
Convert Text to Numbers (Integer) - CAST and CONVERT
SQL SERVER - Delete Duplicate Records - Rows
Cannot resolve collation conflict for equal to operation
SQL SERVER - Shrinking Truncate Log File - Log Full
SQL SERVER - TRIM() Function - UDF TRIM()

SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases - Part 2
SQL SERVER - Query to find number Rows, Columns, ByteSize for each table in the current database - Find Biggest Table in Database
SQL SERVER Database Coding Standards and Guidelines Complete List Download
SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server
SQL SERVER - Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
SQL SERVER - Simple Example of Cursor
SQL SERVER - CASE Statement/Expression Examples and Explanation
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice
SQL SERVER - @@IDENTITY vs IDENT_CURRENT - Retrieve Last Inserted Identity of Record
SQL SERVER - 2005 List All Tables of Database
SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download
SQL SERVER - CASE Statement in ORDER BY Clause - ORDER BY using Variable
SQL SERVER - 2005 Change Database Compatible Level - Backward Compatibility
SQL SERVER - Difference between Unique Index vs Unique Constraint
SQL SERVER - 2005 Locking Hints and Examples
SQL SERVER - Random Number Generator Script - SQL Query
SQL SERVER - Union vs. Union All - Which is better for performance?
SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database
SQL SERVER - DBCC RESEED Table Identity Value - Reset Table Identity
SQL SERVER - 2005 - Find Stored Procedure Create Date and Modified Date
SQL SERVER - Find Last Day of Any Month - Current Previous Next
SQL SERVER - TempDB is Full. Move TempDB from one drive to another drive.
SQL SERVER - Query to Find First and Last Day of Current Month
SQL SERVER - Simple Example of WHILE Loop With CONTINUE and BREAK Keywords

SQL SERVER - 2005 - Export Data From SQL Server 2005 to Microsoft Excel Datasheet
SQL SERVER - Index Seek Vs. Index Scan (Table Scan)
SQL SERVER - T-SQL Script to Insert Carriage Return and New Line Feed in Code
SQL SERVER - Count Duplicate Records - Rows
SQL SERVER - ReIndexing Database Tables and Update Statistics on Tables
SQL SERVER - Find Stored Procedure Related to Table in Database - Search in All Stored procedure
SQL SERVER - 2005 - List All Stored Procedure Modified in Last N Days
SQL SERVER - FIX : Error 3154: The backup set holds a backup of a database other than the existing database
SQL SERVER - FIX : Error 15023: User already exists in current database.
SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length
SQL SERVER - Difference between DISTINCT and GROUP BY - Distinct vs Group By
SQL SERVER - 2005 - Search Stored Procedure Code - Search Stored Procedure Text
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example