Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,776 through 5,790 (of 59,072 total)

Reply To: Rebuilding and Reorganizing Indexes

ScottPletcher wrote:
Given that you've stated this multiple times with an assortment of different "magic" fillfactors -- 51, 61, 82, etc. -- I don't think it's a "nitpick" at all. So,...
--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 11:59 pm

#3828326
Reply To: A Need for Monitoring without Administration

Since RedGate owns SQLServerCentral.com, a burning question comes to mind and that is, "What privs level does RedGate's "monitor" product require"?
--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 11:55 pm

#3828325
Reply To: Sql Server query to search database with multiple keywords

henryvuong wrote:
I am thinking of using full text search, but full text search does not allow leading wildcard, a search for "phone" will not return any record. What can I...
--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 11:42 pm

#3828323
Reply To: Rebuilding and Reorganizing Indexes

ScottPletcher wrote:
Jeff Moden wrote:
If you have some indexes that have woefully low (less than 80% average percent of page fullness [page density]), then rebuild (NOT reorganize) them at 82% 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 6, 2021 at 10:30 pm

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

Michael L John wrote:
Grant Fritchey wrote:
Doggone it. Silly thing took me to an old post on the thread and I responded a second time. Sorry. I'll leave it up.
It's tough getting old.
Actually, it's...
--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 10:15 pm

#3828296
Reply To: Rebuilding and Reorganizing Indexes

I strongly recommend against that. If you're waiting for a 50-80 mix of fragmentation, you've already waited for most of the fragmentation to happen. This is now in the "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)

January 6, 2021 at 10:10 pm

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

My favorite of all time actually has nothing to do with SQL Server. It was a post (wish I kept the link) about an HP printer tech that was trying...
--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 7:11 pm

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

Eirikur Eiriksson wrote:
Let us uphold our standard on this site, assumptions and speculations have no place on this top quality forums!
😎
Just have a look at this:
https://www.sqlservercentral.com/forums/topic/decimal-places-2#post-3828162
There are way too many threads...
--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 5:36 pm

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

Viewing 15 posts - 5,776 through 5,790 (of 59,072 total)