Viewing 15 posts - 556 through 570 (of 8,416 total)
SELECT *
FROM dbo.Table1 AS t1
RIGHT OUTER JOIN dbo.Table2 AS t2 ON
t2.ID = t1.ID
EXCEPT
SELECT *
FROM dbo.Table1 AS t1
INNER JOIN dbo.Table2 AS t2 ON
...
May 24, 2012 at 12:11 am
Jeff Moden
SQL Kiwi
How do you define "set-based"? If each iteration processes a set (even if the set has one member) then in what sense is it not set-based?
Not...
May 23, 2012 at 11:47 pm
Jeff Moden (5/23/2012)
Oooooohhhh, be careful, Michael. That's a "Counting rCTE". Read the following article for why that's generally a bad idea. http://www.sqlservercentral.com/articles/T-SQL/74118/
Pro Tip: Reading the existing replies...
May 23, 2012 at 11:27 pm
xRafo (5/23/2012)
The delay is on the table PS_CO_IN_KARDEX where there are millions of records. Can anyone Help me please.
There are a number of potentially serious problems in the estimated...
May 23, 2012 at 7:26 pm
luckysql.kinda (5/23/2012)
Got the answer from some expert. This just confirms that the sql version > 7.0.
Well that was obvious, wasn't it?
http://www.simple-talk.com/community/forums/thread/1471.aspx
May 23, 2012 at 6:57 pm
SQLKnowItAll (5/23/2012)
Personally, I have never used any tools.
I just downloaded Schema Surf to try it on AdventureWorks. I have to say it's very impressive, and much more than just...
May 23, 2012 at 5:30 pm
luckysql.kinda (5/23/2012)
if @@rowcount = 0
if @@microsoftversion>0x07320000
...
May 23, 2012 at 5:09 pm
I hear good things about the free Schema Surf product from Atlantis Interactive:
http://www.atlantis-interactive.co.uk/products/schemasurf/default.aspx
Not used it myself, but it was recommended by Mladen Prajdic, which is good enough for me.
May 23, 2012 at 5:01 pm
Lynn Pettis (5/23/2012)
But you are correct, someone else reading this thread may not know that SQL Server 2008 supports filtered indexes.
Or, more to the point, that they can be used...
May 23, 2012 at 4:24 pm
Lynn Pettis (5/23/2012)
Which I am sure he knows as well. 😉
I got the reverse impression from this statement:
Come on... That's like saying a column can accept nulls unless it...
May 23, 2012 at 4:05 pm
GilaMonster (5/23/2012)
Unique index on a column that allows nulls that will never contain any null values
Ahem :w00t: So, the *index* won't contain any NULLs, but the column can (which I...
May 23, 2012 at 3:40 pm
SQLKnowItAll (5/23/2012)
Also note that a unique column can contain 1 null...
Unless the unique index is filtered to exclude NULLs 😀
May 23, 2012 at 3:16 pm
Slight variation on Lynn's method:
WITH
N1 AS (SELECT N1.n FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS N1 (n)),
N2 AS (SELECT L.n FROM N1 AS L, N1...
May 23, 2012 at 2:03 pm
Sean Lange (5/23/2012)
Be careful here. This cte that Mike used is what is called a recursive cte. It is NOT set based, it is hidden looping.
How do you define "set-based"?...
May 23, 2012 at 1:50 pm
Viewing 15 posts - 556 through 570 (of 8,416 total)