I'm not familiar with this term but I'll try to learn a bit more about it and why it affects our...

Thank's for the answers and the link. I'll go trough it in detail.

Yes, we have snapshot isolation set to on. I can see that during reorganisaton of our largest table...

Thank's a lot. I already found this table but I did not realize that the one column contains the whole package. The hint of queries built at rune time is...

I cannot agree to that and in my opinion there is just one correct answer to this: it depends!

What do you call an "incredibly simple system"? How do you call...

You should do it another way. When normalizing the database there should be a table containg all available statusids. Your data table should then have a foreignn key to the...

A foreign key helps you keeping your data consistent. In your case the foreign key says that you can only insert ContactIds in table Contact13 if it already exists in...

This is a problem many people have. In the german language the decimal separator is a comma too. When having the english database system all decimal separators are returned with...

"take long" is quite relative. In the enviroment I know we lose data if a table is locked for more than 30 seconds. As far as I have seen the...

hi there,

I think you are one of thousands having this problem. I personally still don't know any easy solution to this. I personally work with a third solution: copy the...

michael.newman560 (1/5/2013)

---

I assume that the two statements directly below the procedure name, "@inFromDate" and "@inToDate" are just two variables for the WHERE clause to use. Where do they get...

Why using an external tool? There is an audit function within SQLServer too. It works...

hi Mike,

you try to do it the wrong way. You should not try to modify your SQL-Code from outside. You can define input parameters in SQL-Procedures too.

ALTER PROCEDURE dbo.DateRange

...

you just need to replace the select-command with an delete-command, followed by the table to delete the data from. Then remove the order-by-clause and that's it.

delete from dbo.BC_ShiftSummaryInfo

from dbo.BC_ShiftSummaryInfo A

Join...

of course you can. Depends on what property or configuration you actually want to change.

Just to name an example, have a look at "sp_configure".

Changing the name of a sqlserver can...

I forgot this question:

you don't get...