Viewing 15 posts - 4,231 through 4,245 (of 5,685 total)
prassu.ibm (1/29/2011)
My question is how to create a table in a single file
Two questions:
1) Why do you think it isn't?
2) We are discussing Microsoft SQL Server as your RDBMS here,...
January 30, 2011 at 12:48 am
Take this on one concept at a time here...
adam spencer (1/29/2011)
January 30, 2011 at 12:46 am
Lynchie (1/28/2011)
January 29, 2011 at 9:10 pm
jared-709193 (1/28/2011)
January 29, 2011 at 9:03 pm
mohammed moinudheen (1/27/2011)
Craig,I checked with one ex Microsoft employee. He says the product license is permanent but the product support would be renewed on yearly basis.
Ah, hm, okay. So,...
January 28, 2011 at 12:20 am
I agree with Lutz. Nice work on the data collection as well. The next step is to examine the query execution plans for @sUpdateLastYear between the windows and non-windows...
January 26, 2011 at 6:25 pm
MB, as Lutz pointed out, none of these queries allow us to compare the difference in the queries in your system when you do, or don't, add in the:
AND tblX.Div...
January 26, 2011 at 9:45 am
duncfair (1/25/2011)
January 25, 2011 at 3:45 pm
GSquared (1/25/2011)
And that's almost certainly more than anyone here wants to know about this subject. :w00t:
... listens enraptured. "Not really, that's damnably interesting, actually."
January 25, 2011 at 1:32 pm
LutzM (1/25/2011)
GilaMonster (1/25/2011)
...Bing maps are off then. It's just under 7500km from Johannesburg to Algier (http://www.wolframalpha.com/input/?i=what+is+the+distance+from+Johannesburg+to+Algier)
When using the same tool: London sounds much more reasonable 😉
Side note: interesting web site...
Nah...
January 25, 2011 at 1:09 pm
Follow the link in my sig that reads:
For index/tuning help, follow these directions.
It'll show you how to extract your .sqlplans
You can post the code here in the code="sql" tags, or...
January 25, 2011 at 1:06 pm
A quick test will show you how this works. Run this code in your analyzer:
;WITH cte (cola, colb, colc) AS
( SELECT 1,2,3),
cte2 (cola, colb, colc) AS
(SELECT 1,2,3)
SELECT
cola,colb,colc
FROM
cte
UNION...
January 25, 2011 at 12:46 pm
I'm thinkin' Greece. Gail wants gyros!
January 25, 2011 at 12:44 pm
Viewing 15 posts - 4,231 through 4,245 (of 5,685 total)