Jeff Moden

Forum Replies Created

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

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

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