Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,811 through 15,825 (of 59,063 total)

RE: use excel to update backend SQL Table

Excellent! I'll finish putting it together this weekend and get it out to you. Thanks, Phil.
--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)

January 19, 2017 at 9:15 pm

#1923920
RE: Warnings and SP_recompile messages from SP execution - How to not log those messages

I agree with Grant. Suppressing these messages isn't the way to go. Fixing the code that causes them is. There's almost never a need to mark stored procs for recompile...
--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)

January 19, 2017 at 5:53 pm

#1923914
RE: use excel to update backend SQL Table

Phil Parkin - Thursday, January 19, 2017 12:31 PM
Jeff Moden - Thursday, January 19, 2017 12:12 PM
--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)

January 19, 2017 at 2:35 pm

#1923876
RE: parsing records with empty spaces

ebooklub - Thursday, January 19, 2017 10:18 AM
John Mitchell-245523 - Thursday, January 19, 2017 9:10 AM
--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)

January 19, 2017 at 12:17 pm

#1923824
RE: use excel to update backend SQL Table

Phil Parkin - Thursday, January 19, 2017 10:55 AM
Jeff Moden - Thursday, January 19, 2017 10:46 AM
--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)

January 19, 2017 at 12:12 pm

#1923822
RE: use excel to update backend SQL Table

You don't need SSIS. The ACE drivers work just fine. I install them as a matter of rote on every system.
--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)

January 19, 2017 at 10:46 am

#1923793
RE: trace is not capturing DeadLock

thbaig - Tuesday, August 23, 2016 10:24 AM
HI,I found deadlock on one of my db server. at first I tried to capture...
--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)

January 19, 2017 at 10:44 am

#1923792
RE: parsing records with empty spaces

John Mitchell-245523 - Thursday, January 19, 2017 9:10 AM
Jeff Moden - Thursday, January 19, 2017 9:06 AM
--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)

January 19, 2017 at 10:08 am

#1923780
RE: parsing records with empty spaces

John Mitchell-245523 - Thursday, January 19, 2017 9:01 AM
Goodness, yes, you can't process that with BULK INSERT. The ideal solution 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)

January 19, 2017 at 9:06 am

#1923750
RE: parsing records with empty spaces

No problem. Let's clarify what you have for a file, though. I've indicated spaces in the following with filled circles just to make them painfully apparent.
Is this what...
--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)

January 19, 2017 at 9:03 am

#1923749
RE: A Possible Alternative to SQL UNPIVOT

Excellent. Thank you. Now for some testing! 😉
--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)

January 19, 2017 at 8:20 am

#1923719
RE: The (Former) Complexity of PowerShell

chrisn-585491 - Thursday, January 19, 2017 7:07 AM
They say that PowerShell will legitimize the use of the CLI on Windows.
All us illegitimate children...
--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)

January 19, 2017 at 8:16 am

#1923717
RE: Retrieve Dates (and other data) From Different Rows

I recommend you post your data according to the methods depicted at the first link in my signature line below under "Helpful Links". People will produce a coded response for...
--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)

January 19, 2017 at 6:06 am

#1923679
RE: The (Former) Complexity of PowerShell

And then there's things like the following post...
https://www.sqlservercentral.com/Forums/1851783/parsing-records-with-empty-spaces
Why is the user insisting on doing such a thing with PowerShell?
1. Whomever created the data doesn't...
--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)

January 19, 2017 at 6:02 am

#1923678
RE: The (Former) Complexity of PowerShell

What would really be nice is if MS would build in such great functionality into T-SQL and SQL Server itself. I suspect that the ISO and portability zealots would take...
--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)

January 19, 2017 at 5:53 am

#1923674

Viewing 15 posts - 15,811 through 15,825 (of 59,063 total)