261 reputation
26
bio website 12titans.net/p/default.aspx
location New Zealand
age
visits member for 2 years, 10 months
seen Sep 26 '12 at 11:02

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.