[Pinal Dave]
Microsoft MVP - SQLFavorite Articles on SQLAuthority.com
Pinal Dave SQLAuthority Best Favorite Articles
Email : pinaldave "at" yahoo.com
Home Page: http://www.pinaldave.com
Blog Site: http://www.SQLAuthority.com
Favorite Articles on SQLAuthority.com
All articles will open in the same window.
SQL SERVER - Cursor to Kill All Process in Database
SQL SERVER - Find Stored Procedure Related to Table in Database - Search in All Stored procedure
SQL SERVER - Shrinking Truncate Log File - Log Full
SQL SERVER - Simple Example of Cursor
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case
SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
SQL SERVER - Delete Duplicate Records - Rows
SQL SERVER - QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation
SQL SERVER - Union vs. Union All - Which is better for performance?
SQL SERVER - DBCC RESEED Table Identity Value - Reset Table Identity
SQL SERVER - @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT - Retrieve Last Inserted Identity of Record
SQL SERVER - Difference between DISTINCT and GROUP BY - Distinct vs Group By
SQL SERVER - Index Seek Vs. Index Scan (Table Scan)
SQL SERVER - TempDB is Full. Move TempDB from one drive to another drive
SQL SERVER - T-SQL Paging Query Technique Comparison - SQL 2000 vs SQL 2005
SQL SERVER - Performance Optimization of SQL Query and FileGroups
SQL SERVER - Search Text Field - CHARINDEX vs PATINDEX
SQL SERVER - 2005 Explanation of TRY CATCH and ERROR Handling
SQL SERVER - Stored Procedures Advantages and Best Advantage
SQL SERVER - CASE Statement/Expression Examples and Explanation
SQL SERVER - Raid Configuration - RAID 10
SQL SERVER - Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
SQL SERVER - Query to Find Seed Values, Increment Values and Current Identity Column value of the table
SQL SERVER - TRIM() Function - UDF TRIM()
SQL SERVER - Difference between Unique Index vs Unique Constraint
SQL SERVER - 2005 Locking Hints and Examples
SQL SERVER - Good, Better and Best Programming Techniques
SQL SERVER - Random Number Generator Script - SQL Query
SQL SERVER - 2005 TOP Improvements/Enhancements
SQL SERVER - 2005/2000 Examples and Explanation for GOTO
SQL SERVER - Explanation SQL Commando GO
SQL SERVER - 2005 - List all the database
SQL SERVER - UDF - Function to Parse AlphaNumeric Characters from String
SQL SERVER - Disable Index - Enable Index - ALTER Index
SQL SERVER - 2005 - SSMS Change T-SQL Batch Separator
SQL SERVER - 2005 Comparison EXCEPT operator vs. NOT IN
SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
SQL SERVER - 2005 Find Table without Clustered Index - Find Table with no Primary Key
SQL SERVER - 2005 Limiting Result Sets by Using TABLESAMPLE - Examples
SQL SERVER - 2005 Change Database Compatible Level - Backward Compatibility
SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length
SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
SQL SERVER - Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY
SQL SERVER - 2005 - UDF - User Defined Function to Strip HTML - Parse HTML - No Regular Expression
SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
SQL SERVER - Explanation and Comparison of NULLIF and ISNULL
SQL SERVER - 2005 Row Overflow Data Explanation
SQL SERVER - Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild - SQL SERVER 2000 and SQL SERVER 2005
SQL SERVER - Comparison : Similarity and Difference #TempTable vs @TempVariable
SQL SERVER - Definition, Comparison and Difference between HAVING and WHERE Clause
SQL SERVER - 2005 - List All Stored Procedure Modified in Last N Days
SQL SERVER - Count Duplicate Records - Rows
SQL SERVER - CASE Statement in ORDER BY Clause - ORDER BY using Variable
SQL SERVER - Restore Database Without or With Backup - Everything About Restore and Backup
SQL SERVER - UDF - Function to Get Previous And Next Work Day - Exclude Saturday and Sunday
SQL SERVER - One Thing All DBA Must Know
SQL SERVER - 2005 - List Tables in Database Without Primary Key
SQL SERVER - 2005 - Find Stored Procedure Create Date and Modified Date
SQL SERVER - UDF - Validate Integer Function
SQL SERVER - What is SQL? How to pronounce SQL?
SQL SERVER - 2005 - Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
SQL SERVER - 2005 - Explanation and Script for Online Index Operations - Create, Rebuild, Drop
SQL SERVER - Find Last Day of Any Month - Current Previous Next
SQL SERVER - T-SQL Script to Insert Carriage Return and New Line Feed in Code
SQL SERVER - 2005 - T-SQL Script to Attach and Detach Database
SQL SERVER - Actual Execution Plan vs. Estimated Execution Plan
SQL SERVER - 2005 - Search Stored Procedure Code - Search Stored Procedure Text
SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database
SQL SERVER - 2005 - Find Tables With Primary Key Constraint in Database
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
SQL SERVER - UDF - User Defined Function - Get Number of Days in Month
SQL SERVER - 2005 - Start Stop Restart SQL Server From Command Prompt
SQL SERVER - 2005 - List All The Constraint of Database - Find Primary Key and Foreign Key Constraint in Database
SQL SERVER - UDF - Validate Positive Integer Function - Validate Natural Integer Function
SQL SERVER - Effect of TRANSACTION on Local Variable - After ROLLBACK and After COMMIT
SQL SERVER - 2005 - OUTPUT Clause Example and Explanation with INSERT, UPDATE, DELETE
SQL SERVER - 2005 - Sample Example of RANKING Functions - ROW_NUMBER, RANK, DENSE_RANK, NTILE
SQL SERVER - Three T-SQL Script to Create Primary Keys on Table
SQL SERVER - Set SERVER Level FILLFACTOR Using T-SQL Script
SQL SERVER - Simple Example of WHILE Loop With CONTINUE and BREAK Keywords
SQL SERVER - Disable All Triggers on a Database - Disable All Triggers on All Servers
SQL SERVER - Business Intelligence (BI) Basic Terms Explanation
SQL SERVER - 2005 2000 - Search String in Stored Procedure
SQL SERVER - DBCC CHECKDB Introduction and Explanation - DBCC CHECKDB Errors Solution
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
SQL SERVER - 2005 - List All Stored Procedure in Database
SQL SERVER - Solution - Log File Very Large - Log Full
SQL SERVER - Get Information of Index of Tables and Indexed Columns
SQL SERVER - Enabling Clustered and Non-Clustered Indexes - Interesting Fact
SQL SERVER - Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
SQL SERVER - Enabling Clustered and Non-Clustered Indexes - Interesting Fact
SQL SERVER - Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
SQL SERVER - TRUNCATE Cannott be Rolled Back Using Log Files After Transaction Session Is Closed
SQL SERVER - 2005 - Introduction and Explanation to SYNONYM - Helpful T-SQL Feature for Developer
SQL SERVER - 2005 - Export Data From SQL Server 2005 to Microsoft Excel Datasheet
SQL SERVER - Execute Same Query and Statement Multiple Times Using Command GO
SQL SERVER - 2005 - Display Fragmentation Information of Data and Indexes of Database Table
SQL SERVER - What is - DML, DDL, DCL and TCL - Introduction and Examples
SQLAuthority News - Job Description of Database Administrator (DBA) or Database Developer
SQL SERVER - 2005 - Database Table Partitioning Tutorial - How to Horizontal Partition Database Table
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
SQL SERVER - Get Current Database Name
SQL SERVER - Index Reorganize or Index Rebuild
SQL SERVER - UDF to Return a Calendar for Any Date for Any Year
SQL SERVER - SELECT 1 vs SELECT * - An Interesting Observation
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL
SQL SERVER - Sharpen Your Basic SQL Server Skills - Learn the distinctions between unique constraint and primary key constraint and the easiest way to get random rows from a table
SQL SERVER - Simple Example of Cursor - Sample Cursor Part 2
SQL SERVER - 2005 - Find Nth Highest Record from Database Table - Using Ranking Function ROW_NUMBER
SQL SERVER - Simple Puzzle Using Union and Union All
SQL SERVER - 2005 - Find Index Fragmentation Details - Slow Index Performance
SQL SERVER - 2005 - List All Column With Indentity Key In Specific Database
SQL SERVER - Find Nth Highest Salary of Employee - Query to Retrieve the Nth Maximum value
SQL SERVER - 15 Best Practices for Better Database Performance
SQL SERVER - 2005 - Connection Strings For .NET
SQL SERVER - Better Performance - LEFT JOIN or NOT IN?
SQL SERVER - Converting Subqueries to Joins
SQL SERVER - Download FAQ Sheet - SQL Server in One Page
SQL SERVER - Find Table in Every Database of SQL Server
SQL SERVER - 2000 - SQL SERVER - Delete Duplicate Records - Rows - Readers Contribution
SQL SERVER - T-SQL Script to Devide One Column into Two Column
SQL SERVER - Order Of Column In Index
SQL SERVER - PIVOT and UNPIVOT Table Examples
SQL SERVER - 2008 - Introduction to Policy Management - Enforcing Rules on SQL Server
SQL SERVER - Find Current Identity of Table
SQL SERVER - Difference Between DBMS and RDBMS
SQL SERVER - 2008 - Introduction to New Feature of Backup Compression
SQL SERVER - 2008 - Introduction to Row Compression
SQL SERVER - 2008 - Introduction to SPARSE Columns
