Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,491 through 23,505 (of 59,099 total)

RE: Extracting data with headers using PowerShell

andycadley (6/3/2014)
Useful, but I'd avoid using the args[] variable and do it "the Powershell way" with a Param block at the start of the script, that way you get things...
--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)

June 3, 2014 at 7:26 am

#1718528
RE: how to remove next and previous record is amount = 0?

Eirikur Eiriksson (6/3/2014)
Jeff Moden (6/2/2014)
Unless this was an accidental duplication of data, there's no way that I'd do this. You're destroying historical data.
Second that but then again that's pondering...
--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)

June 3, 2014 at 7:12 am

#1718519
RE: Finding stored procedure defaults for parameters

@tshad,
Interesting... this is the second time in a week that someone has asked this very rare question. I'm just curious... is this a school assignment or are you working...
--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)

June 3, 2014 at 6:58 am

#1718510
RE: export Dynamiclly table to few tables

It's not the export that's slow. It's the select. Please post it and the DDL (CREATE TABLE) for the two tables along with the CREATEs for the indexes...
--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)

June 3, 2014 at 6:54 am

#1718509
RE: Range Group Summary of particular column

Eirikur Eiriksson (6/3/2014)
tlrsekar 23727 (6/3/2014)
As of now order is not my concern, it can be of any order
You could use modulus/remainder of the number
Eirikur... it's a self-reseting running total. ...
--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)

June 3, 2014 at 6:33 am

#1718497
RE: Add month to a Date

Just do the DATEADD to the Transaction date without all the individual Year, Month, and Day stuff. If the final result needs a particular format and can't be done...
--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)

June 3, 2014 at 1:17 am

#1718428
RE: SQL query where value is less than negative number not giving expected results

Tania Mofflin (6/3/2014)
This comes back with the following error -
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.
Seems to be an issue with how...
--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)

June 3, 2014 at 1:11 am

#1718427
RE: SSIS - handling errors within a for-each loop container

My question would be, why does this require a RBAR process? What is it that you're doing to "each row" that requires single row processing?
--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)

June 3, 2014 at 1:07 am

#1718424
RE: After installing SQL server what thing we have to check

To be honest, there are a whole lot of facets to consider for SQL Server AND Windows security. If you don't actually know what they are or your Yabigooglehoo...
--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)

June 3, 2014 at 1:05 am

#1718423
RE: t-sql 2008 exlain select

On the subject of "overkill"... I won't dumb down code just because someone might not understand it. When I was a contractor, I considered it to be very important...
--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)

June 3, 2014 at 12:53 am

#1718418
RE: t-sql 2008 exlain select

ChrisM@Work (6/2/2014)
ScottPletcher (5/30/2014)
I think the overhead of XML is unwarranted here...
Yes you're right, with a fixed number of rows, FOR XML PATH is probably overkill.
I agree that explicit solutions like...
--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)

June 3, 2014 at 12:51 am

#1718417
RE: t-sql 2008 exlain select

ChrisM@Work (6/2/2014)
Jeff Moden (5/30/2014)
Heh... not to worry. I started out by testing the other solutions and then went back to the original solution. I kept looking at it...
--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)

June 3, 2014 at 12:44 am

#1718414
RE: Huge TempDb file on a Development server

My suggestion would be to find out what actually made it grow so quickly. If someone did something in coded that's getting ready to go to prod, you could...
--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)

June 3, 2014 at 12:25 am

#1718411
RE: t-sql 2008 exlain select

sgmunson (5/30/2014)
Jeff Moden (5/30/2014)
Heh... not to worry. I started out by testing the other solutions and then went back to the original solution. I kept looking at it...
--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)

June 3, 2014 at 12:21 am

#1718410
RE: SQL query where value is less than negative number not giving expected results

Try it without the quotes around the numeric constants.
--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)

June 3, 2014 at 12:14 am

#1718409

Viewing 15 posts - 23,491 through 23,505 (of 59,099 total)