Viewing 15 posts - 19,156 through 19,170 (of 19,564 total)
Looking at your spreadsheet, it looks like many of the items you see that have excessive fragmentation are actually Heaps. The heap designates that the table is just piled...
November 12, 2009 at 5:06 pm
Do you have BLOB data in the table?
November 12, 2009 at 5:00 pm
And for grins, just to tidy up a bit
select round(sqrt(sqrt(power(sqrt(avg(isnull(mycolumn,0))),7)))- power(avg(isnull(SumOfpktloanPBO,0)),.62250384),2)
from BLAH
select round(sqrt(power(sqrt(sum(isnull(mycolumn,0))),3)),2)
from BLAH
November 12, 2009 at 4:31 pm
Ok - to 4 decimal places now.
Avg = Sum
Since we deal in pennies, anything after 4 decimal places could be rounded (in theory), and thus Avg could = Sum in...
November 12, 2009 at 4:26 pm
GSquared (11/12/2009)
Kit G (11/12/2009)
Bob Hovious 24601 (11/12/2009)
I've been trying to keep my mind out of the gutter, thank you very much.To some, or for some, the gutter is an improvement.
Guilty!
(I...
November 12, 2009 at 1:11 pm
Alvin Ramard (11/12/2009)
CirquedeSQLeil (11/12/2009)
amazing how the thread can make a day go from bad to better. At least one good laugh a day.
At first I thought you said the...
November 12, 2009 at 1:09 pm
WhatDoughHeadUsesAVGinPlaceofSumWhenTryingtoGetASum
I figured i could use my new column name as a word since that is what I have been fixing in an executive report lately.
November 12, 2009 at 1:07 pm
Silverfox (11/12/2009)
Must be an american recruiter 😛
what wrong with we Americanz english? (JK)
Give the recruiter a break, it's not his fault there are so many exceptions to the rules (english...
November 12, 2009 at 1:02 pm
Nice question. My first inclination was to go with the foreach loop container (having done that before quite effectively) - but it was worth verifying what the multiflatfile does...
November 12, 2009 at 12:54 pm
amazing how the thread can make a day go from bad to better. At least one good laugh a day.
November 12, 2009 at 12:45 pm
Jeff Moden (11/11/2009)
Ian Scarlett (11/11/2009)
November 11, 2009 at 3:23 pm
I'll second Jack on the DTA. DTA isn't always accurate in the suggested indexes/statistics that it suggests.
November 11, 2009 at 10:12 am
Greg Edwards-268690 (11/10/2009)
Alvin Ramard (11/10/2009)
GSquared (11/10/2009)
Steve Jones - Editor (11/10/2009)
Hammers aren't fun for technical equipment on the fritz. Now a slingshot.....Depends on how you define the word "hammer"[/u].
The one...
November 11, 2009 at 9:59 am
select u.name as UserName,o.name as ObjectName from sys.sysobjects o
inner join sysusers u
on u.uid = o.uid
where [type] = 'u'
This will get you the ObjectOwner
November 9, 2009 at 5:16 pm
Viewing 15 posts - 19,156 through 19,170 (of 19,564 total)