Viewing 15 posts - 23,791 through 23,805 (of 49,552 total)
derekr 43208 (8/31/2011)
ThanksSo, i'm assuming that the index_id columns is the equivalent?
What do the numbers in that column indicate?
Did you look in the documentation I mentioned? http://msdn.microsoft.com/en-us/library/ms173760%28v=SQL.100%29.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 31, 2011 at 9:28 am
SwayneBell (8/31/2011)
Peter Maloof (8/31/2011)
SwayneBell (8/31/2011)
Ironically Gail, that's the exact person I had in mind when I made my comment about Oracle forums.
I don't think that's coincidental. That person's attitude is...
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 31, 2011 at 9:25 am
sysindexes is still deprecated, doesn't matter how you use it. Row count you can get in sys.partitions. Stats update date from Stats_Date function. There's no replacement for rowmodcrt, but 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 31, 2011 at 9:16 am
Don't use sysindexes for anything in SQL 2008. It's deprecated,will be removed in a future version.
Use sys.indexes. It's better documented and the columns are better named.
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 31, 2011 at 2:10 am
Tom.Thomson (8/30/2011)
It's what you get when some of the leaders of the ruling party revere Pres Mugabe as a shining example of the 'african agenda'
Well, since they clearly want 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
August 31, 2011 at 2:09 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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 31, 2011 at 1:31 am
Probably not a significant one.
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 31, 2011 at 1:29 am
If there are other processes then limit SQL's memory usage (via max server memory) in order to reserve some for them.
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 30, 2011 at 12:29 pm
GSquared (8/30/2011)
Michael Valentine Jones (8/30/2011)
Peter Maloof (8/28/2011)
SwayneBell (8/24/2011)
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 30, 2011 at 11:45 am
GSquared (8/30/2011)
GilaMonster (8/30/2011)
jasona.work (8/30/2011)
GilaMonster (8/23/2011)
Neither has just about any software product I've bought in the last few years (other than games)Games still come with manuals?? Since when? š
Just about...
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 30, 2011 at 11:36 am
royce.bacon (8/30/2011)
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 30, 2011 at 11:06 am
FLOOR(99.6513)
FLOOR (0.666666)
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 30, 2011 at 10:45 am
Yup, 2 Exabytes default.
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 30, 2011 at 10:43 am
Nothing (other than OS memory pressure) will make a running instance of SQL reduce it's memory utilisation. What you're seeing is normal, expected, documented behaviour.
Why is the large amount 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 30, 2011 at 10:29 am
jasona.work (8/30/2011)
GilaMonster (8/23/2011)
Neither has just about any software product I've bought in the last few years (other than games)Games still come with manuals?? Since when? š
Just about every one...
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 30, 2011 at 10:27 am
Viewing 15 posts - 23,791 through 23,805 (of 49,552 total)