Viewing 15 posts - 121 through 135 (of 420 total)
I totally agree with Gail, but also, off the top of my head I'd say you may be limiting the records you put in the #table which makes a smaller...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 4:23 pm
Y, so I don't know your app, but I want to caution you before you go changing your cluster. Just make sure you do some decent perf testing before...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 10:16 am
I've personally never had much luck with the copy wizard. Backup/restore is always going to be more reliable, faster, and more repeatable. It also keeps that extra I/O...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 10:06 am
There's some good advice in here.
Did you ever solve this problem?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:49 am
Yeah I'd also like to hear if this issue has been resolved.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:47 am
And I don't know why you're looking at DBCC LogInfo() for this anyway.
Much easier is DBCC SQLPERF(LOGSPACE)
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:44 am
On top of that, check that you don't have the tempdb files set to grow at some ridiculous rate.
But no, just out of the gate there's nothing that would increase...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:36 am
Agreed, just don't include that col in the list.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:33 am
Have you looked at the setup log?
What does it say?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:30 am
I've never done any maint on ReportServerTempDB.
Are you seeing an issue that makes you ask this, or just wondering?
If just wondering, I wouldn't worry about it if I were you.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 2, 2015 at 9:17 am
Thanks, and everybody don't forget we're having a webinar Monday to walk you through the product ourselves. This is the perfect time for you to ask questions, though we're...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
October 24, 2014 at 7:36 am
Wow Peter, that's a great idea. Funny all the things we thought about and that never crossed our minds.
Can you add a feature req on the site for it?
And...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
October 24, 2014 at 7:21 am
I love any piece that ends with "crack filled".
Good job on this one. It's to the point and gives good practical advice.
I notice though that with everyone who talks...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 23, 2014 at 7:01 am
Why wouldn't it be ok with me? Yeah, go ahead.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 13, 2014 at 8:22 am
I always thought that one of the biggest reasons for using this over MERGE was that this is the only one not in the publ/subr model. That every node...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 13, 2014 at 7:12 am
Viewing 15 posts - 121 through 135 (of 420 total)