Viewing 15 posts - 32,611 through 32,625 (of 49,552 total)
Two things
1) It's not guaranteed to be correct.
2) sysindexes is a deprecated system view, included only for backward compatability with SQL 2000 and will be removed from a future...
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
June 3, 2010 at 7:17 am
http://technet.microsoft.com/en-us/library/dd206979.aspx
Disable antivirus scanning of FILESTREAM volumes when it is not necessary (typo removed). If antivirus scanning is necessary, avoid setting policies that will automatically delete offending files.
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
June 3, 2010 at 7:07 am
Brandie Tarvin (6/3/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
June 3, 2010 at 7:03 am
Active/active has minimum 2 instances installed and has at least one instance running on both nodes. Active passive has instance only running on one node, installed but not running 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
June 3, 2010 at 6:00 am
MothInTheMachine (6/3/2010)
Actually the person I sent the 2000 mdf and ldf too said that the db attached fine to their 2000 and 2005 instance but wouldn't attach to their 2008.
Did...
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
June 3, 2010 at 5:58 am
Sorry, I don't understand what you're asking. Can you be more specific please?
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
June 3, 2010 at 5:53 am
Bhuvnesh (6/3/2010)
there should be substantial differnce between actual and estimated rows
Why would there be a row estimation discrepancy?
A discrepancy between estimated and actual rows is usually indicative of stale...
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
June 3, 2010 at 5:49 am
Tushar-355587 (6/3/2010)
Hi Buddha,Restore is the BEST option as SQL Server 2008 has lots of new system tables.
Huh?
No matter how the DB is migrated (detach/attach, backup/restore), SQL will run a series...
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
June 3, 2010 at 5:43 am
GilaMonster (5/31/2010)
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
I would also agree with Atif. The logic of intervals should remain on the front end and all...
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
June 3, 2010 at 2:12 am
What does CPU at 100% have to do with logs growing? Sorry, but there's just not enough info here to really say much
btw, if the log files are shrinking, then...
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
June 2, 2010 at 11:24 pm
Get a bigger hard drive?
Seriously, if the database has 50 odd GB of data in it, you can either delete unnecessary data or get more storage space.
How much 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
June 2, 2010 at 12:36 pm
Paul White NZ (6/2/2010)
You could see it as the perfect dead-pan response 😉
I could, but....
That thread also needs an award for the number of sheer useless answers. Seriously, 2 people...
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
June 2, 2010 at 12:29 pm
Thread continues : http://www.sqlservercentral.com/Forums/Topic931272-391-1.aspx
No replies to this thread please.
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
June 2, 2010 at 12:03 pm
Is every 5 hours often enough for log backups? If the tran log is growing a lot, it may not be.
Please read through this - Managing Transaction Logs[/url]
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
June 2, 2010 at 11:54 am
What a waste of good sarcasm...
http://www.sqlservercentral.com/Forums/Topic930338-1291-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
June 2, 2010 at 11:52 am
Viewing 15 posts - 32,611 through 32,625 (of 49,552 total)