534 reputation
312
bio website trycatchfinally.net
location Phoenix, AZ
age 33
visits member for 2 years, 11 months
seen Jul 1 at 16:04

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!


Jul
2
awarded  Curious
Jul
1
awarded  Popular Question
May
23
comment Modify an Oracle Dataguard destination database
It's not one trigger - it's one on every table. We're using it as a step to replicate the data to an MSSQL Server, which requires their DDL trigger on every table. Even if it was supported, I don't want to potentially slow down the operations by introducing this kind of load on the production server if I can do it on a native Oracle replica of some kind.
May
23
comment Modify an Oracle Dataguard destination database
We're using it as a stepping stone to replicate into MSSQL Server, which requires that we put a trigger on every single table in the database. It's not something the vendor will support, and not functionality they're interested in adding at this time (I wish it was).
May
23
asked Modify an Oracle Dataguard destination database
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?