Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,041 through 20,055 (of 59,098 total)

RE: Where the bottle neck in a report

It seems incredulous to me that anyone would request a report that contains 40.000 or 70.000 rows to begin with. No one will be reading that. The only...
--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)

August 2, 2015 at 10:01 am

#1816670
RE: Problem with Importing flat files with embedded (CR)(LF) characters.

I'll start by saying that I'm not an SSIS user but I've seen several posts where people have gotten around the problem of embedded delimiters in a comment field 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)

August 2, 2015 at 9:55 am

#1816668
RE: How To Keep Up with SQL Server

Thanks for the feedback, Andy.
Ironically, I love revisions of SQL Server that are out of date, like 2005 and 2008. Think about it. They're as stable as they...
--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)

August 1, 2015 at 5:10 pm

#1816627
RE: How To Keep Up with SQL Server

It used to be bad enough just to keep up with the new features and when to use them. Lately, a new wrinkle has been added to the mix...
--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 31, 2015 at 7:52 pm

#1816598
RE: How can I check file extension efficiently?

halifaxdal (7/31/2015)
Thanks Scott, I understand now.
Understand even more...
https://msdn.microsoft.com/en-us/library/ms179859.aspx
--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 31, 2015 at 7:39 pm

#1816596
RE: Are the posted questions getting worse?

Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.
http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
You did fine and you're absolutely spot on. You've said what we're all thinking. Well,...
--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 31, 2015 at 7:21 pm

#1816594
RE: If you could use xp_CmdShell securely, would you?

jghali (7/31/2015)
Oh well... :ermm:
In my case, I'm using SQL Express and don't have any other solution than using the xp_cmdshell to use bcp...
I'll continue searching for the best way 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 31, 2015 at 7:12 pm

#1816592
RE: If you could use xp_CmdShell securely, would you?

jghali (7/31/2015)
WOW! do I feel silly! I actually thought it was an actual thread...
Note to self: Always look at the date before posting!!! :hehe:
Did you ever create that article?...
--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 31, 2015 at 2:47 pm

#1816569
RE: If you could use xp_CmdShell securely, would you?

OMG. This post is that old already?
--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 31, 2015 at 1:49 pm

#1816541
RE: Detecting Differences in Files on Servers

Ed Wagner (7/30/2015)
I forgot to add it to the article, but many thanks to Jeff Moden for being my reviewer, giving me good advice and encouraging me to write 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)

July 30, 2015 at 8:27 am

#1816151
RE: How to calculate number of days since start of fiscal year?

Thought I'd throw my hat into the ring. As always, details are in the comments in the code.
CREATE FUNCTION dbo.FyParts
(@Date...
--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 29, 2015 at 11:47 pm

#1816005
RE: Query inside an IF statement runs forever

What's the execution plan without the IF statement look like?
--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 29, 2015 at 10:29 pm

#1815996
RE: get numeric values from this string

info 58414 (7/29/2015)
Hi,
why can i get the numeric values from this stiring?
{_cpn}=1743; {_cpnll}=4511
Result: 1743, 4511
Position and len of the value can be diffrent...
Thanks and Regards
Nicole
🙂
Will there only ever be 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 29, 2015 at 10:06 pm

#1815995
RE: Alternate rows

sharonsql2013 (7/29/2015)
Came up with two separate queries one for last week and one for alternate weeks (%2) and did a Union. That helped
None of it will work if you're closer...
--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 29, 2015 at 10:04 pm

#1815994
RE: Is this SQL?

PHYData DBA (7/29/2015)
So this post is more Cathartic than a professional question.
I do want the input of anyone that would like to comment about the content of this post.
This is...
--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 29, 2015 at 9:41 pm

#1815992

Viewing 15 posts - 20,041 through 20,055 (of 59,098 total)