Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,346 through 39,360 (of 59,098 total)

RE: building a date

Lutz,
It's unfortunate, but these are credit card expiration dates and they're (unfortunately) frequently provided as CHAR(2) for the month and year entries. Sometimes, they're provided as CHAR(5) mm/yy. ...
--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)

March 14, 2010 at 10:20 pm

#1133506
RE: find index fragmentation and perform defragment

GTR (3/14/2010)
There is no standard protocol, but Rebuilding index with 1000 or more pages is recommended.
What is the link for this recommendation, please?
--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)

March 14, 2010 at 10:07 pm

#1133498
RE: SQL problem

craig 84462 (3/13/2010)
thanks, any help would be awesome!
Then, avoid the RBAR...
I don't know if this works in 2k8 because I don't have it to test on and I don't 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)

March 14, 2010 at 10:04 pm

#1133495
RE: select random records but for each category

Paul White (3/14/2010)
(though it is a shame that NEWID is illegal in a function):
Old gaming advice... if you can't move forward, backward, left, right, up, down, then change "color". 😉
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)

March 14, 2010 at 9:56 pm

#1133493
RE: Transposing repeating sets of rows into colums

wiernyjacek (3/13/2010)
I have loaded a text file into one colum:
Table: tmpNames
===================
[firstname = "John"]
[surname = "Scott"]
[age = "12"]
[firstname = "Barbara"]
[surname = "White"]
[age = "15"]
..................
[firstname = "Alex"]
[surname = "Ferguson"]
[age = "19"]
Any tips...
--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)

March 14, 2010 at 9:44 pm

#1133488
RE: select random records but for each category

Yeah, but the MODE is flat for C... average shouldn't even come into play on this.
--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)

March 14, 2010 at 9:29 pm

#1133481
RE: Is it possible...

Steve Jones - Editor (3/14/2010)
Put out a general note, we are auditing access, etc. If your login doesn't work, let us know. It's an easy way to find out who...
--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)

March 14, 2010 at 9:27 pm

#1133480
RE: Facing Problem With Bulk Insert

One of the really annoying problems with Bulk Insert (and BCP) is that all of the rows must have the exact same number of delimiters otherwise the line with 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)

March 14, 2010 at 9:21 pm

#1133479
RE: Attribute to identify system databases

Lynn Pettis (3/14/2010)
If Microsoft were to add a tempdb for each database instead of a single global tempdb, wouldn't it make sense to implement it as a separate filegroup that...
--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)

March 14, 2010 at 9:10 pm

#1133478
RE: PIVOT function

Are you using SQL Server 2005 or better? If not, you'll need to use a cross-tab, instead.
--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)

March 14, 2010 at 9:07 pm

#1133477
RE: Question on pivot tables

muratistanbul (3/14/2010)
Hi
thanks for your informations but ALL TIMES I GET
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'PIVOT'.
Message Dou you have any suggestion for me
thanks
Are...
--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)

March 14, 2010 at 9:06 pm

#1133476
RE: Are the posted questions getting worse?

Paul White (3/14/2010)
Jeff Moden (3/14/2010)
Heh.... I want a "First Non-Employee to Break 20K on SSC" polo shirt, a certificate for that, and a nice fresh box of smoked pork chops....
--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)

March 14, 2010 at 9:03 pm

#1133475
RE: Are the posted questions getting worse?

RBarryYoung (3/14/2010)
Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...
--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)

March 14, 2010 at 9:02 pm

#1133474
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/14/2010)
Congrats, Paul and Jason.
Those QODs and posts add up, though be careful of burnout. I've seen this happen before a few times. Do what you enjoy,...
--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)

March 14, 2010 at 1:43 pm

#1133434
RE: Are the posted questions getting worse?

Paul White (3/14/2010)
Where have all the questions gone? Seems very quiet...perhaps too quiet...
Heh... you've answered them all. 😀
--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)

March 14, 2010 at 1:39 pm

#1133433

Viewing 15 posts - 39,346 through 39,360 (of 59,098 total)