Viewing 15 posts - 7,156 through 7,170 (of 8,416 total)
crainlee2 (9/4/2009)
Yes, running against the production server. Plenty of reserve power. No harm in doing it. DTA barely shows any resource utilization on PERFMON.
It's good to know that DTA is...
September 7, 2009 at 7:37 pm
Bob Hovious (9/7/2009)
Okay, I'm in synch with your question now. Sorry for the confusion. It seems to be my day for it.
I wouldn't worry about...
September 7, 2009 at 7:23 pm
Bob Hovious (9/7/2009)
September 7, 2009 at 7:02 pm
Yes - the DTA certainly isn't perfect, though it is occasionally worth a run just to see if there's anything obvious. Never take the recommendations completely literally!
September 7, 2009 at 4:14 pm
I have an Uncle and Aunt in Bogen (near Straubing), so you never know...
September 7, 2009 at 4:04 pm
Marcin Gol [SQL Server MVP] (9/7/2009)
Paul ... but here you have a "special" index on field: any_date_year AS YEAR(any_date) so 😉
Yes - I cheated slightly to illustrate a point:...
September 7, 2009 at 4:01 pm
PP (9/7/2009)
I mean, there were 114 records with 2009 as year and...
September 7, 2009 at 4:00 pm
charipg (9/7/2009)
yes dbcc updateusage is not workedout.my issue is stil not resolved.
sql version is 8.0
how to findout actual logspaceused.
The counter you are using seems to be the right one -...
September 7, 2009 at 3:54 pm
Bob Hovious (9/7/2009)
Thinking about your results, the table itself is smaller than the index in this case. Why?
Any index (clustered or non-clustered) may also require extra pages for...
September 7, 2009 at 3:40 pm
Grant Fritchey (9/7/2009)
September 7, 2009 at 2:47 pm
Florian Reischl (9/7/2009)
(And there will be thousands of guys from New Zealand here in Munich :-P)What about you? Things are fine?
All good here yes. Spring has sprung so we...
September 7, 2009 at 2:45 pm
It's good to hear you are keeping busy anyway 🙂
Though the management side of things sounds quite dull.
Florian Reischl (9/7/2009)
Paul White (9/7/2009)
September 7, 2009 at 4:04 am
ps (9/6/2009)
Very Neat and Tidy script Paul 🙂
Thank you Pradeep!
I had a few minutes spare and your read-only file group idea made me think of a few things which I...
September 7, 2009 at 3:27 am
Florian Reischl (9/7/2009)
There are a couple of better ways to handle this in SQL Server 2005/2008.
Sure. But for a table which just needs sequential row numbers adding to it,...
September 7, 2009 at 2:56 am
Norman-Jet.O-Calub (9/6/2009)
After this i receive Time out expired....
September 6, 2009 at 11:28 pm
Viewing 15 posts - 7,156 through 7,170 (of 8,416 total)