Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,816 through 40,830 (of 59,070 total)

RE: The Sixty-Second Guide to becoming a SQL Server DBA

RBarryYoung (12/4/2009)
Julien.Chappel (12/3/2009)
...I would not trust the SQL Server Compact addition to be administered...
And frankly, this makes no sense at all, who said any thing about Compact Edition and what...
--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)

December 4, 2009 at 12:29 am

#1087509
RE: The Sixty-Second Guide to becoming a SQL Server DBA

Yowch! Tough crowd! 😉
I agree... I don't see anything in the title or the text that suggests you can become a DBA in 60 seconds (although it did catch...
--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)

December 4, 2009 at 12:21 am

#1087505
RE: Converting varchar to int

I've been thinking about this and the performance. For the data at hand and if the table cannot be normalized, then Nigel's "like" method is probably the best.
Normalizing the...
--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)

December 3, 2009 at 10:53 pm

#1087495
RE: Help with BCP format error

bernardash (12/3/2009)
I was forced to use a format file b/c I need to skip one of the table columns. Here is the format file :
...
The table now has 18...
--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)

December 3, 2009 at 10:23 pm

#1087492
RE: Crosstab query - Please help. it has been a few days without sleep

RandMan-585256 (12/3/2009)
Since this is Access VBA why don't you use the cross-tab query type in Access?
Hmmm.... not a bad idea. Do you believe that it would work on a...
--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)

December 3, 2009 at 9:55 pm

#1087484
RE: Crosstab query - Please help. it has been a few days without sleep

Test-170228 (12/2/2009)
Man, you get this right, and I am going to send you a cheque for some pizza money for sure or steak 😉
Heh... PM me... I'll send you the...
--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)

December 3, 2009 at 9:37 pm

#1087482
RE: Crosstab query - Please help. it has been a few days without sleep

Ok... barring any major oversights or simple typo's, I think this will do it. It should be an exact replacement in that if you folks add another "Fact" to...
--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)

December 3, 2009 at 9:34 pm

#1087481
RE: Crosstab query - Please help. it has been a few days without sleep

Heh... I could build some test data but then you'd have to add a bottle of Scotch to the steak order. :w00t:
--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)

December 3, 2009 at 9:30 pm

#1087480
RE: Crosstab query - Please help. it has been a few days without sleep

Test-170228 (12/3/2009)
Hey Jeff,
How goes the battle? I am trying to figure things out on my end and I feel my efforts have been in vain. I hope yours are not.
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)

December 3, 2009 at 9:29 pm

#1087479
RE: Crosstab query - Please help. it has been a few days without sleep

TheSQLGuru (12/3/2009)
Jeff Moden (12/3/2009)
Heh... nope... I want the steaks. 😛
Thought Pork Chops were your thing?? :hehe:
Heh... that's what I feed other people. :hehe:
--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)

December 3, 2009 at 9:28 pm

#1087478
RE: Crosstab query - Please help. it has been a few days without sleep

Heh... nope... I want the steaks. 😛
--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)

December 3, 2009 at 8:03 pm

#1087459
RE: datediff on dates contained in single column

GSquared (12/3/2009)
He wants a negative number.
Heh... -42. 😀
--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)

December 3, 2009 at 7:48 pm

#1087456
RE: Fixed length output from numeric column

Ah... got it. Thanks. It does seem strange to waste an INT or even a SMALLINT to hold numbers like 10000 when a TINYINT to hold the "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)

December 3, 2009 at 7:08 pm

#1087454
RE: Crosstab query - Please help. it has been a few days without sleep

Test-170228 (12/3/2009)
Hi Jeff,
This is what I have when I check for the version value on my server
"Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52...
--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)

December 3, 2009 at 6:51 pm

#1087453
RE: Crosstab query - Please help. it has been a few days without sleep

TheSQLGuru (12/3/2009)
Jeff, you silly person! My big smiley indicated that my pushing R2 was a JOKE. 🙂 I think it is in CTP3 stage or so ......
--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)

December 3, 2009 at 6:49 pm

#1087452

Viewing 15 posts - 40,816 through 40,830 (of 59,070 total)