network profile
| bio | website | 12titans.net/p/default.aspx |
|---|---|---|
| location | New Zealand | |
| age | ||
| visits | member for | 1 year, 5 months |
| seen | Sep 26 '12 at 11:02 | |
| stats | profile views | 7 |
Author of Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server (Apress)
I offer consulting services. Please see my website for details.
|
Feb 23 |
comment |
How to revive SQL Server 2008R2 performance counters? Yes, VS 11. The problem with the question on serverfault is that none of the posted answers resolved the issue. I'm hoping DBA-oriented users might be able to provide more useful help. |
|
Feb 18 |
comment |
What should I use as a primary key/index for a table with no unique columns that are mostly written to? That's a good topic for another question, but briefly: if the source table can be large, you may want to enable BULK_LOGGED while you move the data over. Assuming the two tables have the same columns, then you can do something like DELETE FROM SrcTable OUTPUT DELETED.* INTO DestTable |
|
Feb 18 |
comment |
What should I use as a primary key/index for a table with no unique columns that are mostly written to? So, it sounds like you need to make a trade-off: extra cost at insert time vs. extra cost at query time vs. implementation complexity. Depending on your architecture, if you have times of day when the DB isn't busy, you might be able to offload it into a second table with a fulltext index, or perhaps even to an Analysis Services cube. |
|
Jan 3 |
comment |
sql server 2008 - controlling size of log file right before the commands that are likely to fill up the log (update, insert or delete many rows or make schema changes). How do you know which ones those are? Your guess is as good as mine. |
