4,314 reputation
11232
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 3 years, 5 months
seen 17 hours ago

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
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.
Jan
18
comment Installing “SQL Server 2000 Client” and “SQL Server 2000 service pack 4”
Yes, they are both different. One is the client tools, the other is an update to the server. Why on earth would you want to install software that is already 12 years old?
Jan
17
answered How does one scale SQL Server 2008 or 2012?
Jan
7
answered Microsoft SQL Server, Error: 3205
Jan
5
comment How should I design a relationship table for friendship?
You are right about the storage, but remember that if stored as integers, each friend-friend relationship would take around 30 byes (2 records x 3 columns x 4 bytes per integer = 24 bytes plus some padding). 1 million people with 10 friends each would still be only around 300MB of data.
Jan
5
revised Diet and exercise schema
I removed an extra word at the end.
Jan
5
comment Does a DBA need to know how to program in a system language besides SQL?
SSIS can be installed as a standalone sytem. Does that fit your model as well? What do you think the name SSAS even stands for? SQL Server Analysis Services. It is part of the suite, whether people use it or not.
Jan
5
answered How should I design a relationship table for friendship?
Jan
5
comment Microsoft SQL Server 2008 Memory
During a quiet time on the server, you could try running some queries that generate full table scans against the largest tables. You should see memory utilization go over 19GB, assuming you are able to read enough data, as SQL reads the data into its cache. How big are your largest tables?
Jan
5
comment Does a DBA need to know how to program in a system language besides SQL?
SSAS is just as much a part of the SQL Server family as SSIS and SSRS. Like I said, SQL Server is BIG.