If they are already in KILLED/ROLLBACK state, you cannot kill them again. Since they are actively processing a rollback, restarting the server will just continue the rollback when they...

If you need data and structure, one of the most common practices is to do a database backup (or use a backup from your DR plan) and restore it to...

Altering the rows per batch will restrict the number of records being transferred at a time. The maximum number of rows that can fit in memory will give you...

You can alter objects using the GUI if you go through the replication UI. Once you are replicating an article, you have to use the replication UI to make...

If you were to enable Cross-Database ownership chaining, you would be able to give them access just to DatabaseA and they could have access to DatabaseB tables if the VIEW...

yes

Matt has excellent points. You should take his advice and avoid this approach.

If you have to pass "list" of things, you should consider XML rather than splitting up delimited...

I don't see how it could know the difference from a virtualized server and a physical one. It should work - the install should not stop you. It...

On each component, there is a "Fail package on failure" property that you can use to manage (to some degree) when event handlers will and will not fire. It...

It's usually best - in MS SQL Server - to default to trying to do everything in set-based operations. MS SQL is not good a row-by-row processing.

However, there are...

The additional check if there are records to insert will hurt performance in a couple of ways. First, it is an extra statement every time there is something to...

The only way I have done this is to consider the conversion a client-side operation. Everything passed to the server, stored on the server, and used by the server...

You should thank your DBA - that is a very good decision they have made.

SQL Server will store up to 8 bits in the same byte. 1 bit field takes 8 bytes of space, 2 bits takes 8 bytes, 9 bits takes 16...

Windows often displays characters that it cannot display as a square box. It could be anything - a line feed, a korean character that you do not have installed,...