Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,106 through 9,120 (of 59,102 total)

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
Reply To: Potential issue with runaway index growth

Andrey wrote:
Also, you can implement compression (page or row) and get indexes smaller + less I/O and wiser RAM usage. Thanks to Kalen Delaney for the ported version of standard...
--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:23 am

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

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 stone?...
--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 27, 2019 at 11:18 pm

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

Steve Jones - SSC Editor wrote:
With the new SSC, everything is supposed to run through a dev/QA cycle before prod. We have PRs that require review before they get merged into a deployable spot....
--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 27, 2019 at 6:59 pm

#3658238
Reply To: Potential issue with runaway index growth

alexhdavies wrote:
Hi,I'm pretty new to Azure but less new to SQL Server. We have an Azure SQL database with one table of about 300000 rows. So not huge. But, whilst...
--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 26, 2019 at 3:31 pm

#3657780

Viewing 15 posts - 9,106 through 9,120 (of 59,102 total)