Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,536 through 23,550 (of 59,102 total)

RE: How to add column in specific position

Almost forgot. BULK INSERT has all the same capabilities for importing that BCP has. In the early days, it didn't allow for the sequestration of errors in error...
--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 29, 2014 at 1:00 pm

#1717530
RE: How to add column in specific position

You bet and thank you for the feedback, Joe. Us "old dogs" gotta stick together. 😛
--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 29, 2014 at 12:50 pm

#1717522
RE: How to add column in specific position

DataJoe (5/29/2014)
Ok teach "the old dog" a new trick.
I know of format files yes however, I have now learned that using a format file ignores my truncation error which in...
--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 29, 2014 at 12:27 pm

#1717509
RE: T-Sql Query

ramana3327 (5/29/2014)
Actually I tried with Outer Apply but it increased the execution time. Actually that SP is not taking that much time from SSMS but from the application it 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 29, 2014 at 11:22 am

#1717460
RE: T-Sql Query

I've been watching your posts for several days now. You good folks have the right idea to try to optimize all of the queris you've posted but I think...
--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 29, 2014 at 10:40 am

#1717440
RE: DB2 DBA

Thanks, Sam. I very much appreciate the offer of 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)

May 29, 2014 at 10:10 am

#1717427
RE: Can't access linked server when connecting via alias

bvarnell 55573 (5/28/2014)
Ok, the issue has cropped up again so I have more info.
For ease of telling the story, "ServerA" is when I connect to the server by name 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)

May 28, 2014 at 7:40 pm

#1717213
RE: Index Reorg Vs. Index Rebuild Online

@scott,
How big is the table?
--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 28, 2014 at 7:33 pm

#1717210
RE: compare data in a single table by month period

Please, tell me that all of those tables that have SSN in them at least have the SSN properly encrypted. If not, please tell me the name of 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)

May 28, 2014 at 7:28 pm

#1717209
RE: Pk & Index

ramana3327 (5/28/2014)
Hi,
I do have a table with 15000 records. I am not sure it is transaction table or static table.
Table1(ID int not null, Code1 nvarchar(10) not null,Code2 nvarchar(10) not null,Code3...
--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 28, 2014 at 7:23 pm

#1717208
RE: Sum a Column by Client and Group by date 4 weeks apart!

Tallboy (5/28/2014)
I hope that all makes sense, if not let me know.
And now for the killer question... what do you want to do for a year that has 53 Week...
--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 28, 2014 at 6:47 pm

#1717207
RE: COALESCE to replace multiple CASE statements

nimalatissa (5/27/2014)
I'm very confused. These tables are normalized to 3rd normal form. There shouldn't be anything to do with that. the column in this table have comma separated values...
--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 28, 2014 at 6:37 pm

#1717206
RE: too many arguments - but they match

Thanks, Dana. I appreciate both the info and the thought.
And, yeah... it's amazing what you need to know to get a front-end up and running correctly.
--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 28, 2014 at 6:28 pm

#1717203
RE: Regarding moving files to location

Or, skip SSIS and use a call to RoboCopy.
--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 28, 2014 at 6:26 pm

#1717202
RE: 2014 - Are you using it and are there any reported issues?

SQLRNNR (5/28/2014)
SQLKnowItAll (5/28/2014)
Thanks for the thoughts. The list of connect items is really where I was focused, but I was curious of anything else that people have seen. We'll continue...
--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 28, 2014 at 6:23 pm

#1717201

Viewing 15 posts - 23,536 through 23,550 (of 59,102 total)