534 reputation
310
bio website trycatchfinally.net
location Phoenix, AZ
age 32
visits member for 2 years, 8 months
seen Apr 3 at 20:24

My name is Ryan McCauley, and I'm a database/reporting manager for a mid-size cable company. I spent a number of years as a .NET developer (mostly of the VB.NET variety), but now largely focus on T-SQL and the reporting with the Microsoft BI stack.

On my own time, I build small apps to help get things done a little better, and have a couple posted at Codeplex:

  • SQL Space Map - if you have some large SQL Server databases and you'd like a visual picture of which tables and indexes are taking up that space, it's the tool for you.
  • SQL Server Contention Monitor - watches as may SQL Servers as you want and alerts you to blocked SPIDs, showing you the block tree (which process is blocking which, an what others are affected). It's still in a pretty alpha-ish phase, but it despite some instability at times, it gets the job done.

Check them out and let me know what feedback you have!


Jan
29
awarded  Popular Question
Sep
27
comment Sharing a single primary key sequence across a database?
If you had to choose between something like this and just using uniqueidentifiers as primary keys, would you have a preference (though the answer is likely "it depends")? It seems like a GUID would work around the problem the same way, except that you'd get a standard implementation rather than having to roll your own centralized primary-key-generator. Obviously, using a sequence in SQL 2012 would accomplish both things, but assuming somebody is on an older version?
Aug
26
awarded  Yearling
Aug
1
comment Can I reorganise index on a sql server 2005 database without performance hit on production server
I'm unclear why this was voted down as well - it's something I've used a number of times, and if it's a bad idea, I'd like to know why.
Jul
18
awarded  Notable Question
Jun
15
answered How to run an exe file exists on a different server from SQL Server Job
May
2
comment Force sql server to run query conditions as written?
I was going to suggest using OPTION (WITH RECOMPILE), as that would generate an ideal plan each time - the compile delay would add overhead, but I suspect it's better overall in this case.
Apr
26
comment Are database query optimizers aware of storage performance differences?
This is great information - thanks! It confirms the suspicions I had, and those two DBCC commands have been fun to play with on a sandbox machine I have :)
Apr
26
accepted Are database query optimizers aware of storage performance differences?
Apr
25
asked Are database query optimizers aware of storage performance differences?
Mar
24
comment Replicating data from Oracle to MySQL
I can understand setting up the triggers on the Oracle tables to track changes, but then how would you actually transport the changes? Are you saying I should write to a log file of some kind and have my scripting language read and transport those changes? I'd prefer the triggers do as little as possible, so they're quick and don't impact the source system any more than necessary.
Mar
20
asked When is data moved during an Oracle partition split?
Feb
4
awarded  Popular Question
Dec
24
accepted I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
Dec
23
comment SQL Server Agent fails to start in Failover cluter
Also, does the Agent fail to start on both (all) nodes in the cluster, or only one certain ones? Has the SQL Agent ever started successfully in this clustered instance?
Dec
23
comment I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
All solid points - thanks for the caveats. I'd be concerned about number 3, except I'm not sure how you'd back up the list of scheduled tasks from the native Window scheduler, so I'd (at the moment) be prepared to lose that list completely, though I'm sure there's some way to keep a copy. Organization might be the biggest concern - none of my servers are at that point yet, but I could see them getting there if I didn't have a good system in place.
Dec
21
comment I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
I appreciate the feedback - I guess the question is pretty subjective, as either method gets the job done - but I'm looking for either some validation that "yeah, Windows tasks leave a lot to be desired" or "No, that's a terrible idea, here's why..." We'll see what bubbles up!
Dec
21
comment I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
If this belongs on SF instead of here, let me know and I'll move it there, but I figured it belonged here since I'm using a database tool, and I'm interested to see if other DBA/SA admins are doing the same thing.
Dec
21
asked I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
Dec
7
accepted Why isn't partition-level lock escalation the default?