Viewing 15 posts - 31,696 through 31,710 (of 59,102 total)
Okidoki... First, please forgive my OCD nature when it comes to formatting. I just couldn't look at multiple INSERT/VALUES or all lower case object names anymore. These old eyes...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 10:29 pm
drew.allen (12/6/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 9:33 pm
Cadavre (12/12/2011)
Jim-720070 (12/12/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 7:32 pm
Kevin Mao-243787 (12/13/2011)
Four roles are listed in first Chapter of Professional Microsfot SQL Server 2008 Administration: Production DBA,Development DBA, Business Intelligence DBA & Hybrid DBA. For smaller organzations,...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 7:04 pm
GSquared (12/13/2011)
jcrawf02 (12/13/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 6:52 pm
Ninja's_RGR'us (12/13/2011)
Jeff Moden (12/13/2011)
Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D40F in Denver, no need for pants today.:-P
Gah! My eyes, my eyes!!!
Kilt again?? :w00t:
:hehe:
Yep... knocks...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 6:47 pm
jcrawf02 (12/13/2011)
From:...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 6:45 pm
ShawnTherrien (12/13/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 5:17 pm
Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D40F in Denver, no need for pants today.:-P
Gah! My eyes, my eyes!!!
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 3:57 pm
Sean Cowburn (12/13/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 3:54 pm
The Calendar View in the article is based on a "Counting rCTE". Please see the following article for why you should avoid such a thing.
http://www.sqlservercentral.com/articles/T-SQL/74118/
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 6:12 am
G-472796 is correct. You're probably looking for the POWER function. Just keep in mind that POWER returns the same datatype as the first operand. For example, trying...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 5:54 am
You bet. Thank you for the feedback.
If you ever design tables, remember what you just went through. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 5:33 am
Dev (12/13/2011)
Jeff Moden (12/12/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 5:27 am
MidBar (12/13/2011)
Yes 8192 is the limit.
I want to read very long xmls from a table and concatenate in with a string to make dynamic SQL and later execute that.
Now...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2011 at 5:04 am
Viewing 15 posts - 31,696 through 31,710 (of 59,102 total)