Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,961 through 18,975 (of 59,072 total)

RE: Rethinking Hiring

One of the best jobs had one of the absolute best job descriptions I've ever seen. Here's the whole thing as they wrote it.
"What we need is someone 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)

December 14, 2015 at 5:01 pm

#1845956
RE: Single MDF or MDF+NDF

Eric M Russell (12/14/2015)
Parallel I/O aside, it's worth mentioning that files and file groups can be backed up, restored, detached, attached separately, which can potentially decrease downtime for very large...
--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 14, 2015 at 3:31 pm

#1845945
RE: eRepair Access

I have to ask, what the hell does this have to do with DTS. Ohhhh, I feel a spammer coming up.
--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 10:59 pm

#1845722
RE: Are the posted questions getting worse?

Ed Wagner (12/13/2015)
TomThomson (12/12/2015)
Louis Hillebrand (12/12/2015)
ThomasRushton (12/11/2015)
Steve Jones - SSC Editor (12/11/2015)
Take this week's survey. don't look anything up, first thing that comes to mind. Be serious, not silly.
https://www.surveymonkey.com/r/JGFCKDW
#10? ...
--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:22 pm

#1845711
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

Viewing 15 posts - 18,961 through 18,975 (of 59,072 total)