Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,196 through 18,210 (of 59,102 total)

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

Ed Wagner (3/11/2016)
I hope you're planning on doing some serious index maintenance after all this shrinking. Shrinking data files tends to fragment indexes to 99%, so it will be...
--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 9:52 am

#1864744
RE: Query/Performance Tuning Steps without help of profiler

GilaMonster (3/7/2016)
Jeff Moden (3/7/2016)
Heh... I strongly agree... to disagree. 😛
You're welcome to disagree, but Profiler's deprecated and Extended Events are far better, lighter weight, more configurable and new events...
--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 9:23 am

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

Solomon Rutzky (3/12/2016)
Jeff Moden (3/12/2016)
IMHO, what you have to remember is that, no matter what type of function it is, it's still "just" a string manipulation function, which makes 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)

March 12, 2016 at 9:09 am

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

Viewing 15 posts - 18,196 through 18,210 (of 59,102 total)