Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,556 through 15,570 (of 59,101 total)

RE: Efficient SQL Programming?

Grant Fritchey - Monday, February 27, 2017 2:18 AM
Man, Jeff. Leave some crumbs for the rest of us.
Heh... thanks for the feedback,...
--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)

February 27, 2017 at 9:22 am

#1930495
RE: Check if xp_cmdshell is turned on and flip the bit

SQLShark - Monday, February 27, 2017 8:24 AM
Great Deck, I agree with all your points. Sometimes it would be nice to include...
--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)

February 27, 2017 at 9:12 am

#1930490
RE: Check if xp_cmdshell is turned on and flip the bit

Thank you both for the feedback. In fact, I've been considering converting it to an article so I really appreciate 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)

February 27, 2017 at 8:14 am

#1930477
RE: Human and Machine Learning

xsevensinzx - Sunday, February 26, 2017 12:10 AM
I know from my end where I work primarily with data science, we are using...
--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)

February 26, 2017 at 11:22 pm

#1930418
RE: Roll from lowest level child to it's subsequent parent

PSB - Sunday, February 26, 2017 8:28 PM
Any help will be appreciated..
For your entire series of questions on this particular table, you...
--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)

February 26, 2017 at 11:00 pm

#1930416
RE: Efficient SQL Programming?

What you have there is a "Catch-All" query where the input parameters could be missing, have a special meaning (All), or have an actual value. As you found out, 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)

February 26, 2017 at 10:34 pm

#1930414
RE: Searching for date and weekday counts within Nvarchar column

I tend to "over-engineer" a bit when it comes to the quality of data. Yep... we need to know the hourly stuff but I'd also want to know how...
--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)

February 26, 2017 at 1:31 pm

#1930393
RE: XP_CMDSHELL & RS.EXE and access rights

John Mitchell-245523 - Friday, February 24, 2017 5:19 AM
Have you tried running SQL Server under a named Windows account (either domain or...
--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)

February 25, 2017 at 3:38 pm

#1930357
RE: Conversion script runs for long time unless carved up, not sure why.

NicHopper - Friday, February 24, 2017 2:21 AM
Hi,
I'll keep this brief. We have a data conversion script written by one of 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)

February 25, 2017 at 3:10 pm

#1930356
RE: How to create a views with variable

Luis Cazares - Friday, February 24, 2017 1:29 PM
You might want to check an inline table-valued function.
I strongly second that. Think of...
--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)

February 25, 2017 at 3:06 pm

#1930352
RE: PLE drops to Zero every time do REORG of ALL DBS daily,

If you're not having performance issues with normal stuff, stop worrying about PLE dropping during index maintenance because it's going to use whatever resources it can get its hands 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)

February 25, 2017 at 2:52 pm

#1930348
RE: The Secure Medical Data Challenge

The first step for data security actually hasn't been taken by folks that have written most of the medical or even financial software that I've seen. They use clear text...
--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)

February 25, 2017 at 2:43 pm

#1930346
RE: How to “step through” a list of values creating a record for each value

mpsqlsercen - Thursday, February 16, 2017 7:41 AM
Jeff Moden - Wednesday, February 15, 2017 10:03 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)

February 25, 2017 at 2:11 pm

#1930343
RE: Check if xp_cmdshell is turned on and flip the bit

Jeff Moden - Friday, February 17, 2017 11:10 PM
Actually, I had previously uploaded the presentation to this site. You can find 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)

February 25, 2017 at 12:26 pm

#1930339
RE: SQL Server Trace Flags - Complete list

SQLRNNR - Friday, February 24, 2017 12:26 PM
Jeff Moden - Thursday, February 23, 2017 5:45 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)

February 25, 2017 at 11:00 am

#1930332

Viewing 15 posts - 15,556 through 15,570 (of 59,101 total)