Jeff Moden

Forum Replies Created

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

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
RE: STRING_SPLIT()

Raghavender Chavva - Monday, July 9, 2018 8:26 AM
When I executed this code in SQL Server 2016, below is the error:
Procedure expects...
--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:38 am

#1996794
RE: execute strored procedure through OPENROWSET-SYNTAX ERROR

george.sofroniadis - Monday, July 9, 2018 7:12 AM
declare @tmp as varchar(25)
set @tmp ='Î Î‘Î Î‘Î“ÎŸÎ¥'
SELECT
*
INTO
#tmpSortedBooks
FROM
OPENROWSET(
'SQLNCLI',
'Server=MNG01\MPISDARIS;Trusted_Connection=yes;Database=Reporting;',
'EXEC...
--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 7:55 am

#1996785
RE: Dealing with Disparate Goals

My experience has been that it all comes down to proper bi-directional communications. By "proper", I mean that management drops the "I'm the boss... do it my way" attitude 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 6:39 am

#1996771
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Sunday, July 8, 2018 11:34 PM
been away (out of mobile range) for a few days. This has been...
--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 6:30 am

#1996768

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