Viewing 15 posts - 3,016 through 3,030 (of 18,926 total)
I don't want to overwrite the msdb db.
I want to restore msdb as a user db called <msdb_oldor whatever>.
Then I want to insert "missing" data in a couple of the...
September 6, 2011 at 8:22 am
Another 0.02 cents (not a typeau).
I don't have SSD in prod nor do I have tested it.
The fact is afaik MS never spoke about disk speed in their fragmentation recommendations.
The...
September 6, 2011 at 8:11 am
All the reasons not to use nolock (readuncommited)
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
I'd still like to see the actual execution plan (especially when slow).
When's the last time you reindexed / updated the stats?
Do you filter...
September 6, 2011 at 7:05 am
Check if the user has access to master.
It's most likely a monitoring app or service that doesn't specify the 3rd party db in the connection string and then does use...
September 6, 2011 at 6:49 am
GSquared (9/6/2011)
Either way, every DBA or future...
September 6, 2011 at 6:47 am
Is the jobid indexes?
Do you have triggers?
Do you have a ton of indexes on that table?
Do you have lots of fks (or any of them NOT indexed correctly)?
Waitfor in the...
September 6, 2011 at 6:37 am
Way more than you should ever need.
Why do you ask / need to know?
September 6, 2011 at 6:35 am
I just hit report on your post so Steve will take a look at it.
No sure what else you could have done except e-mailing Steve directly.
September 6, 2011 at 6:30 am
I use reporting services. Never had a report / dashboard I couldn't do.
Like any tools it has its good and bad. I've never used anything other than...
September 6, 2011 at 6:29 am
Hire someone. You need to analize the needs and actually fulfill them.
I've never seen on out of the box do that 100%, assuming one exists for your boss.
September 6, 2011 at 6:16 am
What do you need exactly? This question is too vague to answer.
September 6, 2011 at 6:05 am
Ask what changed to the san / network admin.
Things just don't slow down on their own.
September 5, 2011 at 11:38 am
GilaMonster (9/2/2011)
Jack Corbett (9/2/2011)
In comparison to most 2nd and 3rd world countries a person making minimum wage in the US is making "Amazingly High Wages".
Out of curiosity, what is US...
September 2, 2011 at 11:57 am
SQLRNNR (9/2/2011)
Ninja's_RGR'us (9/2/2011)
That was the calm before the storm (Irene).That was our 2nd storm of the century here in 6 months.
Nice year 2k11 😛
Nice pic.
Yup, nice place to...
September 2, 2011 at 10:54 am
That was the calm before the storm (Irene).
That was our 2nd storm of the century here in 6 months.
Nice year 2k11 😛
September 2, 2011 at 10:06 am
Viewing 15 posts - 3,016 through 3,030 (of 18,926 total)