Viewing 15 posts - 571 through 585 (of 814 total)
peter-757102 (5/6/2011)
May 6, 2011 at 11:13 am
Jeff Moden (5/4/2011)
I guess I'm going blind or slowly insane. I didn't look that closely at Nadrek's functions before. The only mods he made were on the Tally...
May 5, 2011 at 7:53 am
sqlbuddy123 (4/30/2011)
Coming to CPUs, you need to use Processor Affinity to dedicate processors to the SQL Server instances.
+1
Do not use the automatically set processor affinity checkbox; assign each instance its...
May 5, 2011 at 7:22 am
Horatiu Ripa (5/4/2011)
...
At the end of the day I may say:
- when SQL is deep in the militarized zone, beneath multiple layers and security levels, the...
May 5, 2011 at 7:13 am
WayneS (5/3/2011)
Nadrek (5/3/2011)
WayneS (5/3/2011)
May 4, 2011 at 2:32 pm
WayneS (5/4/2011)
Nadrek, I was thinking about this on my commute, and am wondering if you would test this out (I'm not going to have the time today like I had...
May 4, 2011 at 1:06 pm
SQLRNNR (5/3/2011)
Please post your code for this multi cte temporary tally table that outperforms the others. I am sure several others would like to test it.
The multi cte temporary...
May 3, 2011 at 4:08 pm
The multi CTE temporary tally does not beat a permanent table.
A permanent tally table with a single, simplified CTE loses to the multi CTE temporary tally table.
A permanent temp table...
May 3, 2011 at 3:51 pm
WayneS (5/3/2011)
May 3, 2011 at 3:31 pm
Craig Farrell (5/3/2011)
B'narg! Whaaaa? After a point I'd have expected the Perm table to stabilize more to the memory build.
Wow.
Try one of the two double-CTE versions I posted...
May 3, 2011 at 12:35 pm
Jeff Moden (5/2/2011)
Well, that makes 3 of us. We have a quorum! 😛 Phil Factor wrote an article fairly recently on all the XML, JSON, and other...
May 3, 2011 at 9:42 am
Jeff Moden (5/2/2011)
I also usually prefer TAB delimited or, even better, ASCII characters 28 through 31 (yep, there are characters designed for this type of stuff but no one uses...
May 2, 2011 at 2:04 pm
May I suggest looking at http://ola.hallengren.com/%5B/url%5D? Ola has some fairly advanced, easy to use scripts for many aspects of maintenance, including index maintenance, backup, and integrity checking.
April 29, 2011 at 10:13 am
Quite common: indexes on #temp tables.
Uncommon, but not unheard of: temporary indexes on permanent tables, always as a result of benchmarking with our actual production dataset such that the aggregate...
April 29, 2011 at 9:51 am
It's note an Excel binary excel file, but it does end up in a tab delimited format that cleanly imports into excel on a double-click if you name it .xls...
April 27, 2011 at 9:52 am
Viewing 15 posts - 571 through 585 (of 814 total)