Viewing 15 posts - 39,796 through 39,810 (of 59,072 total)
David.Poole (2/11/2010)
Basically a project team is given a fixed...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2010 at 6:51 pm
george sibbald (2/11/2010)
Jeff Moden (2/10/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2010 at 6:49 pm
Heh... OK... got it. You write nice tight code all the time and I was just wondering if you saw something that I was missing.
To be sure, I always...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2010 at 12:01 pm
Sorry, Nabha. Your code certainly looks like it'll work just fine. Considering the data spec, I was just wondering why you went the extra mile with the correlated...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2010 at 6:55 am
Heh... so MS is only now discovering some of the features left behind by the people who originally wrote Sybase. 😛
Not to worry... if it's documented anywhere by MS,...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2010 at 6:48 am
My bad... not sure what I was thinking. Previous code will return blanks and not nulls. The following will return nulls for the missing data and is a...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 10:47 pm
Yes... more features... but the wrong way...
I'm not sure if they've fixed the problem yet or not but my understanding is that 64 bit versions cannot use JET drivers... that...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 10:37 pm
Nabha (2/10/2010)
Maybe I'm missing something but could it be as simple as this?
Regards,
Willem
That would give the records even if the employee is not active now.
and the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 10:32 pm
I boot my servers with more than 8GB for TempDB. 😉
Give it some room to breath and stop shrinking it. Also, as you're finding out, scheduled shrinking of...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 10:18 pm
I never import to the final table... I always import to a "staging" table and then use some "upsert" or "merge" code I've written to both pre-validate the data and...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 10:09 pm
My guess would be that 8000 is too small as soon as you need 8001. 😉
While it would be nice to maybe have more than 8060 bytes, it'll get seriously...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 10:03 pm
Manie Verster (2/10/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 9:15 pm
Hi Scott,
You're new to the forum and you've just run into the same problem that a lot of folks run into. To find out what that problem is and...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 8:58 pm
Like Remi said, "Where's the 10 Star button?" Outstanding article, David. Definitely a classic and a keeper.
One of my personal favorite time bombs is when people write, ummmm.......
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 8:50 pm
Ryan C. Price (2/10/2010)
nicholasw (2/10/2010)
Instead of:IF EXISTS(SELECT 1 FROM ......WHERE....)
Would the following be quicker still?
IF EXISTS(SELECT TOP 1 1 FROM ......WHERE....)
No, and it doesn't really make sense - TOP implies...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2010 at 7:59 pm
Viewing 15 posts - 39,796 through 39,810 (of 59,072 total)