Jeff Moden

Forum Replies Created

Viewing 15 posts - 29,911 through 29,925 (of 59,101 total)

RE: How to retain the variable's value in a dynamic sql? Thanks.

You can make your life a bit easier if you can do this using sp_ExecuteSQL. It was built for this kind of stuff.
--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)

May 18, 2012 at 5:34 pm

#1490027
RE: Looking for SQL 2008 DBA training

Elizabeth.Block (5/18/2012)
We have a new member in our team and he needs some DBA training for SQL 2008. Does anyone have any recommendations for courses on the west coast? 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)

May 18, 2012 at 5:31 pm

#1490025
RE: Audit Trail Generator

rjs123431 (5/17/2012)
Hi All,
We use sql server 2005 and 2008. I need to trace INSERTED,DELETED and UPDATED records in some tables in this manner.
- LogID (auto increment)
- TableName
-...
--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)

May 18, 2012 at 5:21 pm

#1490022
RE: Audit Trail Generator

And someone please post one of the XML triggers. One of you 3 folks recommending this should have one right at your fingertips, yes? I'd like to see...
--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)

May 18, 2012 at 5:17 pm

#1490018
RE: rows to columns

CELKO (5/18/2012)
Everything is completely wrong.
No it's not. It's an EAV table and they do happen for some good reasons sometimes. The fact that the PK is missing...
--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)

May 18, 2012 at 4:54 pm

#1490006
RE: QUERY

CELKO (5/18/2012)
There is no such crap as a “type_id”;
You really need to take a course on indexes in the Rushmore engine if you still think that, Joe.
--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)

May 18, 2012 at 4:47 pm

#1490005
RE: Importing Multiple csv files into one SQL Table

Lowell (5/18/2012)
I'll go all devils advocate on the SSIS guys and present a solution i put together for other posts that is all TSQL.
Thsi requires xp_cmdshell to get the list...
--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)

May 18, 2012 at 3:22 pm

#1489978
RE: Importing Multiple csv files into one SQL Table

MysteryJimbo (5/18/2012)
Lowell (5/18/2012)
MysteryJimbo (5/18/2012)
*cringe*
Sorry. I've seen xp_cmdshell and similar methods like that before. Oooo and a cursor. 🙂
the knee-jerk reactions to cursors and xp_cmdshell have their place,...
--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)

May 18, 2012 at 3:19 pm

#1489977
RE: txt import

slunt01 (5/18/2012)
Steve Jones - SSC Editor (5/18/2012)
You can run BCP without a format file and it will help you create one, guessing at the columns.
I dont know what BCP is....
--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)

May 18, 2012 at 10:37 am

#1489825
RE: txt import

If the file is a delimited file and is in good and reasonable shape, neither BCP or Bulk Insert need a format file.
--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)

May 18, 2012 at 9:45 am

#1489787
RE: How to performance tune this Merge statement for our DW ETL process?

mtassin (5/18/2012)
With my larger DW tables (250 Million rows) that seems to give better performance than the merge...
A race would be interesting.
--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)

May 18, 2012 at 9:43 am

#1489785
RE: Importing Multiple csv files into one SQL Table

ByronOne (5/18/2012)
Cheers Jeff
That's really useful to know and makes my life a little easier!
You bet and thanks for the feedback.
--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)

May 18, 2012 at 9:41 am

#1489783
RE: SSIS - File Watcher Task

It depends on what the backlog for Steve is. Typically, it's been taking 3-4 weeks to be accepted, betwee, 4 and 6 weeks to be scheduled, and between 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)

May 18, 2012 at 9:40 am

#1489780
RE: Setting the Identity in a temp table using a variable

Haven't tried it in a very long time but, if memory serves, you can use a dynamic DBCC CHECKIDENT to reseed a temp table. Changing the increment will 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)

May 18, 2012 at 8:04 am

#1489702
RE: How to performance tune this Merge statement for our DW ETL process?

The problem very likely has nothing to do with the number of rows being compared. It's probably the number of rows being updated.
I don't have a definitive test 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)

May 18, 2012 at 7:53 am

#1489698

Viewing 15 posts - 29,911 through 29,925 (of 59,101 total)