Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,356 through 23,370 (of 59,102 total)

RE: Job fails on first Wednesday of every month

If it happens at roughly the same time and only on the first Wednesday of a month, then there's something scheduled or a human is running something at the same...
--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)

June 26, 2014 at 7:49 am

#1725079
RE: Byte Me: Insubordinate Clause

KWymore (6/25/2014)
Reminds me of the Oracle error I got the other day -
SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: ...
--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)

June 26, 2014 at 12:48 am

#1724918
RE: The Great Escape

Heh... it would appear that the default definition of default is in default. 😀
--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)

June 26, 2014 at 12:44 am

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

Paul White (5/15/2014)
Jeff Moden (5/15/2014)
I'd not seen that happen in my testing but know that such a thing could happen. Thanks for the heads up and the patch. ...
--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)

June 25, 2014 at 10:50 pm

#1724905
RE: How to Make Scalar UDFs Run Faster (SQL Spackle)

dwain.c (6/25/2014)
Even though I haven't had much time of late to devote to SQL stuff, I did find time to go back and re-read this article.
Excellent new information...
--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)

June 25, 2014 at 9:30 pm

#1724901
RE: Running total error

pwalter83 (6/25/2014)
Lynn Pettis (6/25/2014)
EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.
I found the problem, try the following:
IF...
--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)

June 25, 2014 at 12:04 pm

#1724745
RE: Running total error

pwalter83 (6/24/2014)
ChrisM@Work (6/24/2014)
Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total column which is incorrect?
IF OBJECT_ID ('tempdb..#GLT') IS 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)

June 24, 2014 at 8:32 am

#1724357
RE: How to Make Scalar UDFs Run Faster (SQL Spackle)

Great question! I've never tried it, Stefan. I'm not even going to hazard a guess on that but I'll give it a try tonight after work.
--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)

June 24, 2014 at 8:07 am

#1724342
RE: Apology for today's article

This is another reason why I call SQLServerCentral.com "home". There's a lot of honor in the good folks that run this site.
There are some sites (some that are even...
--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)

June 23, 2014 at 9:24 am

#1724121
RE: Running total in sql and additional issue

pwalter83 (6/23/2014)
No further posts to this thread, please see the new link:
http://www.sqlservercentral.com/Forums/Topic1584256-391-4.aspx
Actually, it's the original thread for this problem and, I agree... let's get back to the original thread. ...
--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)

June 23, 2014 at 8:20 am

#1724095
RE: Running total error

pwalter83 (6/23/2014)
ChrisM@Work (6/23/2014)
pwalter83 (6/23/2014)
ChrisM@Work (6/23/2014)
Paul, you have two threads open which cover the same problem. Can I suggest you choose one of them and close the other? You can do...
--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)

June 23, 2014 at 8:18 am

#1724093
RE: Just curious, what are your SQL pet peeves ?

Koen Verbeeck (6/23/2014)
When importing data from an untyped source - a flat file for example - I usually import everything as strings into the staging table. Because you don't know...
--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)

June 23, 2014 at 2:32 am

#1723925
RE: How to imbed an image into an email sent by dbmail

Thanks, Magoo... That's pretty close to what I would have ended up doing had someone not posted the solution but, my word, I don't believe there are a whole lot...
--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)

June 23, 2014 at 2:26 am

#1723922
RE: Optimizing ORDER BY query

arijit rath (6/23/2014)
Actually it is not a sp but a inline query with order by in the OLEDB source. The query is using 3 views in the join condition which...
--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)

June 23, 2014 at 1:59 am

#1723911
RE: Running total in sql and additional issue

This is going to be terribly slow and resource intensive because it contains a "Triangular Join". Please see the following article on the subject. Even a cursor 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)

June 23, 2014 at 1:53 am

#1723910

Viewing 15 posts - 23,356 through 23,370 (of 59,102 total)