Viewing 15 posts - 19,096 through 19,110 (of 22,202 total)
Sounds like the second table would be joined as a LEFT join, so look up OUTER JOINS in Books Online.
December 10, 2008 at 12:59 pm
Oh, I agree with Steve here. I'm hating wooden floors more & more with each year. Of course, when we've done demo's and competitions they're sometimes on things worse than...
December 10, 2008 at 9:41 am
Weird.
Here's the original link
http://www.alandallessandrokarate.com/%5B/url%5D
Pictures are on the right. I'm the luckless b*****d grabbing the guy from behind.
December 10, 2008 at 8:15 am
GilaMonster (12/10/2008)
I do have a couple of fairly good photos...
December 10, 2008 at 8:03 am
Execution plans are your friend.
They will show what the query is doing inside the engine. From there you can determine if you need indexes etc. If the data is not...
December 10, 2008 at 7:52 am
You can't get a call-by-call reference, by the dynamic management view sys.dm_exec_query_stats will show you aggregate information about any queries that are still in cache. If they've aged out of...
December 10, 2008 at 7:50 am
Is the data loaded through XML being filtered later in the query? If so, use either a permanent table or a temporary table. If not, if the data is doing...
December 10, 2008 at 7:46 am
Pull a previous copy out of source control...
If you don't have your code under source control, here's the wake-up call to get it there.
You can't retrieve a previous copy from...
December 10, 2008 at 7:42 am
Msg 208, Level 16, State 1, Line 1
Invalid object name 'S_TIMEZONE_TEMP'
Then supply the correct table name. You should get in the habbit of supplying the schema too, so that it...
December 10, 2008 at 7:07 am
That's great. Thanks for following up. It's always good to know what worked and what didn't.
December 10, 2008 at 6:28 am
GilaMonster (12/9/2008)
Matt Miller (12/9/2008)
Funny - that's the EXACT reaction I got when I tossed it back....:)
Just about every time I've done a presentation or informal training and mentioned the problems...
December 10, 2008 at 6:07 am
Sorry for the confusion. Thanks for the clarification Gail.
It's still the approach I'd take, but I'd sure take the time to examine those indexes.
December 9, 2008 at 1:16 pm
That last query... the uh... you know it... well... uh...
Never mind. That actually makes my current local favorite look intelligent:
DECLARE @i int
SET @i =1
IF @i = 0
BEGIN...
December 9, 2008 at 1:03 pm
Jeffrey Williams (12/9/2008)
Grant, I would not recommend issuing the above - especially since it is deprecated in SQL Server 2008. Here is the message you will get on a...
December 9, 2008 at 12:51 pm
First things first, I think your statistics may be out of date. on [SWUS].[dbo].[SW_Ord_List_Ext].[_dta_index_SW_Ord_List_Ext_23_254064091__K3_1_4_5_18_20_22] [OLE]. The estimated number of rows is 54, the actual is 48000. That's a bit of...
December 9, 2008 at 11:49 am
Viewing 15 posts - 19,096 through 19,110 (of 22,202 total)