Viewing 15 posts - 54,766 through 54,780 (of 59,078 total)
Oh, by the way, Gail... we had emailed back an forth a couple of times on examples when the Estimated Execution plans lies like a rug... the Northwind example I...
October 2, 2007 at 6:44 am
Heh... correct on both problems...
English skills on the part of the people I interviewed was not the problem, though. When you draw 1416 on a white board and say...
October 2, 2007 at 6:39 am
Nah... we'd loose the audiance between comebacks just like we did on this one 😀
October 2, 2007 at 6:22 am
Heh, yeah... the key was the @Dummy variable in this case. Needed it to get by the mix of columns and variables because the value wasn't necessary. The...
October 2, 2007 at 6:20 am
Show me why the space calculations are wrong or why any calculation can justify the unnecessary space wasted and unnecessary performance hit of auditing inserts.
And, although you said...
"Trying to...
October 2, 2007 at 12:41 am
Heh... maybe... it did turn our shining carriage into a pumkin...:D
October 2, 2007 at 12:21 am
Heh... no... not real painful 😀 Let me explain...
Let's say you have a table that looks like this...
--===== Create and populate a 1,000,000 row test table.
...
October 2, 2007 at 12:17 am
Heh... those are fun but I like the real-life questions that teach why or why not to do something... for example...
1. How many internal rows will be generated by...
October 1, 2007 at 10:27 pm
GilaMonster (9/30/2007)
Jeff Moden (9/29/2007)
I can't tell you the number of folks I've interviewed who have Masters or PHDs in mathematics that couldn't tell me what bit will be set by...
October 1, 2007 at 10:12 pm
What if I just want to delete orphaned users in sysusers and i enabled the "allow updates" then disabled it after deleting the orphaned user?Am I doing a very risky...
October 1, 2007 at 8:58 pm
Won't work with 2005's encryption routines. They're non-deterministic. Encrypt and compare will get you no matches.
Didn't know that. Wow... the boy's in Redmond pretty much blew it there...
October 1, 2007 at 8:41 pm
really old server, 512MB ram and 2 300Mhz processors (yes that's an M not a G)
I'm thinking that you've squeezed just about all the speed you're gonna get out of...
October 1, 2007 at 8:33 pm
Bob Fazio (10/1/2007)
Formatting in this new site is less than adequate.
I absolutely agree!
Insert of 3.3m rows.
Best run (no index). 270 - seconds
worst run (with index) 283...
October 1, 2007 at 8:21 pm
Kurt W. Zimmerman (10/1/2007)
October 1, 2007 at 7:01 pm
Viewing 15 posts - 54,766 through 54,780 (of 59,078 total)