Viewing 15 posts - 31,441 through 31,455 (of 49,552 total)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic963971-1292-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
August 4, 2010 at 11:51 pm
Adiga (8/4/2010)
You may find this bulletin useful.
That's for SQL 2000. There are better ways of investigating deadlocks on SQL 2005/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
August 4, 2010 at 11:51 pm
Tara Kizer (8/4/2010)
Then after the first 500 and finally when around 20% plus 500 modifications have occurred...
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
August 4, 2010 at 11:39 pm
Tara Kizer (8/4/2010)
That is some bad code then. 😉
If you're curious, have a look at the code and read some of the comments that I left out... Also of...
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
August 4, 2010 at 3:53 pm
Easy to prove.
sp_helptext 'sp_updatestats'
Excerpt:
set @index_names = cursor local fast_forward read_only for
select name, indid, rowmodctr from sys.sysindexes
where id = @table_id and indid > 0 and indexproperty(id, name, 'ishypothetical') = 0
order by...
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
August 4, 2010 at 3:41 pm
Steve Jones - Editor (8/4/2010)
We have that clock in the kitchen in our house. People think it's funny.
My supervisor at the university has a very irritating clock. No numbers on...
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
August 4, 2010 at 3:27 pm
No, you want to end the quote before putting your reply in, not start another. Still hard to work out who said what. Like this:
GilaMonster (8/2/2010)
mrpush (8/2/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
August 4, 2010 at 3:22 pm
Tara Kizer (8/4/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
August 4, 2010 at 12:13 pm
Jack Corbett (8/4/2010)
GilaMonster (8/4/2010)
Jack Corbett (8/4/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
August 4, 2010 at 12:11 pm
ALZDBA (8/4/2010)
and how do they store +24 hours in that time column ? (add an extra daycounter column ??) 😉
Can't happen. There's a row per day and the hours 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
August 4, 2010 at 11:53 am
Jack Corbett (8/4/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
August 4, 2010 at 11:02 am
Pete-L (8/4/2010)
Hmm strange, when I script out the GUI the command includes the TRUNCATEONLY
Yes it does. Doesn't make it right. Check Books online
DECLARE @command1 varchar(100)
DECLARE @command2 varchar(100)
exec sp_MSforeachdb set...
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
August 4, 2010 at 10:18 am
Pete-L (8/4/2010)
If I was to try and get the MSforeachdb working am I on the right track?
No. Shrink file can't refer to a query, it needs a value....
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
August 4, 2010 at 8:21 am
Mind zipping that? It's a little large.
i wasn't asking if you were seeing high disk usage. You said that you were. I asked if it has been checked and confirmed...
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
August 4, 2010 at 6:39 am
As long as it's a once-off....
You can do this with foreachDB, but it's far from the easiest way. The below script will generate all the shrink commands for you. That...
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
August 4, 2010 at 6:32 am
Viewing 15 posts - 31,441 through 31,455 (of 49,552 total)