Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,166 through 18,180 (of 59,069 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Solomon Rutzky (3/12/2016)
TomThomson (3/11/2016)
Jeff Moden (3/11/2016)
..... I think the following produces the correct result...
SELECT LOG(NULL);
So LOG returns NULL when it has NULL input. It doesn't return a rowset...
--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)

March 12, 2016 at 7:48 am

#1864737
RE: Shrink data file even though it is a bad practice....

Chitown (3/11/2016)
I am wondering if I can get some help with the script. I have a DB with more than 550+ data files (Of course they are all different sizes)....
--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)

March 11, 2016 at 3:29 pm

#1864701
RE: Auto generated SQL code

Extremely strong second to what Gail and Grant have both said.
--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)

March 11, 2016 at 11:07 am

#1864645
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (3/11/2016)
Jeff Moden (3/11/2016)
TomThomson (3/11/2016)
Certainly we want to get the numbering added to this splitter in SQL 2016, but we ought to find way of avoiding treating NULL as...
--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)

March 11, 2016 at 11:05 am

#1864644
RE: Find a String in a String

jcuribe (3/11/2016)
my personal favorite is to relly on RegExp, with some CLR you can getit into sql server. What I do is add it to master database. this way its...
--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)

March 11, 2016 at 10:45 am

#1864635
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TheSQLGuru (3/11/2016)
TheSQLGuru (3/11/2016)
Someone needs to benchmark the STRING_SPLIT() function coming out in SQL Server 2016 and update the main article!
https://msdn.microsoft.com/en-us/library/mt684588.aspx
Someone needs to point out that using this 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)

March 11, 2016 at 10:41 am

#1864634
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (3/11/2016)
Certainly we want to get the numbering added to this splitter in SQL 2016, but we ought to find way of avoiding treating NULL as a value rather...
--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)

March 11, 2016 at 10:34 am

#1864631
RE: A transport-level error has occurred in local VPN connection, But not in RDP.

There's something else going on here other than just the double-hop. Using RAISERROR with a severity level of 16 should not prevent remote execution. The original "semaphore" message...
--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)

March 11, 2016 at 10:17 am

#1864626
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TheSQLGuru (3/11/2016)
Someone needs to benchmark the STRING_SPLIT() function coming out in SQL Server 2016 and update the main article!
https://msdn.microsoft.com/en-us/library/mt684588.aspx
Ed Wagner (3/11/2016)
TheSQLGuru (3/11/2016)
Someone needs to benchmark the STRING_SPLIT() function...
--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)

March 11, 2016 at 9:41 am

#1864618
RE: Find a String in a String

Shifting gears, this is a good introductory article for those people that really have no clue on how to do such a thing. It's not meant to be 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)

March 10, 2016 at 10:44 am

#1864311
RE: Find a String in a String

Manic Star (3/10/2016)
This is why i loathe long free-flowing 'note' fields where people embed data they then expect reports or queries to pull from in a consistent way.
Good example...
--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)

March 10, 2016 at 10:37 am

#1864307
RE: Tips for practicing SQL at home

@DaveR-270967,
It's been nearly 3 years since your first post and I couldn't help but notice that your only 2 posts have been on this thread and you've only visited 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)

March 8, 2016 at 7:23 pm

#1863902
RE: HEX conversions

Ed Wagner (2/23/2016)
I've helped several people at work where they just couldn't figure out why something so simple wasn't working and it turned out that they used varchar variables with...
--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)

March 8, 2016 at 5:23 pm

#1863889
RE: Partitioning with null column

er.mayankshukla (3/7/2016)
Alter the column to non-nullable
That's the right idea but they also need to ensure that the data in the partitioning column will NOT change... EVER. 😉
--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)

March 8, 2016 at 10:34 am

#1863765
RE: error during shrink file after restore on test

tony28 (3/7/2016)
thanks for the reply.. I am not sure if somebody knows what I want...so sorry for my english
Because this is test server and data will not...
--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)

March 7, 2016 at 3:27 pm

#1863583

Viewing 15 posts - 18,166 through 18,180 (of 59,069 total)