Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,771 through 16,785 (of 59,067 total)

RE: Non-clustered index question

Also remember that (except for filtered indexes) that every non-clustered index is a complete duplication of all the data in the columns in the index key and any INCLUDEs. ...
--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)

September 20, 2016 at 8:48 am

#1901902
RE: How to read list of files in folder using T-SQL?

BOR15K (9/20/2016)
Hello,
Can one advise how to obtain file's details, please? Both xp_dirtree and xp_cmdshell return expected list of files, but I also need their properties: size and date.
Is it possible,...
--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)

September 20, 2016 at 8:21 am

#1901875
RE: View for real-time list pulls in an OLTP

vilyana (9/19/2016)
Thank you for the concern.
The ERD and the View columns in the image are exactly what they need to be to illustrate the starting point and desired result...
--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)

September 20, 2016 at 7:54 am

#1901865
RE: Group Concatenate Strings?

mister.magoo (9/19/2016)
It's a horrible three scan plan...but I can't think of another way right now...
WITH ALL_A(A) AS(SELECT DISTINCT A FROM #T)
SELECT T.A, CONCATSTRINGB, CONCATSTRINGC
FROM ALL_A AS T
CROSS APPLY (
...
--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)

September 19, 2016 at 9:50 pm

#1901782
RE: Select statements included within a function cannot return data to a client: SQL server 2014

dimpythewimpy (9/19/2016)
Can someone suggest a workaround for this. I have researched online and tried inline function but,that didn't work as I am not returning a table here. It is just...
--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)

September 19, 2016 at 5:40 pm

#1901771
RE: Are the posted questions getting worse?

Eirikur Eiriksson (9/19/2016)
Sean Lange (9/19/2016)
Eirikur Eiriksson (9/19/2016)
I'm normally very tolerant when it comes to noobs but this one only leaves me three choises
😎
1) deaf
2) daft
3) dumb
I think that is 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)

September 19, 2016 at 5:31 pm

#1901769
RE: The 10X Programmer

To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.
--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)

September 19, 2016 at 5:02 pm

#1901766
RE: Convert time from one format to another

Alan.B (9/19/2016)
Assuming the 6 in your example represents an hour you could do this:
DECLARE @time varchar(10) = 24;
SELECT MAX(CONCAT(REPLICATE(0,2-LEN(@time)),@time,'00'))
WHERE @time BETWEEN 0 AND 24;
This returns the time in military...
--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)

September 19, 2016 at 4:49 pm

#1901764
RE: Contractors - What work do you consider to be in the 'DBA' realm?

Remember that a lot of people don't know what "DBA" is compared to "DBA". 😛 In many cases, I've found that when people ask for a "DBA" as...
--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)

September 19, 2016 at 4:09 pm

#1901758
RE: Are the posted questions getting worse?

Eirikur Eiriksson (9/19/2016)
Hi all,
I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if anyone has...
--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)

September 19, 2016 at 1:06 pm

#1901723
RE: Are the posted questions getting worse?

Interesting on both. I'd love to see the trigger code for those.
--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)

September 19, 2016 at 1:02 pm

#1901722
RE: Are the posted questions getting worse?

More like "people" season. Some people just don't get it. See the following where what someone is doing actually could kill people. I've confirmed Sergiy's findings with...
--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)

September 19, 2016 at 12:43 pm

#1901718
RE: View for real-time list pulls in an OLTP

vilyana (9/19/2016)
Sergiy (9/19/2016)
It seems the design is faulty.
PatientMedicationCourse must be allocated to PatientTherapyCourse, not directly to PatientTreatment.
Medications prescribed for one Therapy Course must not be mixed with medications for another...
--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)

September 19, 2016 at 12:37 pm

#1901713
RE: The Danger of xp_cmdshell

Stefan LG (9/18/2016)
I must admit I am a big fan of xp_cmdshell!
I have been using it for many years now, without any problems (security or otherwise). I suppose there are...
--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)

September 19, 2016 at 1:29 am

#1901562
RE: View for real-time list pulls in an OLTP

I agree with what Sergiy stated. There's a pretty easy solution to this request (I just wrote it and tested it) but found a similar horrible problem to 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)

September 19, 2016 at 1:25 am

#1901561

Viewing 15 posts - 16,771 through 16,785 (of 59,067 total)