June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL Server – 2008 – Cheat Sheet – One Page PDF Download

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Best Practices, Database, DBA, Software Development, SQL Cheat Sheet, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server, SQL Utility

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.

I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.

Read More

SQLAuthority News – Security Update for SQL Server 2005 Service Pack 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Server Security, SQL Service Pack
Developers who are using SQL Server Service Pack 2 must install this security patch for it. A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer…
Read More

SQL SERVER – Puzzle – Solution – Computed Columns Datatype Explanation

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
Database, MVP, SQL Scripts
Just a day before I wrote article SQL SERVER – Puzzle – Computed Columns Datatype Explanation which was inspired by SQL Server MVP Jacob Sebastian. I suggest that before continuing this article read original puzzle question SQL SERVER – Puzzle – Computed Columns Datatype Explanation. The question was if computed…
Read More

SQL SERVER – Get Answer in Float When Dividing of Two Integer

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
Many times we have requirements of some calculations amongst different fields in Tables. One of the software developers here was trying to calculate some fields having integer values and divide it which gave incorrect results in integer where accurate results including decimals was expected. Something as follows, Example, USE [AdventureWorks]…
Read More

SQL SERVER – Guidelines and Coding Standards Part – 2

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, Software Development, SQL Coding Standards, SQL Scripts, SQL Stored Procedure
To express apostrophe within a string, nest single quotes (two single quotes). Example: SET @sExample = 'SQL''s Authority' When working with branch conditions or complicated expressions, use parenthesis to increase readability. IF ((SELECT 1 FROM TableName WHERE 1=2) ISNULL) To mark a single line as comment use (–) before the statement.…
Read More