Reputation
4,724
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 17 42
Newest
 Caucus
Impact
~453k people reached

Jun
1
accepted Is there a standard approach to rolling out database schema changes?
Jun
1
asked Is there a way to display current noise words in SQL 2000 Full Text Indexing?
May
24
revised What permission is needed to set Database read-only?
Added Query Analyser / Management Studio, as you cannot directly issue commands from Enterprise Manager
May
23
comment why do SSRS reports run longer for a particular user
Does the report accept any input parameters from the user? If so, try two separate users supplying the exact same parameters.
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.