Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.
SQL SERVER – Frequency of SQL Server Reboot and Restart
How often should you do a SQL Server reboot? From my experience there is no need, though our network team reboots all our servers every 15 days.
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
A step by step tutorial to create a T-SQL script that can copy database schema and all objects, like stored procedures, functions, triggers, tables and views.
The SQL Basics Almost Everybody Skips
Revisit SQL basics that change query results: NULL logic, logical processing order, grouped filters, and the difference between two common counts.
The Dynamic Management Views Worth Knowing by Heart
Use dynamic management views to inspect active requests, waits, cached queries, index activity, and file space without guessing at server health.
SQL SERVER – What is SQL? How to pronounce SQL?
What is SQL and how do you pronounce SQL? It stands for Structured Query Language, and it is said as S.Q.L. (ess-cue-ell), not sequel.
SQL SERVER – 2005 – List Tables in Database Without Primary Key
A simple script to list tables in database without primary key, using sys.tables and OBJECTPROPERTY TableHasPrimaryKey in SQL Server 2005.