Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,091 through 9,105 (of 59,091 total)

Reply To: T-SQl or Store Procedure which fit better

jcelko212 32090 wrote:
> my problem is that some positions have the max salary listed as hourly rate and some are annual amount. Therefore, I need to multiply the hourly rate by...
--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)

July 5, 2019 at 9:50 pm

#3660317
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Jeff Moden wrote:
It's the law of home ownership, Steve... all 10 minutes jobs take at least 6 hours to complete. 😀
And 5 trips to the hardware store.
6 if...
--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)

July 3, 2019 at 6:55 pm

#3659907
Reply To: Are the posted questions getting worse?

It's the law of home ownership, Steve... all 10 minutes jobs take at least 6 hours to complete. 😀
--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)

July 3, 2019 at 4:59 pm

#3659871
Reply To: Indexing question

For both online and offline index REBUILDs (and assuming the index is over 128 extents (or 1024 pages), which is only 8MB), a brand new index will be created 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)

July 2, 2019 at 2:27 pm

#3659314
Reply To: Are the posted questions getting worse?

Thom A wrote:
below86 wrote:
But just ripping into the site isn't going to help anything change; we all know that constructive feedback is far better received. We've all experienced users that 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)

July 2, 2019 at 12:31 am

#3659181
Reply To: backup tool to check every daily if i have success on backup

almirfiorio wrote:
Dear Members I have more than 50 servers with sql server installed each of them runs a backup job every day at night Exists any backup tool I can...
--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)

July 1, 2019 at 11:09 pm

#3659131
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
I'll leave this here, as we're not going to agree.
...
I hope you all still find the site and community worth supporting and continue to do so, but if not,...
--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)

July 1, 2019 at 11:07 pm

#3659130
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Visually appealing is a personal preference. The people on this thread seem (to me and a few others) to be complaining as though the formatting is something that's right...
--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)

July 1, 2019 at 3:45 pm

#3658940
Reply To: Conditional trigger on column update

I believe that the UPDATE() function can help you a lot here. For example, if the UPDATE() function is NOT true, you can shortcut the trigger with an early exit. ...
--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)

June 30, 2019 at 3:13 pm

#3658738
Reply To: Always ensuring an output variable is padded to 7 characters

jcelko212 32090 wrote:
You can do this easily with string functions, but it’s still a stinking kludge caused by bad design. Most of the work in SQL is done in the DDL,...
--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)

June 28, 2019 at 9:00 pm

#3658591
Reply To: 3 varbinary(max) columns in one table

Because of a rather insidious change that MS made for the new LOB datatypes compared to the old ones in 2005, most people's usage of LOBs causes huge problems 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)

June 28, 2019 at 1:39 pm

#3658439
Reply To: Always ensuring an output variable is padded to 7 characters

Weegee2017 wrote:
Hi there I have the following code which has to extract an number from a AccountNumber variable declare @AccountNumber varchar(20) = '8063#0018375' select SUBSTRING(@AccountNumber,CHARINDEX('#',@AccountNumber)+1,Len(@AccountNumber) - CHARINDEX('#',@AccountNumber)) select Len(SUBSTRING(@AccountNumber,CHARINDEX('#',@AccountNumber)+1,Len(@AccountNumber) -...
--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)

June 28, 2019 at 1:33 pm

#3658437
Reply To: Are the posted questions getting worse?

Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Ummmm.... is that where the decisions to not include critical functionality or "not good enough but we have a schedule to meet" decisions are cast in...
--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)

June 28, 2019 at 11:30 am

#3658384
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Eirikur Eiriksson wrote:
What a day, one could not make it up! My best friend taken to a hospital (second time in two days) after collapsing going flat on the ground,...
--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)

June 28, 2019 at 2:52 am

#3658341
Reply To: Potential issue with runaway index growth

alexhdavies wrote:
Hi All The table structure is as below. Whilst i get that a clustered index is the data, the thing I'm struggling to get my head round is why...
--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)

June 28, 2019 at 2:46 am

#3658340

Viewing 15 posts - 9,091 through 9,105 (of 59,091 total)