Viewing 15 posts - 29,101 through 29,115 (of 49,552 total)
GSquared (11/30/2010)
SELECT ..
FROM T1
inner join T2
on T1.a >= T2.b
inner join T3
on T1.a <= T3.c;
Would you still question it? It's the same 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
November 30, 2010 at 2:55 pm
Trey Staker (11/30/2010)
It kind of makes my head spin.
Yup. Far too late on a Tues evening to be thinking about relational theory.
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
November 30, 2010 at 2:47 pm
Page file != Virtual memory.
32 bit SQL? Have you changed the -g startup switch?
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
November 30, 2010 at 2:23 pm
Alvin Ramard (11/30/2010)
I'm still not sure about the number of records this might returned.
Who knows? Unless I'm missing something, it's a cross join between T2 and T3 (there's no limitation...
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
November 30, 2010 at 2:22 pm
Joe's pulled out his usual example over here: http://www.sqlservercentral.com/Forums/Topic1026791-392-1.aspx (please don't take that thread out of control. So far it's polite)
Before I reply to his assertions, I'd like an opinion...
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
November 30, 2010 at 2:06 pm
R2 is a different version of SQL to 2008. It's like SQL 2005 and SQL 2008.
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
November 30, 2010 at 1:32 pm
It works fine with service pack 3. I have more than one SQL 2005 instance on Server 2008 R2
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
November 30, 2010 at 1:19 pm
Apply service pack 3 for SQL and it'll be fine.
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
November 30, 2010 at 12:45 pm
Aside: Stop using the sa account. That's so far into the 'worst practices' territory you'll need a map to find 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
November 30, 2010 at 10:20 am
ALTER DATABASE <dbname> SET PAGE_VERIFY CHECKSUM
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
November 30, 2010 at 9:55 am
Jack Corbett (11/30/2010)
One unusual element of the Backup Exec SQL Agent is that a full backup does not truncate the log files. If you use SQL's own backup utility, a...
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
November 30, 2010 at 9:49 am
Indianrock (11/30/2010)
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
November 30, 2010 at 7:03 am
Please post new questions in a new thread. Thanks
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
November 30, 2010 at 5:46 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1027319-338-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
November 30, 2010 at 4:55 am
Robin_D (11/30/2010)
UPDATE #Tmp set StoredProc = @SProc
Shouldn't there be a where clause on that update?
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
November 30, 2010 at 4:44 am
Viewing 15 posts - 29,101 through 29,115 (of 49,552 total)