Viewing 15 posts - 35,431 through 35,445 (of 49,552 total)
By workaround do you mean any way to cause side effects from within a finction? If so, no. It is a hard-and-fast requirement. You cannot make any changes to 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
December 8, 2009 at 3:30 am
setlan1983 (12/8/2009)
Example current log size is 10GB, if perform backup log regular, means the size will keep 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
December 8, 2009 at 3:05 am
Functions may not have side effects. They may not change the state of the database at all. That means no creating or dropping objects. No inserts, updates or deletes. You're...
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
December 8, 2009 at 3:01 am
Joie Andrew (12/7/2009)
Indexes will not have to be rebuilt.
They will. Shrink, with the default options can completely reverse an index, ie increase fragmentation up to almost 100%
See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
Shrinkfile...
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
December 8, 2009 at 2:54 am
Logins are in the master database. You should be backing that (and msdb and model) up on a regular basis.
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
December 8, 2009 at 2:51 am
Rod Harten (7/7/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
December 8, 2009 at 1:26 am
MTY-1082557 (12/7/2009)
should I stop it?It has 3:23hours already
No. Let it run to completion. Stopping it won't cause any problems, but you also won't get any results, essentially wasting the hours...
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
December 8, 2009 at 1:21 am
setlan1983 (12/7/2009)
What's is the different WITH NO_LOG & WITH TRUNCATE_ONLY?
Nothing. From Books Online
NO_LOG | TRUNCATE_ONLY
Removes the inactive part of the log without making a backup copy of it and truncates...
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
December 8, 2009 at 1:16 am
Britto (12/7/2009)
Which technique is best to use when performing operations with huge table size and vice versa?
It depends.
There's no one way that's always right, no one way that's always...
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
December 8, 2009 at 1:12 am
setlan1983 (12/7/2009)
May I know what is the proper way to reduce the log file size?
The proper way is to schedule regular log backups so that the space in 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
December 8, 2009 at 1:11 am
CirquedeSQLeil (12/7/2009)
GilaMonster (12/7/2009)
Grant Fritchey (12/7/2009)
Nah, I'm just peeved because of... well, read for yourself.
Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too polite...
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
December 7, 2009 at 1:51 pm
Where are you running it from? Management studio?
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
December 7, 2009 at 1:48 pm
DATEADD(dd,60,getdate())
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
December 7, 2009 at 12:15 pm
bryanc 761 (12/7/2009)
frigid
Midsummer
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
December 7, 2009 at 12:12 pm
GSquared (12/7/2009)
GilaMonster (12/7/2009)
BirthdayIf today is yours, Happy Birthday.
Yup.
I'm polite enough to not ask how old you are, and rude enough to guess 20-something.
Well, it's listed on my profile, so 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
December 7, 2009 at 12:11 pm
Viewing 15 posts - 35,431 through 35,445 (of 49,552 total)