When you drop a SQL Server database, associated SQL Server Agent jobs are not dropped with it. Presenting a simple query that can be used to identify SQL Server Agent jobs that used to be targeted to a database, but the database no longer exists....

When you drop a SQL Server database, associated SQL Server Agent jobs are not dropped with it. Presenting a simple query that can be used to identify SQL Server Agent jobs that used to be targeted to a database, but the database no longer exists....

Without running these queries can you find out the query that would throw an error? 1 select 7*-2&.3 2 select 7|2&-3 3 select 7+-(.2)%(+3) 4 select ((7&2%3)) ......

This is actually a spin-off from a Question of the Day, which appeared in SQLServerCentral (December 16, 2010). A brief History For those of you who have been around in the industry for more than a decade, the term Y2K carries mixed feelings. It was a...

This is actually a spin-off from a Question of the Day, which appeared in SQLServerCentral (December 16, 2010). A brief History For those of you who have been around in the industry for more than a decade, the term Y2K carries mixed feelings. It was a...

How can I define a DEFAULT value in a timestamp and IDENTITY column?...

Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits. The Myth One such my...

Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits. The Myth One such my...

A few words about testing of existence of column...

A few words about testing of existence of column...