Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,781 through 42,795 (of 59,067 total)

RE: Create CSV file using sp_send_dbmail with field delimiters

Cool... thanks for the feedback, Steve.
--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)

July 23, 2009 at 1:05 pm

#1029225
RE: Query to rebuild/reorganize all indexes in the database?

John Mitchell (7/23/2009)
Jeff Moden (7/21/2009)
Heh... don't over look what's in Books Online. If you lookup "DBCC SHOWCONTIG" and scroll down, you'll find a section with the following label...
[font="Arial Black"]E....
--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)

July 23, 2009 at 1:05 pm

#1029224
RE: DBA's and Developers

Steve Jones - Editor (7/23/2009)
One small addition. I'd make sure they all use their Windows account, not SA, to make changes. It will help them to be respectful towards each...
--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)

July 23, 2009 at 12:59 pm

#1029221
RE: sql query

smunson (7/23/2009)
There's a logic problem here...
...but clearly, that 3rd entry is within 60 minutes of the 2nd entry
Heh... Glad I'm not the only one... That's exactly the point I was...
--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)

July 23, 2009 at 12:51 pm

#1029214
RE: Passing Stored Procedures "values" for IN

head_contusion (7/23/2009)
I am really tired because my 1 yr. old woke me really early this morning.
I'm looking through the suggested solutions to this problem, and I'm not understanding them....
--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)

July 23, 2009 at 12:45 pm

#1029203
RE: differiniate quotes as data vs quotes as column identifier

Ghanta (7/23/2009)
Hey Jeff,
Thanks a lot for your response. I tried that and I got this error:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
I am running this on:
Microsoft SQL Server...
--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)

July 23, 2009 at 12:33 pm

#1029191
RE: How do I change the structure of a table with data in it?

FredS (7/23/2009)
I just tried to change a table. I selected a column that was char(35) and changed it to char(36), and pressed Save.
"Saving changes is not permitted. 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)

July 23, 2009 at 5:49 am

#1028871
RE: Are the posted questions getting worse?

jcrawf02 (7/22/2009)
Someone at work put this in their sig, which instantly made me want to "accidentally" spill hot coffee on them . . . thought the gang would enjoy
"He 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)

July 22, 2009 at 11:42 pm

#1028768
RE: Are the posted questions getting worse?

. (7/22/2009)
If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about 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)

July 22, 2009 at 11:34 pm

#1028767
RE: Problem with Query

. (7/22/2009)
Matt and Lynn,
I'll go ahead and send you my solution, so you can double-check me. I did it with CTEs and freely admit there is probably...
--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)

July 22, 2009 at 11:28 pm

#1028766
RE: differiniate quotes as data vs quotes as column identifier

Actually, there is an "automatic" method. It involves the use of a "text based" linked server. If you lookup "sp_AddLinkedServer" in BOL and then find the example with...
--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)

July 22, 2009 at 11:04 pm

#1028764
RE: Create CSV file using sp_send_dbmail with field delimiters

Ah.... very cool. Thanks for posting the test data. 🙂
I believe your problem is that you've simply included too many single quotes in QUOTENAME for the task at hand....
--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)

July 22, 2009 at 10:55 pm

#1028762
RE: Need some Cursor help...well I think it's a cursor I need

John Rowan (7/22/2009)
Yep, I didn't catch that part. Jeff's solution will give you the top 10 for each ID.
As a side note, any time my answers differ from Jeff's...
--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)

July 22, 2009 at 10:45 pm

#1028761
RE: sql query

One final question... would this be 2 or 3 occurances? If 2, why and which 2 would they be?
Emp_ID Start_Entry End_Entry...
--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)

July 22, 2009 at 10:38 pm

#1028760
RE: Index Fragmentation...

Why not just use DBCC SHOWCONTIG and save it in a table?
Also, most folks might be able to live with 30% fragmentation, but I can't... the tables I work with...
--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)

July 22, 2009 at 10:31 pm

#1028758

Viewing 15 posts - 42,781 through 42,795 (of 59,067 total)