Not sure exactly what you mean. Are you talking about the VIsual Studio Design environment? If so check under View and Tools, you may have just closed the bar.

Another thing I think you overlookwed was with the case if @MyVar was some other value you will still issue and insert of 'BB' which you may not want to...

There are two ways you can find out for sure.

1) You could use DBCC PAGE to read the physical pages 1 at a time (there is a bit of work...

The only time I have not used a PK is for a table retreiving real time data from a call switch. The application would track the data  in real time, send...

Did the data ever exist in the database, I had posted sometime back that even when you alter data a Ghost of the data may still exist until it get's...

1) Require them to do a real world demo using databases with sizes and transaction levels equal to yours.

2) VM ware has nothing to do with database recover, strictly OS...

Just out of curiosity but what are the columns in each index and which is the clustered index? I ask because a lot of folks make mistakes with composite indexes...

Only if the patch requires you to do so. And yes MS has put out a lot recently that need to do so and are High Risk items but that...

Yes that is the same reason you will see folks place AND and OR at the start of a line instead of the end of the prior line. So much...

Packages are stored within the server in the msdb database along with jobs and backup history. Have any other oddities occurred besides this with regards to jobs? Do all jobs...

Honestly if things are running the way they should and barring patches you want to apply or high risks ones you really should never have to reboot the server. Now...

You say you have the 2000 to delete? Where are they stored now.

I have not seen this but where are the packages stored and do the packages get altered regularly?

Does the file have a password on it first off?

This should help. You can also look at sp_helpindex in master to see how it does similar work to undertsand other options.

select object_name([id]) [Object_Name], indid, groupid, name, (case when (status...