Viewing 15 posts - 32,641 through 32,655 (of 59,102 total)
Roy Ernest (9/6/2011)
Yay...!!! I beat the THREAD to the landmark. I hit 3000 posts before the thread hit 3000 pages. 🙂
I was going to post a prediction that you'd easily...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 6, 2011 at 12:23 pm
I was ready for Y2K in 1980 and I'm ready for 2079-06-06 right now. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 5, 2011 at 11:18 am
Tom.Thomson (9/3/2011)
I guess pop tarts are nice, but that's purely guesswork as I haven't a clue what one is.
It's fruit flavored SOS with the "S" on the inside. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 5, 2011 at 10:59 am
Ummmm.... what is the data-type for those date columns in the COALESCE?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 5, 2011 at 10:40 am
I know it's several years old but that's still a good article, Roy. They should rerun it now and again.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 5, 2011 at 10:28 am
mister.magoo (9/4/2011)
I tried your test data/sample query on my desktop with different results:
(Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 ...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 6:09 pm
Tom.Thomson (9/4/2011)
GilaMonster (9/4/2011)
Tom.Thomson (9/4/2011)
As for raisins in bobotie, wouldn't a green apple be better? Or maybe okra?
Yuk, No way. Raisins, ground or chopped almonds (I prefer ground), chutney and...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 5:19 pm
Brandie Tarvin (4/29/2011)
Save those points, boys and girls. It takes a couple of...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 5:15 pm
tinnusqlserver (5/5/2011)
I had created a text file named "forward.txt" in windows operating system. How can i know whether my text file...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 5:08 pm
GSquared (8/29/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 5:01 pm
cidr (9/4/2011)
Hi jeff. Do you know if this is still possible?
It absolutely possible. And, no, this is NOT directed at you but someone has really been eating some...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 4:29 pm
How about ~1 milli-second first time, everytime along with shorter times to rebuild the clustered index and maybe no need to ever rebuild it? 😉
The code below is in 3...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 3:38 pm
paul_ramster (8/31/2011)
If you're going to create a calendar table, it should contain more years than this,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 11:40 am
ColdCoffee (9/4/2011)
Added more details in code and optimized it.
Be careful, CC... The WHERE clause keeps it from being "optimized". The entire 1,000 rows in the "Numbers" CTE will always...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 11:25 am
tamil.selvanmca (9/2/2011)
(
SELECT 0 AS num
UNION ALL
SELECT num + 1 FROM DateYear
...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2011 at 10:37 am
Viewing 15 posts - 32,641 through 32,655 (of 59,102 total)