Viewing 15 posts - 33,796 through 33,810 (of 59,102 total)
Sorry... didn't read the post correctly and withdrew my post.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 8:43 pm
If you don't have the Enterprise Edition, Table Partitioning isn't an option (IIRC).
You could pull off a similar trick with a "Partitioned View". Look for it in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 8:33 pm
Let's stop and think about a calulator for a minute. Would you use one that only had a scale of 4 decimal points? Probably not. Would you...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 7:34 pm
My recommendation would be to lookup the "LIKE" operator in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 7:24 pm
Grant Fritchey (5/29/2011)
You're right, this can be practically a religious war.
Heh... "It Depends". In my shop, they do it my way or I take them out for a nice...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 7:22 pm
Just to add one more that you already have access to... do a search in the BOL index for "Tutorial".
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 7:20 pm
Almost forgot... here're the stats output from my desktop...
(100000 row(s) affected)
(100000 row(s) affected)
SQL Server Execution Times:
CPU time = 625 ms, elapsed time = 3332 ms.
(100099 row(s)...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 7:15 pm
What I've found is that if a "pretty" graphical output isn't required, that it takes a whole lot longer to transfer the data to something like SSRS or Crystal, time...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 7:09 pm
Lucky9 (5/31/2011)
From the application side he will pass me the...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 5:37 pm
CELKO (5/31/2011)
Do you also believe in the Magical, Universal Elixir that will cure all diseases and restore youth?
Hell YES!!! It's called "Beer"! 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 5:24 pm
opc.three (5/31/2011)
(replaces sp_makewebtask too
BWAA-HAAA!!!! In my eyes, there will never be a sufficient replacement for that wonderful tool. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 5:22 pm
Hi Thomas.
Nice setup. Thanks.
If you write the code to return the food ID and the list of animals that like the food (food ID and animal name make a...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 5:19 pm
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Nope... it's the terminal velocity for a pork chop with a bone in it. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 4:36 pm
SQLRNNR (5/31/2011)
Craig Farrell (5/28/2011)
*chanting*I will not smack Syed with a heavy hand...
I will not smack Syed with a heavy hand...
I will not smack...
*mumbles off to another room, still chanting*
I'm thinking...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 4:33 pm
David-155102 (5/31/2011)
Thanks both for your suggestions; I've very quickly tested Magoo's code against my sample data and it does return the expected results. I'm going to need a bit of...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 6:12 am
Viewing 15 posts - 33,796 through 33,810 (of 59,102 total)