Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,986 through 15,000 (of 59,097 total)

RE: To Delete / Truncate / Drop & Create

RonKyle - Wednesday, May 24, 2017 7:11 AM
It's a third party software to record telephony information.
It sounds like you should invite...
--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)

May 24, 2017 at 9:06 am

#1944011
RE: Are the posted questions getting worse?

Sean Lange - Wednesday, May 24, 2017 8:47 AM
Eirikur Eiriksson - Tuesday, May 23, 2017 10:59 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)

May 24, 2017 at 9:03 am

#1944009
RE: Simulate filling Transaction log

abhij33t - Tuesday, May 23, 2017 7:33 PM
If you must know my secret.... I am trying a smoke test, if we receive...
--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)

May 24, 2017 at 9:01 am

#1944008
RE: Count Decimal Places

Thanks for the feedback, shanmukha.sqlbi .
--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)

May 24, 2017 at 8:47 am

#1944004
RE: Script out permissions - Azure SQL database

I can't even spell Azure but, hopefully, this will act as a "bump" for your question so that someone might see it and answer. 😉
--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)

May 23, 2017 at 10:12 pm

#1943920
RE: Count Decimal Places

Jeff Moden - Tuesday, May 23, 2017 7:16 PM
shanmukha.sqlbi - Monday, May 22, 2017 11:20 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)

May 23, 2017 at 9:34 pm

#1943919
RE: Count Decimal Places

Sergiy - Tuesday, May 23, 2017 7:50 PM
Not to mention that the original request was lame.3.3 not equal to 3.3010/3 = 3.3...
--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)

May 23, 2017 at 9:04 pm

#1943918
RE: Count Decimal Places

Jamie Ingram-729524 - Tuesday, May 23, 2017 8:47 PM
... and please stop deleting your posts. It's ok to make a mistake and...
--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)

May 23, 2017 at 8:56 pm

#1943917
RE: Count Decimal Places

Jamie Ingram-729524 - Tuesday, May 23, 2017 8:25 PM
declare @s-2 varchar(20)
begin
set @s-2 = '10.235400'
select len(@S) - charindex('.',@s,1) +1 - patindex('%[1-9]%',reverse(@s))
end
Nice try...
--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)

May 23, 2017 at 8:52 pm

#1943916
RE: Count Decimal Places

shanmukha.sqlbi - Monday, May 22, 2017 11:20 AM
Easiest Way to find out.
-- For digits
Select Left(COLUMN_NAME, Case When CharIndex('.',COLUMN_NAME) = 0 Then 0...
--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)

May 23, 2017 at 7:16 pm

#1943909
RE: Simulate filling Transaction log

abhij33t - Tuesday, May 23, 2017 6:00 PM
It may sound extremely simple and might be it is.... but I am trying to...
--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)

May 23, 2017 at 6:23 pm

#1943907
RE: Looking for best approach

autoexcrement - Tuesday, May 23, 2017 9:29 AM
FULL OUTER JOIN?
That was my first thought.
--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)

May 23, 2017 at 4:46 pm

#1943904
RE: Naming Conventions for the Cloud

Steve Jones - SSC Editor - Tuesday, May 23, 2017 8:49 AM
xsevensinzx - Tuesday, May 23, 2017...
--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)

May 23, 2017 at 4:24 pm

#1943903
RE: To Delete / Truncate / Drop & Create

RonKyle - Tuesday, May 23, 2017 7:43 AM
RonKyle - Thursday, May 18, 2017 7:08 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)

May 23, 2017 at 1:40 pm

#1943883
RE: To Delete / Truncate / Drop & Create

Sean Lange - Tuesday, May 23, 2017 7:59 AM
That isn't a natural key. It is using a surrogate key from 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)

May 23, 2017 at 1:34 pm

#1943881

Viewing 15 posts - 14,986 through 15,000 (of 59,097 total)