Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,906 through 31,920 (of 59,099 total)

RE: I have a coworker....

Lowell (11/15/2011)
I have a coworker who heats up things in the microwave.
(He or She) clicks the Instant 30 seconds button, waits 10 seconds, watching the count down, and then clicks...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:59 pm

#1411168
RE: Error converting data type varchar to bigint.

bitbucket-25253 (11/21/2011)
I will refer you to an article by Jeff Moden, in the "Spackle series of articles" here on SCC.
http://www.sqlservercentral.com/articles/IsNumeric/71512/
Heh... I just knew that article would come in handy. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:56 pm

#1411167
RE: How to store lots of data (1024 columns) for a particular reading

loki1049 (11/21/2011)
Ah yes, ok I can work with this. Thanks for the example. I will be getting back at this tomorrow.
EDIT:
Jeff Moden (11/21/2011)
Heh... almost forgot. Now you really know...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:45 pm

#1411166
RE: How to store lots of data (1024 columns) for a particular reading

You bet. I know you said you only needed to provide the data and not do any analysis but, if you ever do, post back because I've already got...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:41 pm

#1411165
RE: How to store lots of data (1024 columns) for a particular reading

Heh... almost forgot. Now you really know why the term "binary" here is a huge misnomer... the data returned in SQL Server is stored in a binary format (as...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:34 pm

#1411162
RE: How to store lots of data (1024 columns) for a particular reading

Using your single row array example of Array { 10,200,3000,40000 }, the data in a "concatenated binary" in SQL Server would look like the following in SQL Server (assuming 4...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:28 pm

#1411160
RE: How to store lots of data (1024 columns) for a particular reading

Just to clarify... you said the range would be from 0 to 50000 counts (I think I know what that means but you might want to clarify). So would...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 7:18 pm

#1411153
RE: How to store lots of data (1024 columns) for a particular reading

loki1049 (11/21/2011)
Jeff Moden (11/18/2011)
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 6:52 pm

#1411144
RE: How to store lots of data (1024 columns) for a particular reading

loki1049 (11/21/2011)
Thanks for the very informative post. Sorry I have not participated but I was away for the weekend. As Jeff pointed out, yes the spectral data is 1024 randomized...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 6:43 pm

#1411140
RE: How to store lots of data (1024 columns) for a particular reading

Dev (11/21/2011)
Thanks opc.three & Jeff for your thoughts.
I would like to clarify few things on my end.
•By saying that “Space is Cheap” I never meant that we can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 6:35 pm

#1411136
RE: How to store lots of data (1024 columns) for a particular reading

opc.three (11/20/2011)
That said, I am not convinced that a small group of "readings tables" that make up 1024 readings columns would be so bad here (group of tables necessary given...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 6:09 pm

#1411130
RE: how to group and rank (with reset)

I guess my simple request for a bit more information is being ignored. 😉
I'm not asking what I asked to make anyone jump through any type of hoop. I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 5:58 pm

#1411128
RE: Are the posted questions getting worse?

Ninja's_RGR'us (11/21/2011)
Jack Corbett (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Jack Corbett (11/21/2011)
Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I blogged about...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 5:34 pm

#1411123
RE: Are the posted questions getting worse?

Jack Corbett (11/21/2011)
Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I blogged about it, http://t.co/hCjjRnRh if you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 5:28 pm

#1411122
RE: Data Rollup

Actually, there is. I believe that a recursive CTE, much like one that resolves hierarchical paths, might work here. I'm on my way to work and won't be...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 21, 2011 at 5:16 am

#1410613

Viewing 15 posts - 31,906 through 31,920 (of 59,099 total)