datagod

3,692 reputation

522

bio	website	DBADepot.com
	location	Ottawa, Canada
	age	93
visits	member for	2 years, 1 month
	seen	3 hours ago
stats	profile views	147

I am a SQL Server DBA in Ottawa Canada, and an instructor with Learning Tree International.

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.

	3,692 reputation	bio	website	DBADepot.com	visits	member for	2 years, 1 month
522 badges		location	Ottawa, Canada		seen	3 hours ago

summary answers questions tags badges favorites bounties reputation activity

340 Actions

suggestions reviews revisions comments badges posts accepts all

3h	comment	Updating a table with millions of records, its been 4 days Can you do a select with the same search/join criteria? Without running it, check the query plan and see how many rows are being estimated. Based on your not-very-selective join conditions, you may be dealing with a heck of a lot more records than you first thought. Not quite a cartesian product, but close.
May 16	answered	When is it worth it to use Triggers and stored procedures/functions?
May 14	awarded	Caucus
May 4	answered	What is the optimal response time for file growth
May 1	comment	Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database? Creating a linked server (or even an adhoc open query) works great, but be careful of headers, titles, merged cells, etc. as the data type of an entire column seems to be determined by the first row.
Apr 26	comment	Query two SQL Server databases in same function but on two different servers A linked server definition is setup by the DBA. It contains the login credentials to the remote server. If you want to provide the login credentials yourself each time, that would be an openquery or openrowset command. I am not sure if you could do the joins that way though...
Apr 24	awarded	Yearling
Apr 12	comment	When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have? 19,000,000 X 30 = 570,000,000 index entries. Not knowing the column types, I am guessing there is a lot of string data. Doing all that in one hour is pretty good, in my humble opinion.
Apr 12	answered	When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Apr 9	comment	How to trace SQL queries which are crashing SQL Server Have you tried looking at the black box traces? They may point you in the right direction.
Apr 2	comment	Why is Database Administration so hard? Junior DBA's are under 30. You need a few more years under you belt before you should be called a Database Administrator.
Mar 21	accepted	When is it appropriate to use SQL Server Developer Edition?
Mar 21	comment	When is it appropriate to use SQL Server Developer Edition? In my neck of the woods (Canadian government clients) staging is the environment used for test/user-acceptance. Sometimes they have 4 environments (DEV/TEST-QA/STAGING/PROD) and in that case staging is simply a place that is an exact copy of production so that when you rollout your changes you will see if anything breaks. Bit costly to maintain all 4 environments, so typically the middle two get merged into one.
Mar 20	comment	When is it appropriate to use SQL Server Developer Edition? Just to clarify, what I meant was that it would be a shame to NOT be able to use developer edition on a big honking server. I specifically intend on showcasing the more advanced features and do not want to try to do that on a developers laptop.
Mar 20	asked	When is it appropriate to use SQL Server Developer Edition?
Feb 23	comment	Is it better to seperate a big query into multiple smaller queries? You guys would have to take a look at the way I write my large batch processes. Break things down to simple queries, very easy to read. I am biased because the queries I end up trying to tidy up are routinely over 1000 lines long.
Feb 22	answered	Is it better to seperate a big query into multiple smaller queries?
Feb 13	comment	NoSQL, CouchDB vs. CouchBase, What should i do? How many records are in your very big result set? If you ran the query locally on your database server how long does it take to run? The problem could be an inefficient query, fragmented data, or even network latency. Replacing your RDBMS because of a slow-performing web page seems rather drastic.
Feb 7	comment	Importing data with a lot of SELECTS during transaction Bulk inserting data is extremely fast. My guess is that the slowness you are experiencing is the validation SELECTS that you are performing. Make sure they are as optimized as possible.
Feb 7	answered	Importing data with a lot of SELECTS during transaction