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 – Interview Questions and Answers – Part 2
This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
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.