Viewing 15 posts - 30,166 through 30,180 (of 49,552 total)
vijay1327-891581 (10/6/2010)
1: Remove count(*) and replace it with count(any one INTEGER type column).
Great if you're trying to slow the query down or change it's meaning. Not very successful...
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 6, 2010 at 9:43 am
WayneS (10/6/2010)
GilaMonster (10/6/2010)
... I have 3 table variable myths targeted.
Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can enhance...
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 6, 2010 at 9:41 am
CirquedeSQLeil (10/6/2010)
GilaMonster (10/6/2010)
Anyone interested in tackling the 'truncate table is not logged and cannot be rolled back' myth for this month's T-SQL tuesday?
That sounds like a fun one, unless you...
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 6, 2010 at 9:35 am
Ken McKelvey (10/6/2010)
Also, the trunc and sysdate functions suggest this is an ORACLE query.
I think you're right.
There's a TRUNC function in report builder, but not one in SQL Server and...
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 6, 2010 at 7:17 am
scott_lotus (10/6/2010)
GilaMonster (10/6/2010)
Stop 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 6, 2010 at 6:07 am
Paul White NZ (10/6/2010)
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top?http://www.sqlservercentral.com/Forums/FindPost999124.aspxNo, what makes you think it might have been?
Reading over it after I posted it read (to me) almost...
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 6, 2010 at 5:54 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic999129-1550-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 6, 2010 at 5:38 am
Brandie Tarvin (10/6/2010)
How do you know it's not backing up...
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 6, 2010 at 5:28 am
My guess is that you hit the 'debug' button rather than the execute button in management studio. It won't say debugging if you just ran the query.
Stop it, then hit...
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 6, 2010 at 5:16 am
The correct syntax aside, you should not be dumping the transactions at all. Run log backups if you need point in time recovery, otherwise switch to simple recovery model.
Take 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
October 6, 2010 at 5:13 am
You don't have the SQL 2008 database engine. All you have is the 2008 client tools (management studio and the like) and the only database engine you have listed there...
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 6, 2010 at 5:10 am
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.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 6, 2010 at 5:06 am
Gowtham Chowdary (10/6/2010)
Reg. performance as per my knowledge simple recovery will be better than full in case like BCP.
Maybe, but is there a lot of BCP on the distribution database?...
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 6, 2010 at 5:06 am
crazy4sql (10/6/2010)
GilaMonster (10/6/2010)
liewsb (10/6/2010)
Sorry to ask that should I choose the file or Database?Neither initially.
Gail, Why cant he shrink the file(log)?
Because if this is a case of full recovery, no...
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 6, 2010 at 5:00 am
liewsb (10/6/2010)
Sorry to ask that should I choose the file or Database?
Neither initially.
We have a schedule job to do a full backup on the database, but not these two file,...
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 6, 2010 at 3:45 am
Viewing 15 posts - 30,166 through 30,180 (of 49,552 total)