Jeff Moden

Forum Replies Created

Viewing 15 posts - 691 through 705 (of 59,070 total)

Reply To: SQL server disk block size formatted as 4KB runs slow

ratbak wrote:
The closest I could find are this article from 2009 and this article from 2009
I'm still waiting for Scott to backup his claim with a link.
--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)

March 13, 2024 at 4:17 pm

#4394688
Reply To: has inline function got any catch?
rajemessage 14195 wrote:
do u want to say that we should not use begin end in inlined scalar functions?
No.
1. What I said was that Scalar and mTVF functions both use BEGIN/END 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)
March 13, 2024 at 1:38 pm

#4394617
Reply To: join

mtz676 wrote:
I have 1 record(1row*2columns) from 1 select
and
a different select which can result in multiple rows but will always have 3 columns.
How can I repeat the 1 row next 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)

March 12, 2024 at 4:21 pm

#4394088
Reply To: Oops! Apologies

Grant Fritchey wrote:
Great points. I wasn't even thinking about that at all. Happily, I haven't received so much as a finger wag for dropping the ball. I mean, Steve is going...
--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)

March 11, 2024 at 6:46 pm

#4393541
Reply To: SSIS error

Does you code actually look like what you posted? I ask because there is no space between the terms "SET" and "Processed_Flag" and there needs to be.
--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)

March 11, 2024 at 7:10 am

#4393178
Reply To: Table partitioning questions

sqlguy80 wrote:
I was asked to implement partitioning to improve performance and management.
We need to really emphasize what RatBak posted (re-quoted below)...
ratbak wrote:
Do not expect performance improvements for queries, inserts,...
--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)

March 11, 2024 at 6:41 am

#4393176
Reply To: has inline function got any catch?

rajemessage 14195 wrote:
hi,
I heard many people saying "functions are denounced in tsql" is there any catch?
q1) need to know what are the cases where we should not use?
q2) should we avoid...
--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)

March 11, 2024 at 6:28 am

#4393172
Reply To: find the number of values less than the current row

Interesting solutions, so far. Let's try one more...
First, let's simplify the code to make the readily consumable data. This is the best one of the better ways to post such...
--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)

March 11, 2024 at 3:54 am

#4393111
Reply To: query run time changes alot...why?
I'm thinking that the answer is somewhere in the Actual Execution Plans.
p.s. That's a major hint for what you might want to provide.
- This reply was modified 2 years, 3 months ago by Jeff Moden. Reason: Add p.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)
March 11, 2024 at 1:44 am

#4393073
Reply To: Assistants in the Age of AI

Robin Wilson wrote:
I was offered the help of a secretary once when I was getting around 350 emails per day so it was very hard to find the important emails mixed...
--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)

March 11, 2024 at 1:09 am

#4393054
Reply To: Will AI end with SQL, Is this the end of SQL?

The concept of AI in the picture near the end of the article is actually pretty grotesque, IMHO. Sex doll for both the body and the mind. Possibly the worst...
--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)

March 11, 2024 at 12:55 am

#4393053
Reply To: A Big SmallDateTime

Mark Dalley wrote:
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...
--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)

March 10, 2024 at 9:24 pm

#4393001
Reply To: A Big SmallDateTime

Michael L John wrote:
Mark Dalley wrote:
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in 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)

March 10, 2024 at 9:21 pm

#4393000
Reply To: SQL server disk block size formatted as 4KB runs slow

ScottPletcher wrote:
The *data* file drives should be 64K. Log file drives should still be 4K. If you mix data and log files on the same drive, you'll want to use...
--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)

March 7, 2024 at 6:07 am

#4391071
Reply To: SQL Server Count Query

sathishkm wrote:
Hi All,
I have a data in column A in where in need to achieve the count which I have mentioned in column B. Please find the attached excel dataset...
--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)

March 7, 2024 at 6:00 am

#4391065

Viewing 15 posts - 691 through 705 (of 59,070 total)