Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
SQL SERVER – 2008 – July CTP Released
Microsoft released the SQL Server 2008 July CTP, with policy-based management, Change Data Capture, MERGE and new tools for analysis services cubes.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
Part 1 of my Data Warehousing interview questions and answers, starting with the basics: what a data warehouse is and how it supports decision making.
SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
Let’s learn about Server and Database Level DDL Triggers Examples and Explanation here. Let us learn more about this topic.
SQL SERVER – UDF – Function to Get Previous And Next Work Day – Exclude Saturday and Sunday
Inspired by a ColdFusion post by Ben Nadel, here is the UDF I use to get the previous or Next Work Day for any date, skipping Saturday and Sunday.
SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup
Fix the SQL Server error Msg 4214 and Msg 3013, where BACKUP LOG fails because no current database backup exists. Here is why it happens.