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


13h
comment ERROR FOR MIRRORING PLEASE SOLVE IT
Try Stackoverflow for a similar problem: stackoverflow.com/questions/11032937/…
Apr
9
comment Insert with OUTPUT correlated to sub query table
Your query is only updating the Person table. You can capture the inserted.ID, but not the FinancialInstitution.ID unless you use it in the insert portion. The way your query sits, if you removed the OUTPUT clause, you would get an error because the number of columns in your INSERT statement does not match the SELECT statement.
Apr
5
comment SQL Server select columns which contain data
You are looking for a quick solution to a design problem. The original database designer took a shortcut. You are now paying the price. There is no quick solution.
Apr
2
comment SQL Server select columns which contain data
Ahh..yes I see that now. Sounds more like a presentation layer problem.
Apr
2
answered SQL Server select columns which contain data
Apr
2
answered Slow insert - 300+ Million Records
Mar
31
answered What could cause an auto increment primary key to skip numbers?
Mar
31
awarded  Popular Question
Mar
2
comment Reduce DB size - SQL Server, SSMS
What is the "Even Log" table you refer to?
Feb
18
comment Most efficient queries on flags in TSQL: bit field or table join?
Using a filtered index on the bit field might make sense if the data is heavily weighted one way, and you are looking for the oppisite i.e. if most people don't opt in, there will be very few opt-ins to look for, therefor your filtered index would be beneficial if the filter was for the opt-ins
Jan
28
comment Disabled index still incurs overhead when inserting
I would drop the non-clustered indexes and leave the clustered index as is. The data will then be sorted as you insert it. Add the non-clustered when finished.
Jan
23
answered Execute a query which returns uniformly at maximum 100 records
Jan
23
comment Is there a standard approach to rolling out database schema changes?
I didn't search programmers first, because this is a database administrative question. Your answer there didn't include any more information that I already had in my own question. thanks anyway
Jan
21
comment SSIS v/s Replication v/s logshipping
The SSIS package should execute SQL code that only brings in data that has been changed/added since the last update.
Jan
21
answered SQL Server replication service in Amazon RDS
Jan
21
comment Schema & Database Role Permissions Issue
Can you past an example query, and the exact error generated?
Dec
6
comment Does it make sense to use SQL Server's bracket notation in hand written code?
I don't like leading commas and semicolons for the same reason that I don't put the punctuation at the beginning of a sentence.
Dec
2
awarded  Popular Question
Oct
1
awarded  Good Answer
Sep
25
awarded  Notable Question