Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,441 through 13,455 (of 59,095 total)

RE: Please help with xp_cmdshell

ZZartin - Monday, December 11, 2017 9:09 AM
Jeff Moden - Monday, December 11, 2017 9:07 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)

December 11, 2017 at 8:33 pm

#1971693
RE: Calculating varying process capacity

drew.allen - Monday, December 11, 2017 8:45 AM
Jeff Moden - Sunday, December 10, 2017 10:10 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)

December 11, 2017 at 3:56 pm

#1971678
RE: Intellisense broken?

Heh... you titled this post "Intellisense broken?"
My answer is "Yes... just like always". 😉
--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)

December 11, 2017 at 2:14 pm

#1971666
RE: STRING_SPLIT with no delimiter

J Livingston SQL - Monday, December 11, 2017 1:02 PM
Jeff Moden - Monday, December 11, 2017 10:29...
--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)

December 11, 2017 at 1:33 pm

#1971661
RE: Are the posted questions getting worse?

Phil Parkin - Monday, December 11, 2017 9:03 AM
Jeff Moden - Monday, December 11, 2017 8:54 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)

December 11, 2017 at 10:34 am

#1971609
RE: STRING_SPLIT with no delimiter

werner.grimmer - Monday, December 11, 2017 10:25 AM
I tried the answer on SQL Server 2016, the result is only one A?
THX
There's something...
--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)

December 11, 2017 at 10:29 am

#1971606
RE: cost threshold for parallelism setting

vsamantha35 - Sunday, December 10, 2017 9:40 PM
Hi All,
I want to change "cost threshold for parallelism" from 5 to 25 as we...
--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)

December 11, 2017 at 9:17 am

#1971588
RE: "Tag" highest value in the month

saravanatn - Monday, December 11, 2017 7:42 AM
Hi,
You are right. I made a small mistake.Below query gives accurate results. But 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)

December 11, 2017 at 9:13 am

#1971587
RE: "Tag" highest value in the month

Simple SQL Tips - Monday, December 11, 2017 7:27 AM
Jeff, After reading up on CTE and understanding what you provided, that's exactly...
--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)

December 11, 2017 at 9:11 am

#1971586
RE: Please help with xp_cmdshell

Bert-701015 - Monday, December 11, 2017 8:37 AM
Have you considered using xp_dirtree instead of xp_cmdshell. It carries less risk.
Actually, it doesn't. Proper...
--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)

December 11, 2017 at 9:07 am

#1971583
RE: Are the posted questions getting worse?

jasona.work - Monday, December 11, 2017 8:41 AM
Thom A - Monday, December 11, 2017 8:11 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)

December 11, 2017 at 8:54 am

#1971578
RE: Are the posted questions getting worse?

ThomasRushton - Friday, December 8, 2017 2:12 AM
Phil Parkin - Thursday, December 7, 2017 2:08 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)

December 11, 2017 at 8:46 am

#1971574
RE: STRING_SPLIT with no delimiter

bknight 46549 - Monday, December 11, 2017 7:29 AM
It seems to me the answer to this question is more about string manipulation...
--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)

December 11, 2017 at 8:44 am

#1971570
RE: SQL Server 2016 crashes

At this point, I recommend you get help from Microsoft. We're not going to be able to solve this for you especially since we have no clue about the firewall...
--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)

December 11, 2017 at 6:58 am

#1971537
RE: STRING_SPLIT with no delimiter

Budd - Monday, December 11, 2017 6:39 AM
WOW !!
Awesome question and great explanation, BUT 🙂
"3. CAST(... AS VARCHAR) converts the binary value,...
--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)

December 11, 2017 at 6:52 am

#1971535

Viewing 15 posts - 13,441 through 13,455 (of 59,095 total)