Reputation
4,642
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 17 40
Newest
 Yearling
Impact
~406k people reached

May
9
comment Error handling in container procedures
Well that's embarassing. I didn't follow the link. One slight difference is that this answer deals with nested procedure calls.
May
9
answered Error handling in container procedures
May
4
answered Converting RTF in a text column to plain text in bulk
May
2
answered Is it possable to do a ALL SERVER DML Trigger?
Apr
27
comment Which DBMS are fast enough for an online game (few thousand players)?
Whatever DBMS you choose, don't forget to take licencing into account. Maybe your free version is fine for small loads, but if and when you have to scale up or out you may experience a severe case of sticker shock.
Apr
26
accepted What is an appropriate datatype for an RFID, and is there a standard definition for the format?
Apr
25
comment Add column taking too long
How many records are in the tables? (dev/prod)
Apr
25
comment Painless way to create a clustered index on a huge table?
You need to explain to your customer that they are already experiencing outages, every time their queries run slowly. Every time a person or process has to wait for their highly fragmented table to return results, they are in fact losing money. They need downtime to address the situation. Period.
Apr
24
awarded  Yearling
Apr
23
comment Referencing database programmatically via T-SQL
One thing to note...this runs on SQL Server 2008R2 Enterprise Edition. The "rebuild with (online = on)" is not supported on standard edition.
Apr
23
answered Referencing database programmatically via T-SQL
Apr
20
comment Recalculate Time Dimension in BIDS
I have always created mine from scratch via a stored procedure that accepts start/stop dates and granularity (seconds, minutes, etc) as parameters.
Apr
19
answered How do I run a large script with many inserts without running out of memory?
Apr
18
asked Is there a standard approach to rolling out database schema changes?
Apr
14
accepted What is the preferred method to roll out updates to hundreds of databases
Apr
14
comment What is the preferred method to roll out updates to hundreds of databases
I can't use the Central Management Server functionality, because our particular environment does not have windows authentication. We are using SQL Server authentication, which is not supported by CMS for distributed queries.
Apr
13
revised Is it correct, order of where clause doesn't matter when it is used with join?
Reworded the answer a bit, and removed the reference to an article on joins, which was written for a very basic target audience
Apr
13
revised What is the preferred method to roll out updates to hundreds of databases
Added a description of the SSIS package
Apr
13
comment What is the preferred method to roll out updates to hundreds of databases
@shark, I'll add more to the original question to explain the SSIS package
Apr
13
answered Is it correct, order of where clause doesn't matter when it is used with join?