Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,191 through 32,205 (of 59,099 total)

RE: total inside cte

First, thank you for providing the data in a readily consumable format. It helps a lot. 🙂
Here's your original data reformatted and put into a Temp Table just because...
--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 23, 2011 at 8:37 pm

#1398491
RE: Problems importing CSV files using SSIS.

John Kotuby (4/13/2011)
So much for the rant.
I'd post a rant of my own but you did a pretty good job of it. 😛
I'm trying to find it but there used...
--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 23, 2011 at 6:27 pm

#1398487
RE: Converting rows to columns

If you truly mean to convert row to "columns" as you say...
http://www.sqlservercentral.com/articles/t-sql/63681/
If you actually meant convert the rows to a single, comma delimited column as you've shown...
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Last but not least,...
--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 23, 2011 at 5:32 pm

#1398484
RE: LTRIM,RTRIM

vince_sql (10/23/2011)
daveriya (10/21/2011)
hi
i have this code in where clause RTRIM(LTRIM(ODER_ID))= ' ',WHAT THis do
It's just removing extra blank spaces, but this is un-necessary as SQL views empty strings as empty...
--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 23, 2011 at 9:43 am

#1398462
RE: OpenQuery Performance help needed urgently

It's probably not just the fact that you're looking at Oracle through a Linked Server... I see lots and lots of joins there. This might be a prime candidate...
--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 23, 2011 at 9:30 am

#1398459
RE: bcp Challenge

The same way that you'd do it for any other well formed file except, IIRC, UNIX uses only the "NewLine" character ( \ N) instead of the "Carriage Return/Line Feed"...
--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 23, 2011 at 9:24 am

#1398457
RE: Cast / Temp field conversion from nvarchar to int failing - any ideas ?

Cool! Two way street here, though... please tell us what you did to fix it?
Also, where did all that Regex stuff come from? It wasn't in your original...
--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 23, 2011 at 9:09 am

#1398454
RE: SARGABLE way for this search

Considering that the OP is trying to find those things that only have numeric digits, it sounds a whole lot worse than that. It sounds like there may 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)

October 23, 2011 at 9:01 am

#1398453
RE: SARGABLE way for this search

In the presence of the correct index, the following over comes the problem with trying to use ISNUMERIC as an IsAllDigits function (which you shouldn't do), checks for the proper...
--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 22, 2011 at 3:24 pm

#1398403
RE: Are the posted questions getting worse?

"Extended Events"... is that like planning on Friday to actually return to work on Monday? 😛 Or is it an event that lasts more than one day like PASS...
--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 22, 2011 at 2:54 pm

#1398400
RE: CreateTempTable function?

sqlguy-736318 (10/22/2011)
AccidentalDBA:) (10/22/2011)
Depending on what you are doing i like to user variable temp tables, there is no need to drop them at the end because once the script 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 22, 2011 at 2:50 pm

#1398399
RE: SSIS performance improvements

isuckatsql (10/21/2011)
I did a standard, full install of SQL Server 2008 R2 Enterprise on a new server, and am running an SSIS project that [font="Arial Black"]reads a large text field...
--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 22, 2011 at 11:07 am

#1398348
RE: performance of the query and index

GilaMonster (10/22/2011)
If you're talking about the myth that SELECT ... INTO locks the entire of TempDB, there used to be a problem with locked system tables (not the entire DB),...
--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 22, 2011 at 10:55 am

#1398347
RE: Cast / Temp field conversion from nvarchar to int failing - any ideas ?

Yes... it simply means that you're selecting data for conversion that cannot be converted. Put another way, you're selecting data for conversion that doesn't look like an INT value....
--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 22, 2011 at 10:28 am

#1398339
RE: How to reduce maintenance window impact of very large table

As Elliot suggested, one of the best things you could do to ease the maintenance load is to divide the table up a bit. HOW you do such a...
--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 22, 2011 at 10:21 am

#1398335

Viewing 15 posts - 32,191 through 32,205 (of 59,099 total)