Viewing 15 posts - 36,136 through 36,150 (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/Topic808633-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
October 26, 2009 at 6:48 am
Krasavita (10/26/2009)
The way I understand the loop is running until hits < 4 million of records
Yeah, pretty much. Since rowcount is 4 million, the only time the update will do...
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 26, 2009 at 6:38 am
Another CPU? I'm not sure I understand what you're asking. More details please?
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 26, 2009 at 5:23 am
Brandie Tarvin (10/26/2009)
RE: DBCC UpdateUsage - this requires table names. Better to use "sp_updatestats" and it'll get all tables at once.
DBCC UpdateUsage and sp_updatestats do completely different things. Are 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 26, 2009 at 5:22 am
arun.sas (10/26/2009)
Thanks, but the results vary by set nocount on/off
Nope, it's not the setting of NoCount that's the cause.
Is anything I miss to obtain the result?
Yes. Common mistake. It's not...
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 26, 2009 at 3:59 am
omkarred (10/26/2009)
please elaborate on the clustered & non clustered indexes & implementation of it in actual db
That's what parts 2 and 3 cover.
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 26, 2009 at 3:56 am
arun.sas (10/26/2009)
Exec Get_Name 'Usa'Select @@rowcount
Ensure that, your procedure should not having/use of
SET NOCOUNT ON/OFF.
The setting of NoCount has no effect on @@RowCount. Setting NoCount on simply prevents SQL from...
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 26, 2009 at 3:13 am
Jeff Moden (10/25/2009)
Oh... be careful, Johan... XML splits are relatively slow compared to many other methods.
Plus the OP indicated he was still on SQL 2000 (despite posting in...
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 26, 2009 at 2:09 am
select *
from msdb.dbo.backupset bs
inner join msdb.dbo.backupfile bf on bs.backup_set_id = bf.backup_set_id
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 26, 2009 at 2:06 am
Attending.
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 26, 2009 at 2:02 am
Jeff Moden (10/25/2009)
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 26, 2009 at 1:56 am
No. Plans are memory only and are not included in a database backup.
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 26, 2009 at 1:54 am
repent_kog_is_near (10/25/2009)
Although they are not the same, the end result of Rebuild also accomplishes (or includes) what is done through a reorg (rearranging leaf level pages), right?
Both will fix the...
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 26, 2009 at 1:54 am
ianwilson91 (10/25/2009)
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 25, 2009 at 3:35 pm
UtterSQLNewb (10/24/2009)
The .bak file was 59MB but the .trn file was 188MB ( a massive increase over the first one).
Because you didn't take log backups.
Please read through this...
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 25, 2009 at 3:18 am
Viewing 15 posts - 36,136 through 36,150 (of 49,552 total)