Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,901 through 21,915 (of 59,098 total)

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
RE: Differential backup pushing a full backup?

Tony++ (1/13/2015)
To ask the silly and obvious: Are they both either compressed or uncompressed?
Doing full as compressed & diffs as uncompressed could get you that closeness in size.
I think part...
--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:02 am

#1769825
RE: Best way to migrate data from 2005 to 2008R2 env

SQLisAwE5OmE (1/12/2015)
Grant Fritchey (1/12/2015)
If it's a one-time data move, the easiest is going to be to just do a restore. You can drop all the objects on the other side...
--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 1:43 am

#1769724
RE: Inserting FK information into a temp table

Roust_m (1/8/2015)
JeeTee (1/8/2015)
if this is to perform cross database maintenance, powershell might be a better option (one which I'm altogether not familiar with). But what I was saying 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)

January 13, 2015 at 1:40 am

#1769721
RE: Tables design similar to google calendar scheduling

You bet, Vishnu. Thank you 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 13, 2015 at 1:34 am

#1769718

Viewing 15 posts - 21,901 through 21,915 (of 59,098 total)