Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,871 through 21,885 (of 59,072 total)

RE: SQL Query

Nita Reddy (1/15/2015)
Let me give with Example:
I have table called Tracking_changes which contain 4 columns a
I want to get the output ONLY with differences in other column 2 and 3...
--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)

January 15, 2015 at 8:46 pm

#1770625
RE: How to get current date between?

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)

January 14, 2015 at 5:45 pm

#1770310
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Back on topic for a moment.
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not...
--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)

January 14, 2015 at 5:33 pm

#1770308
RE: Help With Trying to Import File Names into a Table

Polymorphist (1/14/2015)
What's interesting to me is that most senior DB folks we interview refuse to use SSIS or have very little experience with it.
They're not alone. I'm one 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)

January 14, 2015 at 4:00 pm

#1770291
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/13/2015)
Jeff Moden (1/13/2015)
Heh... nope. Considering how easy it is for me to do things like this in T-SQL without SSIS, SSIS will always be in the "suffering"...
--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)

January 14, 2015 at 3:43 pm

#1770285
RE: How to get current date between?

JoshDBGuy (1/14/2015)
krypto69 (1/14/2015)
Hi,
I have a query that will go into an ssis package (eventually). The package will run every night at 3am. I need to capture the last 24 hours...
--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)

January 14, 2015 at 3:39 pm

#1770282
RE: Are the posted questions getting worse?

Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!
Thanks everyone for voting!
Outstanding! Well done, Koen!!!
--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)

January 14, 2015 at 3:22 pm

#1770275
RE: Dropping and adding the Unique Nonclustered Index

ramana3327 (1/14/2015)
Hi,
I have a index on a column. That index is unique nonclustered index.
After recreate that I want the same name as previous
When I use the script index 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)

January 14, 2015 at 2:57 pm

#1770267
RE: Replacing Table Names In Over 100 Procs

JoshDBGuy (1/14/2015)
I've been tasked with migrating half of a database to a new instance. Unfortunately for me, there are over 100 stored procedures that need to be modified. Also unfortunately...
--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)

January 14, 2015 at 2:49 pm

#1770261
RE: use Change Data Capture for incremental load

Some extra information to what Koen posted...
MD5 is horribly slow. Don't use it.
CHECKSUM is a simple Exclusive OR of bytes and collisions are much more common than many would...
--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)

January 14, 2015 at 2:42 pm

#1770258
RE: Splitting a non-uniform concatenated address column into 2 different columns

You could spend an awful lot of money trying to develop this and still make some terrible mistakes that you might not ever find.
My recommendation is to simply buy some...
--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)

January 13, 2015 at 5:10 pm

#1769979
RE: Best approach to download variably named CSV file from FTP and insert into existing table?

Herpington_McDerpington (1/8/2015)
I'm just now realizing what you said, Jeff - that I simply can't use a variable name with BULK INSERT - in T-SQL or SSIS (since it's simply executing...
--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)

January 13, 2015 at 9:41 am

#1769865
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/13/2015)
Polymorphist (1/9/2015)
i'm connecting it to a Flat File Source, then Derived Column task, then OLE DB Destination. This doesn't seem right to me, but i'm not...
--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)

January 13, 2015 at 9:01 am

#1769852
RE: No elevated right yet need to create a database.

Charles Deaton (1/12/2015)
Our development department is working on an internal application that will need to create and delete databases as well as logins/user and contained users. It will also need...
--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)

January 13, 2015 at 8:45 am

#1769844
RE: Testing

skeleton567 (1/13/2015)
[font="Arial Black"]Good [/font]developers will not depend on someone else finding their bugs.
+1000. Amen to 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)

January 13, 2015 at 8:06 am

#1769828

Viewing 15 posts - 21,871 through 21,885 (of 59,072 total)