Reputation
4,704
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 17 41
Impact
~432k people reached

May
18
comment Drop constraints vs disable constraints during a data import
Yes, but in this case the version of SQL server is SQL-2000. I fixed the tag.
May
18
revised Drop constraints vs disable constraints during a data import
Specified proper SQL Edition
May
18
comment Database Administrator vs Database Architect?
@Frustrated, that is my point. Database Administrator is too vague. It can be applied to people who only do the day to day operations, or to people who do database development, and all the levels in between.
May
18
asked Drop constraints vs disable constraints during a data import
May
18
answered Database Administrator vs Database Architect?
May
15
revised Convert varchar column to datetime
formatting
May
15
answered Convert varchar column to datetime
May
14
comment How to convert SQL Server .MDF database to Mac OS PostgreSQL database on Mac OS X?
Do you want just the tables and data, or do you need stored procedures and functions as well? If so, you are likely going to have to export those and manually compile them in postgresql, making syntax changes as required.
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.