Viewing 15 posts - 25,201 through 25,215 (of 49,552 total)
That's from SQL 2000 Enterprise manager?
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
July 4, 2011 at 3:15 pm
Jeffrey Williams-493691 (7/4/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
July 4, 2011 at 10:37 am
alinusha_sibi (7/4/2011)
I've tried to perform checkDB with repair_allow_data_loss, but error messages were returned.
Could you be a bit more specific than 'error messages were returned'?
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
July 4, 2011 at 10:31 am
Ninja's_RGR'us (7/4/2011)
That's why imho, MCM is the ONLY cert that really means something where hiring someone. Everything else is nice to have.
But there are so few who...
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
July 4, 2011 at 9:15 am
Please note: 6 year old thread.
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
July 4, 2011 at 9:14 am
Ninja's_RGR'us (7/4/2011)
From our beloved http://www.sqlservercentral.com/Forums/Topic1134935-146-1.aspx
I've reported it (long time ago), not least due to the insults he was tossing at me earlier on. Steve can do his magic on 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
July 4, 2011 at 9:06 am
You don't actually need to install it on the server. You can install on a workstation, though then the compare will be slower because of moving all the data around.
Seriously,...
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
July 4, 2011 at 9:04 am
Log backups don't block transactions.
You could be hitting the limit of the IO that the drive can handle and the additional from the log backup is just pushing over 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
July 4, 2011 at 8:58 am
Red Gate's SQLDataCompare comes to mind immediately
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
July 4, 2011 at 8:56 am
koustav_1982 (7/4/2011)
.Even for a Index Seek, the query has to do scan through the B Tree Structure to get to Brown.
It's not a scan. It doesn't start at A and...
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
July 4, 2011 at 8:34 am
Syed Jahanzaib Bin hassan (7/4/2011)
Here is some advice, start learning more about one SQL Server. Take the code you suggested in this thread and figure out how you would 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
July 4, 2011 at 8:32 am
Syed Jahanzaib Bin hassan (7/4/2011)
CREATE NONCLUSTERED INDEX idx_1 ON T (Col1, Col2)
the leaf level will be Col1,Col2
CREATE NONCLUSTERED INDEX idx_1 ON T (Col2)
the leaf level will be same too as...
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
July 4, 2011 at 8:28 am
SwayneBell (7/4/2011)
I didn't realize that a person could earn the MVP more than once... I thought it was a permanent designation once you got it the first time.
No. It'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
July 4, 2011 at 8:16 am
Syed Jahanzaib Bin hassan (7/4/2011)
No it's not. SQL includes the clustering key in all nonclustered indexes anyway whether you specify it or not
I agreed,but there is no need to mentioned...
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
July 4, 2011 at 1:17 am
Lots of open transactions or committed transactions not written to disk. That, especially if you have lots of VLFs will cause a long recovery time.
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
July 4, 2011 at 1:13 am
Viewing 15 posts - 25,201 through 25,215 (of 49,552 total)