Jeff Moden

Forum Replies Created

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

RE: RAM Required to run SQL Server + Web Application + SSIS packages

bmg002 - Thursday, May 25, 2017 11:23 AM
Jeff Moden - Thursday, May 25, 2017 11: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)

May 25, 2017 at 11:38 am

#1944237
RE: RAM Required to run SQL Server + Web Application + SSIS packages

bmg002 - Wednesday, May 24, 2017 8:32 AM
...then got some big SSIS packages in there and if the memory got too low,...
--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 25, 2017 at 11:07 am

#1944225
RE: Audio Attacks

David.Poole - Thursday, May 25, 2017 1:08 AM
When the iPhone 4S came out it was usual to see senior execs placing their...
--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 25, 2017 at 9:02 am

#1944184
RE: The OUTPUT Clause for INSERT & DELETE Statements

Gosh... this article started out good with code that you could copy'n'paste to setup the test table. Why didn't you continue that with the remaining code examples instead of using...
--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 25, 2017 at 8:55 am

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

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