Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,526 through 15,540 (of 59,063 total)

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
RE: Active Directory -> SQL (Convert)

Referencing the following URL ...
https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx
... and if you only want the date and not the time, you can do the following...
DECLARE @AcctExpires VARCHAR(32) =...
--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 24, 2017 at 8:28 pm

#1930301
RE: SQL Server Trace Flags - Complete list

kast218 - Thursday, February 23, 2017 9:11 AM
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 23, 2017 at 7:55 pm

#1930086
RE: Are the posted questions getting worse?

jasona.work - Thursday, February 23, 2017 2:19 PM
Someone, somewhere, is up to mischief...
That would be me. 😉
--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 23, 2017 at 7:50 pm

#1930084
RE: Store Procedure

Steve Jones - SSC Editor - Thursday, February 23, 2017 7:02 PM
I absolutely use a tally table, but I may use 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)

February 23, 2017 at 7:40 pm

#1930083
RE: Data import files

Ed Wagner - Thursday, February 23, 2017 3:39 PM
I do BULK INSERT all the time, but not on SQL 2016 yet. I...
--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 23, 2017 at 7:37 pm

#1930081
RE: Query Cost Relative to the Batch vs. statistics io vs. Extended Events

SoCal_DBD - Thursday, February 23, 2017 1:39 PM
Thank you Jeff and Scott.
That said, is there ever any case or reason why one...
--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 23, 2017 at 6:20 pm

#1930077
RE: Performance improves after reboot

cphite - Thursday, February 23, 2017 1:48 PM
RVO - Wednesday, February 22, 2017 8:01 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 23, 2017 at 6:11 pm

#1930076
RE: Store Procedure

Steve Jones - SSC Editor - Thursday, February 23, 2017 2:59 PM
I can't say it's my idea. I'm not sure if this...
--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 23, 2017 at 3:57 pm

#1930066

Viewing 15 posts - 15,526 through 15,540 (of 59,063 total)