Viewing 15 posts - 30,241 through 30,255 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic997293-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2010 at 1:25 pm
Paul White NZ (10/2/2010)
WayneS (10/2/2010)
Looks gorgeous. I envy you your view!
Maybe, but you wouldn't have envied me and Justin carrying a sofa and six-burner BBQ up the stairs this morning....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2010 at 2:16 am
In that case, you don't want to look at the physical storage locations (which is what I thought you were asking for)
Have a read through this (and the discussion) see...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2010 at 7:54 am
getoffmyfoot (10/2/2010)
You don't think there would be some performance gain here by breaking some of the subquery logic into table variables instead of lots of sub-selects?
Maybe, but there are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2010 at 7:48 am
Jeff Moden (10/1/2010)
GilaMonster (10/1/2010)
jcrawf02 (10/1/2010)
Just realized the solution, I'll have to find a carrier pigeon to tie a flash drive to and send it your way.... 😉
I look forward to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2010 at 2:38 am
Craig Farrell (10/1/2010)
GilaMonster (10/1/2010)
Craig Farrell (10/1/2010)
... only 4:12 PM here. 🙂
Shouldn't you be in the pub then? Maybe it's an African thing (I doubt), but friday post 4pm here just...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2010 at 2:33 am
Craig Farrell (10/1/2010)
... only 4:12 PM here. 🙂
Shouldn't you be in the pub then? Maybe it's an African thing (I doubt), but friday post 4pm here just about no one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 5:19 pm
Ow! My mail! And on a friday night too. Get away from thy computers and go do something normal for a friday night! (and before anyone complains, I've been away...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 5:03 pm
The join is faster because that CASE expression is not SARGable. Not sure why you have the CASE there in the first place.
This may be of interest: http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 4:50 pm
getoffmyfoot (10/1/2010)
Yes I'd like to see some query...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 4:44 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 12:32 pm
Generate script with data is NOT one of the ways I'd recommend for moving the data. SSIS, mcp or import/export wizard are far more effective.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 12:28 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 11:43 am
PYDSS517 (10/1/2010)
What is/are CTEs?:ermm:
http://www.google.com/search?q=CTE+%22SQL+Server%22
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 11:13 am
jcrawf02 (10/1/2010)
Just realized the solution, I'll have to find a carrier pigeon to tie a flash drive to and send it your way.... 😉
I look forward to the delivery. It...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2010 at 10:43 am
Viewing 15 posts - 30,241 through 30,255 (of 49,552 total)