The various "X in technology" groups also serve a function in making others aware of the legitimate differences between their group and others. This includes benefits the group may have...

It's a good idea to check that the server_name column of msdb.dbo.backupset matches the server you are checking.

When you do a restore, if the backup set being restored isn't already...

I aggree with opc.three.

As I said, we've just added MAXDOP=1 query hints when a query has failed at night more than once. It has only been a couple so far....

I've wondered at the optimal setting also.

We have a problem with MAXDOP=0 in our environment. We are very lightly loaded at night, and only have a few large queries each...

Without seeing the whole conditional, it's hard to tell if the ISNULL is a waste because NULL is not a value. E.g.,

WHERE ship_by_date > @today

OR ( pick_up_date IS NOT NULL

AND...

Answering the question asked in the original post, this could be a misunderstanding of the transaction and locking mechanisms in SQL Server.

If you are going to try pre-checking an...

Unfortunately, triggers won't work in this case; SQL Server doesn't have a "commit trigger" that would wait until a COMMIT to check the table for valid structure. Consider the following...

Otherwise, the only thought I have, is that some of the tables could have been heaps, and now have forwarding records left in the un-emptyable file. If so, creating a...

Without seeing the whole conditional, it's hard to tell if the ISNULL is a waste because NULL is not a value. E.g.,

WHERE ship_by_date > @today

OR ( ...

You need to apply the appropriate tools and techniques for the problem at hand. Some major considerations are whether you are trying to integrate data from many disparate sources, is...

If your database is heavily indexed, and you are rebuilding indexes frequently, this could account for the large log backups. This would especially be true if you have a small...

I thought the question was poorly phrased. I guessed that it was essentially "Full Model requires log backups to guarantee a point in time restore to any moment throughout the...

I'm not sure if this is the correct answer; I've got the same lack of "server status" display on half of our servers, but haven't had time to pursue it...

It sounds like you should be using package configurations.

First, I would set up a standard set of package-level variables with the same naming convention in each package. These will be...

It's not the number of names, it's...