Viewing 15 posts - 31 through 45 (of 78 total)
Here are a few of my "versions" bookmarks...
http://www.sqlservercentral.com/articles/Build+List/71065/[/url]
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
http://www.sqlteam.com/article/sql-server-versions
http://sqlserverbuilds.blogspot.com/[/url]
http://blogs.msdn.com/b/sqlreleaseservices/
http://support.microsoft.com/kb/321185
http://blog.sqlauthority.com/2008/06/16/sql-server-introduction-to-serverproperty-and-example/[/url]
July 19, 2011 at 7:22 am
GilaMonster (7/13/2011)That'll work and the DBs will attach clean and without error...
So what is the best way to assure a totally clean shutdown of your database? Where all transactions have...
July 14, 2011 at 12:35 pm
AlexSQLForums (7/13/2011)
Are you setting up another SharePoint App in DCB?
We are actually moving to DCB, but we only have a limited maintenance window to do the move. So we have...
July 13, 2011 at 11:47 am
Elliott Whitlow (6/15/2011)
As a necessary practice, not a best practice, but a necessary one, Dev boxes...
June 15, 2011 at 1:23 pm
Phil Parkin (6/15/2011)
You could try this downgrade tool and see whether it helps.
That tool looks cool, thanks!
June 15, 2011 at 1:09 pm
Ninja's_RGR'us (5/26/2011)
Might be a good read for you too... todays featured article!http://www.sql-server-performance.com/2011/index-maintenance-performance/
Now that article is perfectly on point!
Unfortunately his answer is not good... there is no simple fix. Looks...
May 26, 2011 at 11:56 am
Ninja's_RGR'us (5/26/2011)
Does all that and way more...
Thanks for the link! And I think this might be an even more robust Index maintenance script (and other things)...
http://ola.hallengren.com/Documentation.html#IndexOptimize
Unfortunately in my production environment...
May 26, 2011 at 11:55 am
Michael Valentine Jones (5/19/2011)
The point is that with many applications, you do not know exactly when activity is taking place, or exactly what is happening.
Can we run and analyze a...
May 19, 2011 at 9:43 am
Ninja's_RGR'us (5/19/2011)
May 19, 2011 at 9:30 am
Ninja's_RGR'us (5/19/2011)
jpSQLDude (5/19/2011)
steveb. (5/19/2011)
why don't you run the t-log backups 24 hours a day?
SharePoint is used by office workers during regular business hours, so there should hardly be any...
May 19, 2011 at 9:09 am
steveb. (5/19/2011)
why don't you run the t-log backups 24 hours a day?
SharePoint is used by office workers during regular business hours, so there should hardly be any transactions happening...
May 19, 2011 at 8:35 am
Michael Valentine Jones (5/18/2011)
It's probably easier to just not create databases with a trailing space in the name.
Agreed, but this is a server I inherited, with over 100 databases on...
May 18, 2011 at 3:27 pm
Ninja's_RGR'us (5/16/2011)
Well it doesn't <completely> break it. that's why I said I preffer to have that run with full backups as first and last steps.
I'm pretty sure the instant...
May 16, 2011 at 9:12 am
Thanks Gail -- I went back to that server, hit F5, and log_reuse_wait_desc now returns NOTHING. That makes no sense! But "working" means I can move on to other stuff,...
May 16, 2011 at 8:34 am
Thanks Ninja, that seems very comprehensive (at least for those instances where you are able to break the log chain).
May 16, 2011 at 8:32 am
Viewing 15 posts - 31 through 45 (of 78 total)