Viewing 15 posts - 121 through 135 (of 173 total)
Luis Cazares (6/5/2013)
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
The problem with that is you'd have to create the table separately, when you said...
June 5, 2013 at 3:58 pm
floresg2 (6/5/2013)
He understood using a case statement but he had never used modulo (%). This was a guy with years of supposed SQL experience.
How often have you used modulo...
June 5, 2013 at 3:34 pm
Sean Lange (6/5/2013)
sk them how they would solve the standard Fizz Buzz problem in t-sql with no loops and no cursors.
Using recursion? or would you class it as a loop?...
June 5, 2013 at 3:26 pm
So you're saying file_id 2 (the first log file) always has to exist? e.g. if the second logfile was being written to now (file_id 7) then I couldn't remove the...
June 3, 2013 at 5:11 am
GilaMonster (5/27/2013)
May 27, 2013 at 5:58 am
It wasn't my intention to be insulting. Just that if fragmentation is a result of pagesplits (ignoring autoshrink etc) then I would assume you could say "reduce fragmentation" or "reduce...
May 27, 2013 at 4:54 am
Comparisson not really relevent but doesn't matter. You can't move your knee without moving your shin.
May 27, 2013 at 4:42 am
They're 1 and the same. Can you reduce fragmentation without reducing page splits?
Thanks for that Lynn, will look about including it 😮
May 27, 2013 at 3:41 am
It's the same thing -_ rebuild index -> avg_fragmentation_in_percent reduces along with page splits. I'll play around/Google at work on Tuesday for some TSQL for a rebuilding job.
Thanks for the...
May 26, 2013 at 5:57 pm
GilaMonster (5/26/2013)
avg_fragmentation_in_percent and avg page space used.
Which do you tend to rate as the more important of them? For example, the common stat seems to be > 30% then...
May 26, 2013 at 2:46 pm
GilaMonster (5/26/2013)
From the results, looks like lots of page splits plus lots of deletes leaving you with high fragmentation and low page usage. Those indexes need a rebuild.
Oh, no. I...
May 26, 2013 at 1:01 pm
Lynn Pettis (5/26/2013)
May 26, 2013 at 12:52 pm
The AutoShrink setting for the database (properties -> options -> AutoShrink). It's not what you were talking about?
Here's the extra column in the query:
index_idnameavg_fragmentation_in_percentpage_countavg_fragment_size_in_pagesforwarded_record_countavg_page_space_used_in_percent
10I_SERVER_CLIENT_LOG_1_CLIENT_ID83.19381286074483593261.1882827200545NULL64.1397949098097
5I_SERVER_CLIENT_LOG_1_LOG_IDX99.22318898576143398511NULL67.8164319248826
7I_AGENT_TRAFFIC_LOG_1_LOG_IDX99.21425143953941833921NULL66.8855942673585
4I_AGENT_TRAFFIC_LOG_1_TIME_PLUS56.57114188682571813841.71474489265355NULL74.9793427230047
4I_AGENT_TRAFFIC_LOG_2_TIME_PLUS01454481212.06666666667NULL99.5304917222634
0NULL40.516415049125313235617.146780671071403.01700024709661
7I_AGENT_TRAFFIC_LOG_2_LOG_IDX01305731450.81111111111NULL99.9996911292315
0NULL99.81287684524221153738.00923290524124095.6287867556214
6I_AGENT_BEHAVIOR_LOG_1_LOG_IDX99.24384638326991139981NULL67.7993946132938
May 26, 2013 at 12:01 pm
Lynn Pettis (5/26/2013)
You won't get the avg_page_space_used_in_percent unless you run it using 'DETAILED'. In 'LIMITED" (or NULL in your case) this value is always null.
Yep, 17 minutes & counting...
May 26, 2013 at 11:53 am
Autoshrink is disabled in 10.5. There wouldn't be any manual shrinking because there's no real maintenance for our SQL Servers =//
The 'DETAILED' option is so slow >_<
Dird
May 26, 2013 at 11:48 am
Viewing 15 posts - 121 through 135 (of 173 total)