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

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.
Apr
17
awarded  Yearling
Apr
11
comment Individual queries run on 10ms, with UNION ALL they are taking 290ms+ (7.7M records MySQL DB). How to optimise?
How are you measuring the run-time of your queries?