Viewing 15 posts - 4,321 through 4,335 (of 14,953 total)
Jim Murphy (5/9/2011)
GSquared (5/9/2011)
I just registered for the PASS Rally in Orlando.
Sounds great. I'm flying out of Austin, TX tomorrow afternoon and I'll be in Grants session on Wed.
If...
May 9, 2011 at 6:48 pm
I just registered for the PASS Rally in Orlando. Wasn't sure I'd be able to get the time/money for it, but it worked out. See you there if...
May 9, 2011 at 4:06 pm
forsqlserver (5/9/2011)
Who Uses the Physical joins(Nested,Merge,Hash) of SqlServer?Why it has created?How it is different from inner,outer,... joins?
I've used a forced Merge Join one time. Was a query that most...
May 9, 2011 at 7:01 am
Grant Fritchey (5/9/2011)
... and you've tested them extensively on the query that you're planning to use them on.
Test, test, test and then test...
May 9, 2011 at 6:57 am
Brandie Tarvin (5/6/2011)
Editor's Note:
May 9, 2011 at 6:42 am
You're welcome. Sounds like a classic trees vs forest issue. Happens to everyone now and again.
May 9, 2011 at 6:32 am
If you simply query the XML, that's exactly what you will get. That's how XML stores that type of data.
What end result are you trying to get?
If, for example,...
May 5, 2011 at 12:40 pm
I'm assuming by "join" you mean have the two sum fields together in one row kind of thing. Right?
If so, it looks like the two queries are very similar...
May 5, 2011 at 12:31 pm
There really isn't a math to that. One connection doing a heavy enough query can bring any server to its knees, so how could there be?
May 5, 2011 at 12:29 pm
The file extensions are just there for your convenience, since you probably won't be double-clicking a backup file to try to "open" it. Use whatever you're comfortable with.
The script...
May 5, 2011 at 10:48 am
When you set the value for the XML variable, put an "N" in front of the first single-quote. That makes the string unicode. Right now, you're using an...
May 5, 2011 at 6:56 am
Insofar as "best method", define "best". It gets the job done.
May 5, 2011 at 6:14 am
Dan.Humphries (5/4/2011)
May 5, 2011 at 6:10 am
To really test query performance, you need bigger datasets than this. To legitimize a few apples:apples points, try a test like this:
SET NOCOUNT ON ;
IF OBJECT_ID(N'tempdb..#T1') IS NOT NULL...
May 4, 2011 at 2:27 pm
Viewing 15 posts - 4,321 through 4,335 (of 14,953 total)