Viewing 15 posts - 31,951 through 31,965 (of 59,102 total)
For a spectrometer, you would expect all numeric values. Rather than bother with XML, why not store it all as "fixed length" fields within a fixed length BINARY datatype...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 6:53 pm
Grant Fritchey (11/18/2011)
WayneS (11/18/2011)
Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!Thanks.
I had no idea I was doing good work.
Awesome job, Grant......
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 5:44 pm
mbova407 (11/16/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2011 at 4:47 pm
What is the code used for the function named "Split", Chris?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2011 at 4:42 pm
Brandie Tarvin (11/17/2011)
I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2011 at 4:31 pm
kevin_nikolai (11/17/2011)
Hi Komal,Martins method: DWH.dbo.Split_Values(@Store_Code_List,',') should be used in stored proc's where clause (not in from clause).
Sorry, but no. Martin's method uses a WHILE loop and an mTVF. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2011 at 4:29 pm
ananda.murugesan (11/14/2011)
I created clustred index after that it won't help aslo same issues, as you suggested me that is correct after creating clustred index.
Once drop...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 16, 2011 at 5:26 am
Oh, my apologies... I lost track of this thread. Glad someone posted against it to refresh it in my inbox.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 16, 2011 at 5:14 am
j.miner (11/15/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 16, 2011 at 5:10 am
I don't know SSIS but "ragged right" strongly suggests missing columns. You don't have missing columns so turn off "ragged right".
Are you absolutely sure the last row has the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 15, 2011 at 8:30 pm
Koen Verbeeck (11/14/2011)
As soon as you dig a bit deeper they fall rather quickly through their disguise.
How well I know that. 🙂 I just hadn't really thought about how...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 14, 2011 at 10:50 pm
ananda.murugesan (11/13/2011)
GilaMonster (11/12/2011)
Widen this index: IX_CMTS_IPADD_D nonclustered located on PRIMARY CMMAC. Add CPEIP, CPEMAC
Thanks for reply...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 14, 2011 at 10:44 pm
SQL Kiwi (11/13/2011)
Efficiency, it seems to me, comes down to doing the least work possible to return the required results.
Agreed. But then there's that problem of defining efficiency. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 14, 2011 at 10:37 pm
Phil Parkin (11/12/2011)
Jeff Moden (11/11/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 12, 2011 at 9:12 pm
ananda.murugesan (11/12/2011)
kindly find the attached Execution plan about that query.I really sorry for the late replay...
10 Lacks Records Means - 1000000 Rows count.
Please Provide the solution
thanks
ananda
I believe, according to the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 12, 2011 at 8:50 pm
Viewing 15 posts - 31,951 through 31,965 (of 59,102 total)