All Scripts – 3

SQL SERVER – DISABLE and ENABLE user SA
SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL
SQL SERVER – Change Collation of Database Column – T-SQL Script
SQL SERVER – Find Collation of Database and Table Column Using T-SQL

SQL SERVER – Interesting Interview Questions
SQL SERVER – Default Collation of SQL Server 2008
SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema
SQL SERVER – DECLARE Multiple Variables in One Statement
SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2
SQL SERVER – Get Common Records From Two Tables Without Using Join

SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only
SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
SQL SERVER – 2008 – Find If Index is Being Used in Database
SQL SERVER – Example of PIVOT UNPIVOT Cross Tab Query in Different SQL Server Versions
SQL SERVER – Get Answer in Float When Dividing of Two Integer
SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search
SQL SERVER – 2008 – Introduction to Filtered Index – Improve performance with Filtered Index
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
SQL SERVER – Few Useful DateTime Functions to Find Specific Dates
SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database

SQL SERVER – Disable All the Trigger of Current Database
SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN
SQL SERVER – 2008 – Get Current System Date Time
SQL SERVER – 2008 – Find Current System Date Time and Time Offset
SQL SERVER – SQL SERVER – Simple Example of Recursive CTE – Part 2 – MAXRECURSION – Prevent CTE Infinite Loop
SQL SERVER – Simple Example of Recursive CTE
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
SQL SERVER – 2008 – Introduction to SPARSE Columns
SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations
SQL SERVER – 2008 – Introduction to Row Compression
SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
SQL SERVER – Find Current Identity of Table
SQL SERVER – 2008 – Inline Variable Assignment
SQL SERVER – 2008 – Compound Assignment Operators
SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column
SQL SERVER – Create Default Constraint Over Table Column
SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today
SQL SERVER – Find Last Day of Any Month – Current Previous Next
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
SQL SERVER – 2005 – List All The Column With Specific Data Types
SQL SERVER – 2005 – List Tables in Database Without Primary Key
SQL SERVER – Stop SQL Server Immediately Using T-SQL
SQL SERVER – UDF – Get the Day of the Week Function
SQL SERVER – SPACE Function Example
SQL SERVER – 2005 – Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename
SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained
SQL SERVER – Running Batch File Using T-SQL – xp cmdshell bat file
SQL SERVER – 2005 List All Tables of Database
SQL SERVER – Explanation and Comparison of NULLIF and ISNULL
SQL SERVER – Find Length of Text Field
SQL SERVER – LEN and DATALENGTH of NULL Simple Example
SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key
SQL SERVER – Script/Function to Find Last Day of Month
SQL SERVER – Math Functions for 2005
SQL SERVER – Disable Index – Enable Index – ALTER Index
SQL SERVER – Binary Sequence Generator – Truth Table Generator
SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String
SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates
SQL SERVER – Collate – Case Sensitive SQL Query Search
SQL SERVER – Query to Retrieve the Nth Maximum Value
SQL SERVER – CASE Statement/Expression Examples and Explanation
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure
SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created
SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database
SQL SERVER – Query to Find ByteSize of All the Tables in Database
SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

Comments are closed.