Viewing 15 posts - 556 through 570 (of 814 total)
Jeff Moden (5/22/2011)
May 23, 2011 at 8:24 am
You missed an upgrade method particularly applicable to 2000 to 2008 (R2) conversions:
Machine swap.
You have Server, with SQL2000/5.
You buy/scrounge/spin up a VM NewServer.
You install SQL2008(R2) on NewServer.
You write down the...
May 20, 2011 at 6:45 pm
Ninja's_RGR'us (5/18/2011)
Thanks... not to be a smartass or anything but ever since 2005 I've always been told 10%, so where did he get that info?
Likewise, _why_ was 10% to 30%...
May 18, 2011 at 8:56 am
Separately, may I suggest looking at Ola Hallengren's (link) index maintenance work as well?
May 18, 2011 at 8:16 am
Ninja's_RGR'us (5/18/2011)
Am I misinformed in this? I was always told that reorg was between 10 and 30, not 5 and 30.
Reorg is between whatever values are right for your...
May 18, 2011 at 8:14 am
SQLRNNR (4/2/2010)
No single default fill factor is appropriate for all indexes. It should be evaluated case by case.
True; but it's our job as administrators to deliberate on the best...
May 18, 2011 at 8:05 am
Jeff Moden (5/11/2011)
Sorry... I missed this... Maybe not in your country or language but that's not what's implied by such language in my country and the two statements have drastically...
May 12, 2011 at 1:40 pm
Use Microsoft SQLIO and benchmark both configuartions; different hardware has different quirks and results; the rules of thumb are not always correct, despite all theory to the contrary (generally due...
May 12, 2011 at 1:34 pm
WI-DBA (5/11/2011)
At some point, you are going to have too many servers to manage doing on a server...
May 11, 2011 at 7:36 am
Hmmm... I usually just use SQL to find SQL data.
EXEC ('DBCC SQLPERF(logspace)'); - handles overall log information per database... but unless you have multiple Tlog files because you have critical...
May 11, 2011 at 7:23 am
I apologize for coming in late, but I've got a nice new server sitting around with modern Nehalem CPU's and scores of GB of RAM, and a limited time window...
May 10, 2011 at 7:10 pm
Tiering makes sense, if you can either handle a SAN doing it automatically (i.e. unpredictable performance), or you can split your workload up properly.
The article itself has a few issues,...
May 9, 2011 at 12:43 pm
Jeff Moden (5/7/2011)
Does anyone else have any other suggestions for a speed enhancement before I do that?
Nadrek and Peter. Thanks a million for taking the time to tweek the...
May 7, 2011 at 9:47 pm
Peter:
Here is my tally table generation code. The important elements are likely the DBREINDEX and UPDATE STATISTICS; while you "shouldn't" need them, I've found a very small difference by...
May 7, 2011 at 9:42 pm
Peter: On my machine, you've definitely beat the article's original try, and beat my Union version, but the 0 based permanent temp table is still better.
Wayne: thank you for the...
May 6, 2011 at 2:30 pm
Viewing 15 posts - 556 through 570 (of 814 total)