Viewing 15 posts - 1 through 15 (of 32 total)
Thanks Grant - you're right, a REBUILD will write far more pages than a REORGANIZE, probably all of them in the table/index concerned. I was just hoping that those few...
November 5, 2020 at 1:41 pm
Thanks for the reply, Jeffrey, lots of useful information in there.
January 13, 2020 at 10:18 am
Thanks Jeff, you may be right!
Since those AVG_RANGE_ROWS values are stored to four decimal places of accuracy, you'd hope it might be possible to divine the computations that led to...
August 19, 2019 at 9:27 am
I think AzCopy is a good place to start.
Look at the /L and /V options.
May 10, 2019 at 3:16 pm
GilaMonster (8/13/2015)
Eric M Russell (8/13/2015)
Also it supports statistics and non-clustered indexes...
Table variables can have nonclustered indexes. No stats, but they can have nonclustered indexes. You just have to define them...
August 14, 2015 at 8:31 am
Hi Sourav
Thanks for contributing.
Just two minor points:
1. The script as it stands lists disabled triggers rather than all triggers - to be fair this was probably your intention and it...
August 7, 2015 at 3:16 am
SQLRNNR (8/4/2015)
newbieuser (8/4/2015)
August 6, 2015 at 3:55 am
Lenochka (6/1/2015)
June 3, 2015 at 5:47 am
Alan.B (5/27/2015)
Michael Meierruth (5/27/2015)
Alan B.How does your function stand up to a varchar(8000) column with an * at the beginning and end and all blanks in between?
Okay, first - both...
May 28, 2015 at 10:09 am
Gary Harding (5/13/2015)
dwain.c (5/12/2015)
Gary Harding (5/12/2015)
The main one is that the constraint didn't always fire.
If the column(s)...
May 18, 2015 at 4:38 am
dwain.c (5/12/2015)
Gary Harding (5/12/2015)
The main one is that the constraint didn't always fire.
If the column(s) passed into...
May 13, 2015 at 12:51 am
I've hit a few problems in the past using scalar UDFs in CHECK constraints.
The main one is that the constraint didn't always fire.
If the column(s) passed into the UDF as...
May 12, 2015 at 6:03 am
If they are stripped of their columns how is it all there meta data is still stored in the sys.columns 100s of times.
Not to mention possibly stale statistics retained from...
May 7, 2015 at 6:14 am
Chances are that if you've been secure this long, you'll still be secure for a few more years.
Hmm. As John C. Dvorak might once have said, can you spell...
April 30, 2015 at 5:45 am
...and then there's always SSMS' built-in reports (right-click on the database instance in Object Explorer).
Presumably they do something very similar to Eirikur's query under the hood, but with prettier output.
April 28, 2015 at 6:17 am
Viewing 15 posts - 1 through 15 (of 32 total)