Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,136 through 6,150 (of 59,089 total)

Reply To: SQL Full text query too slow

ruifrazao wrote:
Jeff Moden wrote:
Why does your code setup full text catalogues on EVERY VARCHAR column in the table? Is that really necessary? Depending on the schema of your table, that could...
--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)

November 5, 2020 at 1:54 pm

#3804579
Reply To: High buffer size for a table could mean either it has incorrect indexes or ?

To complete the sentence you started in the title... "Crap Code" consisting of a lot or just a few common problems, insufficient indexes, improper joins, incorrect criteria, poor table/database design...
--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)

November 5, 2020 at 8:04 am

#3804522
Reply To: merge data

I know this sounds a bit "smarty pantsed" but, in order to not have PK conflicts, you have to stop sending or pulling... PK conflicts.
In other words, you need 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)

November 4, 2020 at 11:39 pm

#3804444
Reply To: SQL Full text query too slow
For some reason (perhaps someone clicked on report instead of reply by accident), my previous post was reported as spam, so trying again...
I have a couple of questions...
1. Why does...
--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)
November 4, 2020 at 11:20 pm

#3804440
Reply To: SQL Full text query too slow

I guess my question would be... why are you creating a full text catalog for EVERY VARCHAR in the table?
I'll also ask why you're using code that has been deprecated...
--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)

November 4, 2020 at 5:34 pm

#3804319
Reply To: Large objects data type issues

bobrooney.81 wrote:
Hi Jeff,
I still didn't understand in what type of pages will the LOB data get stored ? apart from 8k data page are there any other type of pages...
--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)

November 4, 2020 at 2:39 pm

#3804244
Reply To: I/O Statistics by file per database?

Why not just use sp_WhoIsActive for that stuff? It's free.
Like I said before, knowing which files are the most active won't tell you a thing about what your problems are...
--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)

November 3, 2020 at 9:14 pm

#3804032
Reply To: I/O Statistics by file per database?

My question would be... What do you expect to actually do with such information? It qualifies which files are the busiest but not why or whether or not being 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)

November 3, 2020 at 6:23 pm

#3803986
Reply To: The Separation of Tools

Eric M Russell wrote:
I can see why keeping SSMS and ADS separate, both in functionality and as an installation, would make sense at this point, because it's on-prem versus Azure.
However, I have...
--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)

November 3, 2020 at 4:52 pm

#3803952
Reply To: Large objects data type issues

Michael L John wrote:
Yeah. My bad. My brain and my fingers were not in sync. Thanks for correcting me.
Heh... NP. At least it wasn't me for a change. 😀 😀 😀
--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)

November 3, 2020 at 4:34 pm

#3803947
Reply To: Large objects data type issues

bobrooney.81 wrote:
As per my understanding, LOB data will also get stored inside the page. However , if the row data is exceeding 8000 bytes, then the data is stored off...
--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)

November 3, 2020 at 1:10 pm

#3803868
Reply To: Large objects data type issues

Michael L John wrote:
Jo Pattyn wrote:
7) Why are you still on 2017 RTM
Same question from me. As well as why are you still using an ntext data type? That was deprecated with SQL...
--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)

November 3, 2020 at 7:56 am

#3803794
Reply To: wildcard query of optimization

Lordy... some designer needs a serious pork chop lesson on the first rule of the First Normal Form. <facepalm>.
The only way you're going to be able to fix this for...
--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)

November 3, 2020 at 7:52 am

#3803793
Reply To: merge data

You're also running 2008, which is more than a decade old and hasn't been supported for years. I strongly recommend that you develop an upgrade plan.
--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)

November 3, 2020 at 3:42 am

#3803731
Reply To: A Getting Started PostgreSQL Tutorial

S. Kusen wrote:
What a time to be alive, Jeff! We all need to start branching out, I feel.
Heh... what a lot of people consider to be "branching out" is a bit...
--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)

November 2, 2020 at 9:40 pm

#3803660

Viewing 15 posts - 6,136 through 6,150 (of 59,089 total)