Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,011 through 14,025 (of 59,101 total)

RE: parsing variable into @query using sp_send_dbmail

Ed Wagner - Saturday, October 21, 2017 2:05 PM
As far as I know, you aren't going to generate a native Excel file...
--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)

October 21, 2017 at 4:31 pm

#1964671
RE: Please let me know what is wrong with my code.

jcelko212 32090 - Saturday, October 21, 2017 10:01 AM
Lynn Pettis - Friday, October 20, 2017 6:15 PM
--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)

October 21, 2017 at 4:13 pm

#1964670
RE: exception data in DB

cavepoubelle - Saturday, October 21, 2017 9:21 AM
thanks Sue, this error appears when launching an application that connects to a...
--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)

October 21, 2017 at 4:09 pm

#1964669
RE: using cross apply to find different values trough xml files eficiency

Eirikur Eiriksson - Saturday, October 21, 2017 3:13 AM
This is a very inefficient way of querying the XML, can you post a...
--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)

October 21, 2017 at 4:00 pm

#1964668
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Saturday, October 21, 2017 2:07 AM
Well... I really am a big dumb animal... I forgot to unplug 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)

October 21, 2017 at 3:58 pm

#1964667
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Friday, October 20, 2017 11:27 PM
Jeff Moden - Friday, October 20, 2017 7:47...
--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)

October 21, 2017 at 3:56 pm

#1964666
RE: Making Indexes Invisble to the Optimiser

kevaburg - Saturday, October 21, 2017 12:56 AM
Another reason I want to avoid hints is this: I attended a lecture from...
--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)

October 21, 2017 at 3:09 pm

#1964664
RE: Trying to speed up this 'GetWorkingDays' function.

While we're at it... when all this first started and while I was waiting for your Tally function, I cranked this out to generate test data. I normally resort 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)

October 20, 2017 at 7:47 pm

#1964631
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Friday, October 20, 2017 4:07 PM
@jeff... I meant to ask you... Would it be a major...
--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)

October 20, 2017 at 7:31 pm

#1964630
RE: How to continue our SQL agent scheduled daily backup in Azure?

I'm going to bump this one for you because it seems like someone (not me) should be able to answer this off the top of their heads.
--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)

October 20, 2017 at 5:48 pm

#1964627
RE: Where are my DIFF backups?

patreddy - Thursday, October 19, 2017 11:54 AM
Yeah, I can see that as an argument for multiple files - but also...the more...
--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)

October 20, 2017 at 5:29 pm

#1964626
RE: using cross apply to find different values trough xml files eficiency

montserrat.deza - Friday, October 20, 2017 2:12 PM
Hello Experts,
I am trying to run the following query:
SELECT CAST(t.nodes.query('data(item)') as varchar(max)) 'Item',
...
--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)

October 20, 2017 at 4:37 pm

#1964622
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Friday, October 20, 2017 3:45 PM
below86 - Friday, October 20, 2017 2:47 PM
--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)

October 20, 2017 at 3:56 pm

#1964615
RE: Extreme slowness

Thanks, Steve. It seems to have helped quite a bit but don't know for sure because things seem to calm down about this time of day every day.
Please...
--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)

October 20, 2017 at 3:53 pm

#1964614
RE: Making Indexes Invisble to the Optimiser

Eric M Russell - Friday, October 20, 2017 1:39 PM
You might achieve what you're wanting to do using hints. FORCESCAN forces scan...
--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)

October 20, 2017 at 3:50 pm

#1964612

Viewing 15 posts - 14,011 through 14,025 (of 59,101 total)