If you're returning many rows network speed is a factor. When run from SSMS the query doesn't finish until all that data gets to the box you're...
My experience in SQL 2005 is that the null values are treated like any other as far as index lookups are concerned. Note that anytime you have a...
If you want to do this quickly without spending a lot of time at it, create a clustered primary key on any of these heap tables with an identity...
Just today I unchecked the "Verify Backup" box for our full backups maintenance plan. I hated to do that, but the verification step was taking twice...
The indexed view will be automatically updated when the underlying table data is updated. Therefore I believe this will also increase the insert...
Wolfgang, Have you considered adding the query plan to the trace? It's under the performance group in profiler. Perhaps a different query plan is...
No, but check out this explanation of your issue with Microsoft: INF:Foreign Key Constraint Behavior of Nullable Composite Keys...
I am not reproducing that behavior. I have a FK on a table and a row where that value is null. When I try to update that value to a value that does...
Separate names with a comma.
