Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,761 through 17,775 (of 59,069 total)

RE: BCP produces garbled output

bsadowsky (4/27/2016)
In my case, it had to do with the number of columns with NULL values. More than 4 seemed to cause the issue, not so much the number 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)

April 27, 2016 at 6:39 am

#1874910
RE: hide headers export to csv

pietlinden (4/27/2016)
No wonder I'm so good at SSRS...
"I'll take cryptic UI for 1000!"
😀
--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)

April 27, 2016 at 6:36 am

#1874907
RE: Effective date updation in Fact records

While you're at it, I recommend making the new end-date = '9999' (equals 9999-01-01 when inserted into a DATETIME column) so that you're queries aren't plagued by the use 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)

April 27, 2016 at 5:17 am

#1874895
RE: hide headers export to csv

Heh... "DataElementOutput" property. They couldn't just call it "Headers". Gotta love 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)

April 27, 2016 at 5:12 am

#1874890
RE: DIR /B switch

barsuk (4/27/2016)
you can use DIR PATH /S /OD
I'm pretty sure that will also list files that are currently open.
--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)

April 27, 2016 at 5:00 am

#1874888
RE: String Together Mulitple fields when not NULL

The fact that, unless you've tattooed the server settings, Anything + NULL = NULL makes this fairly easy.
SELECT ID,
STUFF(
...
--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)

April 26, 2016 at 10:07 pm

#1874846
RE: Cloud First

From the Article:
We just want the database platform to work, wherever we run may run it.
If you add the words "quickly and properly" to that (and I'm sure that's...
--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)

April 26, 2016 at 9:56 pm

#1874843
RE: strange problem with varchar(8000) getting cut at 4000 characters

Jeffery Williams (4/26/2016)
I print the variable PRINT cast(@ThisVariable as varchar(8000)) and it prints fine on screen. I update a table column value with it and it is shortened.
How are you...
--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)

April 26, 2016 at 9:42 pm

#1874841
RE: BCP produces garbled output

Thanks for bringing this back up. I've always meant to ask what the OP meant by "garbled" and how many characters the limit seemed to be and what was...
--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)

April 26, 2016 at 8:06 pm

#1874833
RE: Processing strings.

patrickmcginnis59 10839 (4/26/2016)
Jeff Moden (4/26/2016)
Solomon Rutzky (4/25/2016)
Disagree with what, exactly? You started this whole sub-topic of "Tower of Babel" because you mistakenly thought that Sachin was introducing both VB and...
--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)

April 26, 2016 at 5:59 pm

#1874831
RE: Does T-SQL have a means of iterating over the columns of a table?

Rod at work (4/26/2016)
We've got an unusual request, and I think my managers are approaching this from a programming POV rather than a database POV. Here's how it was proposed...
--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)

April 26, 2016 at 5:50 pm

#1874830
RE: Verify SQL Backups With SQL Powershell

YOUKHANIS.JAMES (4/26/2016)
What TSQL statement populates this table?
SELECT [MachineName]
,[AssociatedApp]
,[App_ID]
,[SQLConnectionString]
...
--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)

April 26, 2016 at 4:22 pm

#1874819
RE: SQL -> Excel

Steve Jones - SSC Editor (4/26/2016)
Email the article(s), and feel free to focus separate pieces on a smaller part.
The problem isn't with your machine. Probably in the chair in front...
--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)

April 26, 2016 at 4:19 pm

#1874818
RE: Storing encypted SSN's

Eric M Russell (4/26/2016)
A SSN hashed using MD5 can be un-hashed by simply joining it on a dictionary table prepopulated with a billion sequential SSN codes that were hashed using...
--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)

April 26, 2016 at 4:13 pm

#1874817
RE: SQL Server Resource Governor

Thanks for the article, Raul. I especially like what I saw on the PerfMon chart in the "Results" section.
Not much to add because Kevin beat me too 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)

April 26, 2016 at 3:51 pm

#1874812

Viewing 15 posts - 17,761 through 17,775 (of 59,069 total)