I am bad at writing articles but the easiest I think is to add a step next to backup command in job schedule. Add this command to next step...

More explanation on COALESCE expression error..

http://connect.microsoft.com/SQLServer/feedback/details/301695/misleading-error-message-on-case-expression-with-untyped-null-in-each-result-expression#

Hugo Kornelis (11/9/2010)

---

Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually...

Create Table #Test (a int, b int, C as a+b )

go

insert into #test values (3,4)

insert into #test values (1,7)

go

select * from #test

order by 1

go

drop table #test

go

Isn't it funny that...

XML always remained mystery to me. Never understood the concept completely. May because I never worked on a project which had mandatory XML programming.

And just last week got...

For the same reason I never use sp_rename to rename object in sql server.

Always prefer if exist method.

if exists (select * from sys.objects where object_id = object_id(N'[dbo].[Object_name]') and OBJECTPROPERTY(object_id,...

Why do this task with VB script when you can do the whole process with T-SQL scripts?

Easy one. With Begin and Rollback Transaction included in question it's easy to select correct answer.

Glad it worked.

I had the same issue some time back and had to spent more than three days to know the cause.

First thing first change the data type to Nvarchar in the...

looking at the options, I thought option one would be the right answer. Since both inner and outer rollback, query would return zero rows.

then executed it and got right...

Steve, it's a pure form of plagiarism. But, why take the rating out for article. It's a well written article....

Nice article. But, for Omeshwar, Nice hard work of CTRL + A, CTRL + C and CTRL + V.

Nothing wrong in taking knowledge / Points from others, but there...

Good question. I had not disabled index as of now or never tried. Thought that it would fetch data but would take time, period.

But, never knew that disabling...

C# is ok but F# ? It's a wrong choice written all over it.