4,334 reputation
11433
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 3 years, 6 months
seen Oct 21 at 4:17

I am a SQL Server DBA in Ottawa Canada.

I am the founding partner of DBA Depot and the president of Metropolis Dreamware and Cooking With SQL. We provide database consultants to various public and private sector organizations.

I am a technical editor for SQL Server Magazine and the author of the T-SQL 101 series of articles / e-book.

I have been a SQL Server DBA since the bad old days of SQL 4.2.


Feb
22
comment What is the best approach to parsing a large amount of strings?
The distinct result (last name) will be stored in another table for further analysis. The fun part is trying not to blow away the transaction log. I of course have limited space on this machine.
Feb
22
comment What is the best approach to parsing a large amount of strings?
The database is in simple mode, but I worry that adding the computed columns would be performed inside a transaction. I have been a DBA for many years, but suprisingly have not had much experience with computed columns.
Feb
22
asked What is the best approach to parsing a large amount of strings?
Feb
20
comment How to store data in a database without tables?
SQL Server can certainly store JPEG files using IMAGE datatype. I would not recommend that, however. You would be better off using FILE-STREAM.
Feb
20
answered How to recover previous values in Mysql Table?
Feb
17
answered Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
Feb
17
answered SQL Server - DBO without Backup
Feb
16
answered SQL Server 2008 R2 Standard with SSIS Enterprise
Feb
10
answered Unexpected extremely long query time (~5 minutes using nested WHEN-INs)
Feb
10
comment Easily show rows that are different between two tables or queries
Hint Hint Hint: @Erike, he answered your question, and deserves and upvote. You should be able to do the rest. We are not here to do the work for you.
Feb
7
comment SQL Server retrieval error under heavy load (200 concurrent users)
Use of NOLOCK hints can lead to unexpected results: sqlmag.com/article/sql-server/…
Feb
6
comment Using Central Management Server to provide convincing performance statistics
Can you use Management Data Warehouse to monitor SQL2005 or SQL2000 instances?
Feb
6
comment Varchar to date in SQL Server 2008
Why bother closing the question? People have answered and voted for it. I disagree that it is off topic.
Jan
30
comment In a trigger, how to check if no fields have changed?
In my case, we needed to exit the trigger as absolutely fast as possible. The audit was a "nice to have" feature, but performance was still top priority (very busy server). I wonder if there is some SQL bug somewhere that causes @@ROWCOUNT to not be properly incremented.
Jan
30
comment In a trigger, how to check if no fields have changed?
I have two questions: Why do you want to ignore updates that don't modify anything, and more importantly why are there updates being performeed that don't modify anything? Sound like if you filter out this data, you may be ignoring a serious problem with the application.
Jan
30
answered In a trigger, how to check if no fields have changed?
Jan
25
awarded  Civic Duty
Jan
25
answered helping hand for sql server resources
Jan
20
comment How to get accurate query performance?
I knew about SET STATISTICS IO ON, but I never knew about SET STATISTICS TIME ON. Thanks JNK.
Jan
18
comment Defragmentation - Rebuilding Indexes SQL Server 2005
The only way to tell how long it will take is copy copy the database to a similar server (same hardware config) and run the rebuild there.