Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,991 through 19,005 (of 59,098 total)

RE: Multiple Executions of a Scalar Function in a single call of stored procedure

SQL!$@w$0ME (12/12/2015)
thanks Jeff. We happened to see this issue after sql server was migrated from 2008 to 2014 version.
Unfortunately, that doesn't change my recommendation.
Do you have any idea if this...
--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)

December 13, 2015 at 8:10 pm

#1845710
RE: Convert Rows into Columns

pcanino70 (12/13/2015)
Well done! Like the results. The one thing I like about the pivot is for me it allows easy expansion if you need to fatten this out more.
Thanks...
--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)

December 13, 2015 at 7:25 pm

#1845706
RE: L Server in T-SQL

Ed Wagner (12/13/2015)
Jeff Moden (12/12/2015)
Welsh Corgi (12/11/2015)
heymiky (12/11/2015)
This may help you out:
https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/
Thank you.
That is helpful.
[font="Arial Black"]I was looking to generate a restore script via SSMS.
[/font]
I need to change the name...
--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)

December 13, 2015 at 7:17 pm

#1845705
RE: Multiple Executions of a Scalar Function in a single call of stored procedure

SQL!$@w$0ME (12/12/2015)
thanks Jeff. We happened to see this issue after sql server was migrated from 2008 to 2014 version.
Did you rebuild indexes and stats after the migration?
--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)

December 12, 2015 at 8:24 pm

#1845656
RE: Move File Cmds

p.s. I recommend that you use ROBOCOPY (comes with DOS/Windows) instead. It has auto restart if a file fails part way through, logging, and a whole bunch 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)

December 12, 2015 at 7:56 pm

#1845655
RE: Move File Cmds

Meatloaf (12/11/2015)
Hello,
Ina Stored Procedure I am using the move command to transport files. Is there a way to check if the file already exists and if it does...
--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)

December 12, 2015 at 7:54 pm

#1845654
RE: L Server in T-SQL

Welsh Corgi (12/11/2015)
heymiky (12/11/2015)
This may help you out:
https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/
Thank you.
That is helpful.
[font="Arial Black"]I was looking to generate a restore script via SSMS.
[/font]
I need to change the name of the Database 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)

December 12, 2015 at 7:33 pm

#1845652
RE: Monthly Trend Calculation

You don't have a "When Removed" column?
--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)

December 12, 2015 at 6:55 pm

#1845650
RE: How to catch actual parameter value passed into a stored procedure?

SQL Guy 1 (12/11/2015)
By some reason RPC:Completed does not work for me, probably I am doing something wrong.
I need to filter the trace. Without it, my trace will...
--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)

December 12, 2015 at 6:52 pm

#1845649
RE: How to select 200k data faster in sql

jaquino012 (12/10/2015)
Hi experts,
I hope someone help me on how can i make my SQL script faster.
Here is a background on my SQL:
i have a create a offline dictionary for my...
--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)

December 12, 2015 at 6:40 pm

#1845648
RE: How to select 200k data faster in sql

ScottPletcher (12/10/2015)
Do you have a unique index on Word? You don't want SQL to have to sort the words every time -- that will be extremely slow. Also,...
--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)

December 12, 2015 at 6:31 pm

#1845647
RE: T-SQL split string and Pivot

@aaron.reese,
You have these 4 fields that contain hierarchical pipe delimited data and you've realized that's not the best structure for querying (it's called a "Hierarchical Path" or "Sort Path").
The question...
--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)

December 12, 2015 at 6:23 pm

#1845646
RE: T-SQL split string and Pivot

Luis Cazares (12/11/2015)
Other than using a different function, the final code is basically the same. The only problem is that you're not using the fastest function available (even in 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)

December 12, 2015 at 6:14 pm

#1845645
RE: Rebuild Inxexes after archive best option?

Welsh Corgi (12/11/2015)
Is rebuilding Indexes the best alternative after archiving a lot of data or is there a better alternative?
If the archiving is being done based on a date column,...
--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)

December 12, 2015 at 5:44 pm

#1845644
RE: Combining four while looping into one

koti.raavi (12/12/2015)
I want to combine four while loops into,any help greatly appreciated
drop table #cad
/*GETTING THE REQUIRED MONTHS FOR PERFORMING THE FURTHER CALCULATIONS*/
SELECT [FINALEID],ResourceHome,[ROLLOFFDATE] ,PROJECT,CLIENT,ENGAGEMENT,WBSE
INTO #CAD
FROM CRD
ORDER...
--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)

December 12, 2015 at 5:29 pm

#1845642

Viewing 15 posts - 18,991 through 19,005 (of 59,098 total)