1,829 reputation
320
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years, 4 months
seen 15 hours ago
coder & programmer of many defunct languages...

May
6
comment How can I query data from a linked server, and pass it parameters to filter by?
All of your constraints have pretty much eliminated all of the good ways to do this.
May
6
comment Same query taking 0.2 sec in Oracle database but 4 mins in SQL Server
Is the SQL Server Query Plan an Estimated or an Actual? Whichever it is, can you post the other as well? This would be very helpful for figuring out where it is going wrong. Also, what is the total Subtree Costs for each? (this isn't visible in the image, only in the popups).
May
6
awarded  Citizen Patrol
May
6
comment Challenge: Build MySQL table that's not in first normal form
A "Challenge" is not a question. "Comments Welcome!" is not a question. In fact, this whole post more of a polemic than a question, it is argumentative and ultimately, Not Constructive. It is just a very contrived excuse to argue about conflicting interpretations and applications of Relational Theory.
May
5
answered Challenge: Build MySQL table that's not in first normal form
May
3
comment Working Linked Server Query fails in sp_send_dbmail
No, Trace it in your source server, not the target (Linked) server. The error indicates a failure to connect to the target server, so of course you won't see it there, it never gets there.
May
2
comment Force sql server to run query conditions as written?
I believe that the article that I pointed to by Gail Shaw goes into some of the possible solutions, but if you wish I can delineate what the possible solutions are in my response above.
May
2
awarded  Nice Answer
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?
The other obvious option is to "Export" the SQL data to Excel. That is, create a "simple" query that just returns all of the data, then match/filter it in Excel. So "monster" data-size instead of "monster" query.
May
1
answered Force sql server to run query conditions as written?
Apr
30
answered Worse performance on a new server
Apr
30
comment Worse performance on a new server
What is the relative speed of the cores? And how do the io systems compare?
Apr
25
comment INSERT INTO #temp taking 1000 times longer than SELECT INTO #temp
This all works much better if you actually ask a question.
Apr
24
revised Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001
added 24 characters in body
Apr
24
answered Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001
Apr
24
comment Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001
What version of SQL Server?
Apr
17
revised Executing Child packages without using master package
edited tags
Apr
17
comment How does SQL Server generate a query execution plan that adds up to 6,000%?
@RichardTheKiwi That's basically all the ShowPlan visualizer is doing anyway, it just gets it wrong sometimes.
Apr
17
comment How does SQL Server generate a query execution plan that adds up to 6,000%?
I'm gonna say "Bug"?
Apr
17
comment How to optimize a query that's running slow on Nested Loops (Inner Join)
We'll need to see the rest of the query plan.