Jeff Moden

Forum Replies Created

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

Reply To: Load Monitor

Bruin wrote:
We have a Transaction server writing records to SQL recording machine data. The process writes records every 15 minutes to a table from different equipment.
I'd take out the...
--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 7, 2021 at 4:39 pm

#3828625
Reply To: Sql Server query to search database with multiple keywords
SwePeso wrote:
Put your search words in another table.
```
SELECT  t.*
FROM    dbo.table1 AS t
WHERE   EXISTS (SELECT * FROM dbo.table2 AS x WHERE t.Product...
```
--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 7, 2021 at 5:54 am

#3828418
Reply To: Rebuilding and Reorganizing Indexes

SwePeso wrote:
Execute this to see the fillfactor in use. You would expect 50% right?
DBCC SHOWCONTIG (tbl_user);
You are wrong. SQL Server uses 100% no matter what.
What happens if we rebuild the...
--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 7, 2021 at 5:32 am

#3828416
Reply To: A Need for Monitoring without Administration

Steve Jones - SSC Editor wrote:
https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/permissions-required-for-monitoring-servers
Thanks, Steve.
--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 7, 2021 at 1:02 am

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

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