Viewing 15 posts - 22,411 through 22,425 (of 49,552 total)
What is the current situation? Not the initial errors, those are pretty irrelevant since you rebuilt the system databases. What is the exact current situation?
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
November 9, 2011 at 1:31 am
thedom4302 (11/9/2011)
what would be a good percentage to have of memory to database size ?
No hard and fast number there. Depends on the usage patterns, the amount of data that's...
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
November 9, 2011 at 1:30 am
thedom4302 (11/9/2011)
performance would not be 200% better either its not like the raw table data sits in memory..
Err, that's exactly what does happen, whether you have more memory than data...
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
November 9, 2011 at 1:10 am
I'd call that a utopia state, but one that I've almost never seen.
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
November 9, 2011 at 1:00 am
derekr 43208 (11/8/2011)
When talking about an Index Key, is that the data in the columns it covers?
No, just the column defined as the index key, the column(s) that the index...
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
November 9, 2011 at 12:10 am
One thing first.
SQL Server clustering is not load balancing. It's purely high availability. With SQL clustering a database server is active on one node and inactive on the other 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
November 9, 2011 at 12:07 am
How can BCNF be sensibly discussed if the earlier normal forms aren't known?
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
November 8, 2011 at 4:25 pm
The Dixie Flatline (11/8/2011)
daveriya (11/8/2011)
i want to order my result by 1,5 ..not with column nameHasn't ordering by column number been deprecated?
I thought so too, but I can't find 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
November 8, 2011 at 3:55 pm
Don't hack the system tables, it's likely what caused this in the first place and if you don't know what you're doing you could make things far worse. sys.objects isn't...
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
November 8, 2011 at 3:28 pm
SQLRNNR (11/8/2011)
GilaMonster (11/8/2011)
I give it about a month and a half to two months before I pass Steve for top place overall.
Taking a break? Just curious why waiting so...
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
November 8, 2011 at 2:55 pm
I give it about a month and a half to two months before I pass Steve for top place overall.
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
November 8, 2011 at 2:47 pm
PaulB-TheOneAndOnly (11/8/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
November 8, 2011 at 2:45 pm
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
November 8, 2011 at 2:44 pm
mbender (11/8/2011)
Page Verify Option:TORN_PAGE_DETECTION
Though you do want to fix that at some point.
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
November 8, 2011 at 1:41 pm
Implicit transactions isn't a database-level setting. It's a client setting, so client apps would enable it (or not) when they connect.
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
November 8, 2011 at 1:38 pm
Viewing 15 posts - 22,411 through 22,425 (of 49,552 total)