4,259 reputation
1031
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 3 years, 3 months
seen 11 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.


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.
Jan
5
revised Does a DBA need to know how to program in a system language besides SQL?
edited for clarity
Jan
5
answered Does a DBA need to know how to program in a system language besides SQL?
Jan
5
comment Select Which Database Mail Profile is used in SQL Server 2008 R2
I have only ever set up one profile, and it gets used by default. Sorry.
Jan
4
answered Select Which Database Mail Profile is used in SQL Server 2008 R2
Jan
4
answered Four db servers all identical, one is much slower than the others
Jan
4
answered Microsoft SQL Server 2008 Memory
Dec
22
comment How do you choose a SQL statement timeout?
@Heinzi, it depends on how many different causes there are for deadlocks. Perhaps there are only a few unique causes, but they are perpetuated throughout the application. If you have access to the source, you have the ability to prevent the deadlocks. It is all a matter of how much effort you can afford, and how critical the data is. I sure hope this applicaiton isn't running life support machines somewhere, or somebody really will be the victim of a deadlock.
Dec
21
comment How do you choose a SQL statement timeout?
I would just like to point out that timeouts may relieve the symptoms of deadlocks (no more "frozen" apps), the system may still be suffering from data corruption (some data stored in one table, but not a related table because the connection timed out, transactions were not scoped well, etc.) It would be much better if you could get to the root of the deadlocks and eliminate the cause.
Dec
19
comment reindex database in sql server 2008
If you decide to move forward with rebuilding indexes online, make sure you have enough room on the data drive, as you database will grow accordingly.
Dec
16
revised What is the difference between an INNER JOIN and an OUTER JOIN ?
fixed up the title