Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,011 through 20,025 (of 59,072 total)

RE: Are the posted questions getting worse?

Alvin Ramard (8/1/2015)
Jeff Moden (7/31/2015)
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...
--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:34 am

#1816679
RE: How Do I Select Data From Table With A Particular Priority

sushantkatte (8/1/2015)
Thank You very much @SScrazy for providing the solution. i am very new to the sql server programming and have started learning recently. could you please help me understand...
--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:23 am

#1816677
RE: How Do I Select Data From Table With A Particular Priority

LinksUp (8/1/2015)
If the ordering is indeed the alter_msg, then I would create another table to define the sorting method. Hard coding each possibility could quickly become a nightmare! :w00t:
Here 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)

August 2, 2015 at 10:19 am

#1816676
RE: SQL login name practices - development vs production

webrunner (8/1/2015)
I know the general best practice for SQL Server is to use Windows logins, but we're not there yet.
I know you already know this but I 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)

August 2, 2015 at 10:08 am

#1816672
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

Viewing 15 posts - 20,011 through 20,025 (of 59,072 total)