Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,896 through 11,910 (of 59,099 total)

RE: Who Likes NULL?

Romac - Tuesday, July 10, 2018 2:34 AM
chrisbray - Tuesday, July 10, 2018 2:09 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)

July 10, 2018 at 7:02 am

#1996938
RE: Urgent! - How to extract number from a string

dva2007 - Tuesday, July 10, 2018 5:24 AM
I already used the function given by Jeff dbo.fnLeaveOnly. Both 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)

July 10, 2018 at 6:39 am

#1996934
RE: Data compression

I'm about a week from compressing a 1.4 TeraByte database to about 400GB and a 1 Terabyte database to slightly less than that... and I'm not using CCI and I'm...
--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)

July 9, 2018 at 8:10 pm

#1996890
RE: The GDPR is Coming to the US

Victor Kirkpatrick - Monday, July 9, 2018 12:54 PM
Hopefully the US does not follow Europe's overreaching business-crunching GDPR edict. There's already enough...
--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)

July 9, 2018 at 8:05 pm

#1996889
RE: STRING and FIND SQL Functions

I appreciate anyone that takes the time to post solutions for common problems.
With that and considering that these functions appear to be scalar functions with While loops, 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)

July 9, 2018 at 3:07 pm

#1996871
RE: Who Likes NULL?

Dennis Q Miller - Monday, July 9, 2018 2:23 PM
edwardwill - Monday, July 9, 2018 6:34 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)

July 9, 2018 at 2:46 pm

#1996868
RE: Importing Tricky CSV Files with PowerShell

HighPlainsDBA - Monday, July 9, 2018 2:10 PM
Jeff Moden - Monday, July 9, 2018 11:56 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)

July 9, 2018 at 2:36 pm

#1996867
RE: Importing Tricky CSV Files with PowerShell

HighPlainsDBA - Monday, July 9, 2018 11:42 AM
Thanks for sharing this. Reminded me how much I hate comma delimited files, arguably 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)

July 9, 2018 at 11:56 am

#1996842
RE: CmdExec to delete files not working

Samwell - Monday, July 9, 2018 5:50 AM
It's running as a SQL Agent job and the service account running SQL Agent has...
--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)

July 9, 2018 at 11:36 am

#1996839
RE: Accurate Estimations, But Hash Match Aggregate Spilling to TempDB

chris.o.smith - Friday, June 29, 2018 10:10 AM
Hi,
I'm on SQL Server 2016 Enterprise, V13.0.5026.0. I have a straightforward query that runs on...
--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)

July 9, 2018 at 11:26 am

#1996834
RE: Prevent update trigger

Nqobilemoyo - Monday, July 9, 2018 10:12 AM
I have a database and i would like to create a trigger which 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)

July 9, 2018 at 11:22 am

#1996832
RE: The GDPR is Coming to the US

Brent Ozar - Monday, July 9, 2018 11:01 AM
Thankfully California was so much smarter with their qualifications than the EU 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)

July 9, 2018 at 11:21 am

#1996831
RE: Measure Calculation

RonKyle - Monday, July 9, 2018 9:52 AM
If that field is subject to modification, that might be a real problem.
If 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)

July 9, 2018 at 10:50 am

#1996826
RE: Measure Calculation

RonKyle - Monday, July 9, 2018 9:17 AM
Make sure you cluster on whatever field is aggregated. Otherwise the engine will have to...
--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)

July 9, 2018 at 9:24 am

#1996807
RE: Who Likes NULL?

edwardwill - Monday, July 9, 2018 6:58 AM
Chris Harshman - Monday, July 9, 2018 6:52 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)

July 9, 2018 at 8:42 am

#1996795

Viewing 15 posts - 11,896 through 11,910 (of 59,099 total)