539 reputation
313
bio website trycatchfinally.net
location Phoenix, AZ
age 33
visits member for 3 years, 2 months
seen 2 days ago

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!


Oct
2
comment “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
@BrandonWilliams I updated the question to add my T-SQL code, generated by the publication wizard. All the pre-steps execute without issue, and it's the final step that actually adds the article to the Oracle publication that gives me the error.
Oct
2
revised “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
added code that causes the issue
Sep
30
comment “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
@RLF: There's isn't any code, as I'm using the SSMS "Add Oracle Publisher" wizard rather than using T-SQL directly. That said, the error seems to occur when the wizard executes sp_addarticle, which is turn executes sp_ORAaddarticle, from which the code is hidden (because it's a system stored proc). This, in turn, executes a package deployed to the oracle database called "MYUSERNAME.HREPL" where the error is actually occurring. I know that's not much help, but we're sifting through that package now to see if can find the statement.
Sep
30
asked “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
Jul
28
awarded  Popular Question
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?