Guidelines and Coding Standards Part 1: Pascal naming for tables, and naming patterns for stored procedures, triggers, indexes and keys.
SQL SERVER – 2008 – Interview Questions and Answers Part 5
SQL Server 2008 Interview Questions and Answers Part 5: how to rename a db with sp_renamedb, and a table or a column with sp_rename, with examples.
SQL SERVER – 2008 – Interview Questions and Answers Part 4
SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.
SQL SERVER – 2008 Interview Questions and Answers – Part 1
Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
Table-Valued Parameters in SQL Server 2008 let you pass many rows to a stored procedure without a temp table. I walk through the steps with a Department example.
SQL SERVER – How to Rename a Column Name or Table Name
How to rename a column or a table in SQL Server with sp_RENAME, with a video and a simple AdventureWorks example for each case.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.