How to get current user for a query in SQL Server 2005: SELECT SYSTEM_USER returns the name of the current context, which helps with debugging and security.
SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS
Forced parameterization can cut query compilations for busy databases. I explain FORCED vs SIMPLE parameterization and how to set each with T-SQL and SSMS.
SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords
I have tried to explain the usage of simple WHILE loop in the first example. BREAK keywords will exit the stop the while loop and control is moved.
SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database
Invited to review a big company’s schema, I wanted to know my own permissions without asking their DBA. fn_my_permissions shows them at server and database level.
SQL SERVER – Difference Between @@Version and xp_msver – Retrieve SQL Server Information
SELECT @@Version gives the SQL Server version, edition and service pack in one string. I compare @@Version and xp_msver, which returns more server details.
SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
A short T-SQL script to set server level FILLFACTOR, plus the Books Online definition of FILLFACTOR and what its values from 0 to 100 mean.
SQL SERVER – Three T-SQL Script to Create Primary Keys on Table
Three T-SQL scripts to create primary keys: two while creating the table and one with ALTER TABLE later, where the column must first be NOT NULL.