Viewing 15 posts - 25,846 through 25,860 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1117146-148-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
May 30, 2011 at 11:31 pm
cossy.cosmas (5/30/2011)
Can I run the SSMS from 2005 to get the execution plan for a query in SQL Server 2000?
There's a SQL 2000 section of that article.
Please in future post...
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
May 30, 2011 at 2:50 pm
cossy.cosmas (5/30/2011)
The DTA recommendations have reduced the elapsed time of this overnight activity from 2 hours 30 minutes to 1 hour 15 minutes.
Not all that impressive honestly.
I will be...
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
May 30, 2011 at 2:46 pm
Firstly stop shrinking your database. It's not something that should ever be scheduled and automated.
For the rebuild indexes, two things
- Switch to bulk-logged recovery for the duration if you can...
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
May 30, 2011 at 2:38 pm
Be very careful using DTA. It's prone to massively over-recommending new structures and often recommends far too wide ones too. Test each recommendation before implementing, consider the effects 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
May 30, 2011 at 1:41 pm
Can you explain your question further? Databases don't become orphaned....
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
May 30, 2011 at 10:08 am
If the ldf is still available and SQL is still running then you should be able to. You'll need to use a specifc option on the log backup - WITH...
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
May 30, 2011 at 10:04 am
1) Please expand your question. Are you asking about the difference between the actual log file (.ldf) and a tail log backup? If so, in what way, because it makes...
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
May 30, 2011 at 10:03 am
Ninja's_RGR'us (5/30/2011)
Set auto_close and auto_shrink to OFF.
+1000000
Recovering means simply that SQL closed your database (likely because auto_close was on) then next time the DB is needed it has to run...
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
May 30, 2011 at 9:58 am
Please post new questions in a new thread. Thank you.
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
May 30, 2011 at 9:41 am
What is the EXACT status that the databases are in when they're not available? (Query sys.databases, check the status column)
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
May 30, 2011 at 9:17 am
CLR uses memory outside of the buffer pool, ie outside of that 28GB you have reserved for the buffer pool.
I suggest you drop the max memory setting down a little...
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
May 30, 2011 at 8:09 am
SUPER SQL STAR (5/30/2011)
The fill-factor option is provided for fine-tuning index data storage and performance...
If you are going to quote from Books Online, say so and provide the reference....
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
May 30, 2011 at 8:02 am
SUPER SQL STAR (5/30/2011)
EXEC sp_resetstatus 'yourDBname';ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
No, no, NO!
That is 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
May 30, 2011 at 7:59 am
Oddly written procedures shouldn't cause any problems with replication.... What are the errors?
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
May 30, 2011 at 6:41 am
Viewing 15 posts - 25,846 through 25,860 (of 49,552 total)