Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,806 through 5,820 (of 59,089 total)

Reply To: Slow database performance

vsamantha35 wrote:
...but they don't any action.
Of course not... they're too busy trying to meet a usually impossible schedule...
vsamantha35 wrote:
They say, we are busy with so many projects going on 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)

January 6, 2021 at 2:28 am

#3827911
Reply To: which is more speed cluster index or noncluster index and why ?

No. It is not "correct". The correct answer is "It Depends".
It depends both on the data in the table, they key column(s) you've selected for the Clustered and Non-Clustered indexes,...
--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)

January 6, 2021 at 1:41 am

#3827892
Reply To: Update Column Based on Criteria from Other Columns -- improved post included DDL

If you want coded help, please see the article at the first link in my signature line below for one way to create "Readily Consumable Data".
--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)

January 6, 2021 at 1:35 am

#3827891
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?

Sounds like a road trip to the data provider with a pork chop cannon may be in order. 😀
Yeah... I know. It didn't work for me either. All I got...
--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)

January 5, 2021 at 9:57 pm

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

Steve Jones - SSC Editor wrote:
Happy New Year, hopefully everyone is starting the year out on a good note.
BWAAAA-HAAAAAA!!! Some of my fellow older folks in the crowd will have an appreciation for what...
--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)

January 5, 2021 at 9:52 pm

#3827816
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?
Erland Sommarskog wrote:
Here is another example based on what I found to day:
```
SELECT char(n) FROM numbers WHERE n BETWEEN acsii('A') AND ascii('Z')
```
In the actual example I found when...
--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)
January 5, 2021 at 9:40 pm

#3827812
Reply To: Rebuilding and Reorganizing Indexes

@SQLNumpty wrote:
christi1711 wrote:
First of all, I saw that we have Amazon RDS for SQL Server.
Regarding script for index maintenance (https://ola.hallengren.com/) it looks like the same as what I want 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)

January 5, 2021 at 9:32 pm

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

Jo Pattyn wrote:
Happy New Year 2021
Same to you, Jo! To you and all the other denizens of this fine forum, I hope this post finds all of you and yours 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)

January 5, 2021 at 8:23 pm

#3827758
Reply To: question on Index Rebuilds

That's not true, Scott. Not that you should but you can go back to the FULL Recovery Model from the BULK_LOGGED recovery model at any time without any kind of...
--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)

January 4, 2021 at 3:12 pm

#3827111
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?

Thanks, Erland. Interesting use case for the year/100 stuff.
--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)

January 4, 2021 at 2:25 pm

#3827097
Reply To: question on Index Rebuilds

Again, though... they don't need to be full backups. They can be diffs to save some time and, possibly, reduce the size of backups.
--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)

January 4, 2021 at 1:19 pm

#3827058
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?

Steve Collins wrote:
I use 2 monster .sql scripts to answer SSC/SO questions. One currently has 13,787 lines and contains 32 occurrences of 'fnTally' of which 24 specify the sequence begin with...
--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)

January 4, 2021 at 1:04 pm

#3827055
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?

frederico_fonseca wrote:
out of the normal but in a particular application from one of my clients sequences always started at 1000.
And on a similar situation, multi-tenant, each tenant would start at...
--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)

January 4, 2021 at 1:02 pm

#3827054
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?

That's not a bad idea. I think I may actually have a copy of that database, now that you mention it. Heh... if nothing else, it would make for good...
--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)

January 4, 2021 at 1:03 am

#3826899
Reply To: How often have you needed to start a sequence of numbers at other than 1 or 0?

Steve Collins wrote:
Jeff Moden wrote:
Getting back to Itzik's challenge, I had a question form in my mind. As a pre-amble to the question, I've found that I use "1" as a starting...
--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)

January 3, 2021 at 10:56 pm

#3826866

Viewing 15 posts - 5,806 through 5,820 (of 59,089 total)