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 – T-SQL Script to find the CD key from Registry
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 – 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 – Script to find SQL Server on Network
SQL SERVER – Stored Procedures Advantages and Best Advantage
SQL SERVER – CASE Statement/Expression Examples and Explanation
SQL SERVER – Raid Configuration – RAID 10
SQL SERVER – Six Properties of Relational Tables
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 – SQL Code Formatter Tools
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 Database Coding Standards and Guidelines Complete List Download
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 – 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 : Similarity and Difference #TempTable vs @TempVariable
SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
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 – 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
Reference : Pinal Dave (https://darkslategrey-bat-805937.hostingersite.com)
