All Scripts – 1

SQL SERVER – Index Created on View not Used Often – Observation of the View
SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison
SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative
SQL SERVER – Solution – Challenge – Puzzle – Usage of FAST Hint

SQL SERVER – Solution – Puzzle – Challenge – Error While Converting Money to Decimal
SQL SERVER – Information Related to DATETIME and DATETIME2
SQL SERVER – Get All the Information of Database using sys.databases
SQL SERVER – Finding Last Backup Time for All Database
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
SQL SERVER – Find Total Number of Transaction on Interval
SQL SERVER – Get Query Running in Session
SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11
SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10
SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9

SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only
SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8

SQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7
SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6
SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5
SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4
SQL SERVER – Disabled Index and Index Levels and B-Tree
SQL SERVER – Find Automatically Created Statistics – T-SQL
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1
SQL SERVER – Computed Columns – Index and Performance
SQL SERVER – Computed Column – PERSISTED and Storage – Part 2
SQL SERVER – Function to Retrieve First Word of Sentence – String Operation
SQL SERVER – Negative Identity Seed Value and Negative Increment Interval
SQL SERVER – Computed Column and Performance – Part 3
SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server
SQL SERVER – Computed Column – PERSISTED and Performance – Part 2
SQL SERVER – Computed Column – PERSISTED and Performance
SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example
SQL SERVER – Find Queries using Parallelism from Cached Plan
SQL SERVER – Datetime Function TODATETIMEOFFSET Example
SQL SERVER – Datetime Function SWITCHOFFSET Example
SQL SERVER – The Self Join – Inner Join and Outer Join
SQL SERVER – Outer Join Not Allowed in Indexed Views
SQL SERVER – Default Statistics on Column – Automatic Statistics on Column
SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache
SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE
SQL SERVER – Difference Between DATETIME and DATETIME2
SQL SERVER – Difference Between GETDATE and SYSDATETIME
SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best
SQL SERVER – Convert IN to EXISTS – Performance Talk
SQL SERVER – Disabled Index and Update Statistics
SQL SERVER – DATE and TIME in SQL Server 2008
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell
SQL SERVER – Size of Index Table for Each Index – Solution 2
SQL SERVER – Get Latest SQL Query for Sessions – DMV
SQL SERVER – Get Latest SQL Query for Sessions – DMV
SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
SQL SERVER – Disable Clustered Index and Data Insert
SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online
SQL SERVER – Create Primary Key with Specific Name when Creating Table
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT
SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
SQL SERVER – Find the Size of Database File – Find the Size of Log File
SQL SERVER – Find Statistics Update Date – Update Statistics
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior
SQL SERVER – Find Location of Data File Using T-SQL
SQL SERVER – Get Date of All Weekdays or Weekends of the Year
SQL SERVER – ORDER BY Clause and TOP WITH TIES
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
SQL SERVER – Comma Separated Values (CSV) from Table Column
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
SQL SERVER – Recently Executed T-SQL Query

Comments are closed.