Most chances are that when you added the other column to the index, the index was a covering index. A covering index is an index that is composed of...

The index tuning wizard works according to the queries that were presented to it. If you have a work load file that has a work load that simulate the...

Instead of asking this question and wait for an answer just try to create a table with 2 computed columns that one of them is based on the other one....

I think that in this case you’ll have to use dynamic SQL. Notice that the dynamic SQL won’t recognize the variable that holds the data, so you’ll have to...

You can read the log with some undocumented commands such as DBCC LOG, but it is very hard to understand the output (I tried it long time ago and gave...

I have an educated guess:-). I didn’t check it, but if I understand how the profiler works then most chances are that this is what happened. If you...

Here is one way of doing so. The script bellow creates a script that deletes all orphaned users from each database. Notice that the script is using an...

When I ran your code I got blank on both lines. I ran it on SQL Server 2005.

Adi

When you create a database snapshot, the snap shot doesn’t hold any data. Each page that is modified for the first time in the original database, is copied to...

You can have few instances of SQL Server on the same machine. You can also have each instance with a different version of SQL Server (assuming that you don’t...

Unlike other languages in T-SQL case is not use as a control statements that decides which part of the code should be run (Sort of an improved IF statement). ...

This is taken from BOL:

“Execute permissions for sp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database. However, when the user sending the message does not...

How do you define which record is the second record? When you have 2 values do you have a rule that according to it you know which one to...

When your first dynamic SQL finishes its run, the session returns to work with the original database that it was set to work with before the dynamic SQL ran. ...

I think that you need to drop the old constraint and add the new constraint with the cascading delete:

alter table AAA drop constraint OldConstraintName

alter table AAA add constraint FK_ABABA foreign...