Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,196 through 36,210 (of 59,067 total)

RE: Ordering by month, show name

Heh.., and I'm not the only one... I believe that Wayne S may have beat me in submitting the first article in this series.
--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)

October 28, 2010 at 10:06 am

#1243677
RE: Ordering by month, show name

David Burrows (10/28/2010)
Grant Fritchey (10/28/2010)
Jeff Moden (10/28/2010)
Task complete. Submitted article via "Write For Us".
Over-achiever.
Meh! Jeff probably hasn't heard the saying 'Nobody likes a smart a$$' 😛
BWAA-HAAA!!!! Smart 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)

October 28, 2010 at 9:58 am

#1243669
RE: BCP in

jez.lisle (10/28/2010)
I have been googling Bulk Inserts and found this below... I have tried and it seems to work very well at the moment.
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
Thanks for all the help...
--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)

October 28, 2010 at 9:56 am

#1243667
RE: Are the posted questions getting worse?

Tom.Thomson (10/28/2010)
Jeff Moden (10/27/2010)
If you wanted a small jingle... (sung to the tune of "Row, Row, Row Your Boat")
You shouldn't mention that in an SQL forum: "Row" is unspeakable,...
--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)

October 28, 2010 at 9:53 am

#1243661
RE: Are the posted questions getting worse?

Grant Fritchey (10/28/2010)
Jeff Moden (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Grant Fritchey (10/27/2010)
Look for the tall bald guy in a red vest.
Or the hairy legs under a short ~~skirt~~ kilt
GAH!!!!...
--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)

October 28, 2010 at 9:52 am

#1243658
RE: Are the posted questions getting worse?

jcrawf02 (10/28/2010)
Jeff Moden (10/27/2010)
Great idea. As a side bar... you may not be able to tell the last time a table was accessed but... you should be able 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)

October 28, 2010 at 9:50 am

#1243656
RE: Are the posted questions getting worse?

bitbucket-25253 (10/28/2010)
Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll...
--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)

October 28, 2010 at 9:48 am

#1243652
RE: Get the Current Date

Just in case anyone asks... when given the choice, I use what works. I have virtually no regard for ANSI code because I don't believe in the myth of...
--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)

October 28, 2010 at 9:46 am

#1243651
RE: Get the Current Date

Derrick... I have to ask... did you ever work at Grainger? I ask because worked with a Derrick Smith from Grainger Corporate Headquarters.
--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)

October 28, 2010 at 9:43 am

#1243649
RE: Is there any way to find who deleted the database

Jack Corbett (9/20/2010)
Here's a query that will find it:
With cteObjectTypes AS
(
SELECT
TSV.trace_event_id,
TSV.subclass_name,
TSV.subclass_value
FROM
sys.trace_subclass_values AS TSV JOIN
sys.trace_columns AS TC ON
TSV.trace_column_id = TC.trace_column_id
WHERE
TC.[name] = 'ObjectType'
),
cteEventSubClasses AS
(
SELECT
TSV.trace_event_id,
TSV.subclass_name,
TSV.subclass_value
FROM
sys.trace_subclass_values AS TSV JOIN
sys.trace_columns AS TC ON
TSV.trace_column_id =...
--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)

October 28, 2010 at 3:07 am

#1243402
RE: got a parameter sniffing example/demo script?

GilaMonster (10/27/2010)
Lowell (10/27/2010)
I'd said previously that my theory is when parameter sniffing occurs, i think the saved execution plan is used to get the data on a row by row...
--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)

October 28, 2010 at 3:00 am

#1243399
RE: Searching on Multiple Tables

InfiniteError (10/28/2010)
Hi,
I know that many sql developer here can give me clarification on this matter.
What I want to know is that,
For example I want to search these strings(ex. 'Asanti','Goodyear','Cadillac'), And...
--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)

October 28, 2010 at 2:54 am

#1243393
RE: Parent/Child relationship

Chrissy321 (10/27/2010)
Thnaks All. I was able to reach a suitable solution using the CASE WHEN EXISTS syntax!
That's cool... can you post your final code, 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)

October 28, 2010 at 2:51 am

#1243392
RE: Parent/Child relationship

CELKO (10/27/2010)
CREATE VIEW MarkedChildren (parent_id, child_id, [font="Arial Black"]silly_flag[/font])
You just can't resist, can ya? 😉
--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)

October 28, 2010 at 2:50 am

#1243391
RE: Ordering by month, show name

Task complete. Submitted article via "Write For Us".
--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)

October 28, 2010 at 12:57 am

#1243361

Viewing 15 posts - 36,196 through 36,210 (of 59,067 total)