Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 59,098 total)

Reply To: Query runs slow sometimes and sometimes runs superfast (2 minutes vs 2 seconds)

skb 44459 wrote:
But still cant figure out why its very slow at times.
It's probably because the triggers that feed it are written incorrectly as some form of dynamic SQL that materialize...
--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, 2021 at 7:10 pm

#3948469
Reply To: How to retrieve a number in range that matches another number
Here's one simple way. It'll really help things if you have an index on the TimeInterval column.
```
DECLARE @InputParameter [decimal](15, 6) = 691195
;
 SELECT TOP 1 *
 ...
```
--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, 2021 at 6:48 pm

#3948464
Reply To: Database Corruption - LOB

You should play the lottery tonight. 😀 You just proved that you're one of the luckiest people on the whole planet. 😀
With that (and I know you get it but...
--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, 2021 at 6:32 pm

#3948463
Reply To: SSRS reports that use a data component

Rod at work wrote:
Jeff Moden wrote:
Understood but that's not my question. To be more clear, you stated that...
I'd rather write components in a project written in C# that yield the results that...
--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, 2021 at 5:55 pm

#3948451
Reply To: Review Ola hallengren indexoptimize parameters

frederico_fonseca wrote:
regarding reorganize - there is an exception to this - if you have columnstore indexes that are frequently subject to deletions or that are subject on inserts in small...
--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, 2021 at 5:52 pm

#3948449
Reply To: Review Ola hallengren indexoptimize parameters

That's the gist of it. If you have indexes where logical fragmentation actually does matter for large range scans, you might want to include those but, again, that's going 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 5, 2021 at 4:53 pm

#3948429
Reply To: New Index Maintenance Methods Recommended by Microsoft

As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?
--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, 2021 at 4:42 pm

#3948423
Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Jeff Moden wrote:
You're presuming an awful lot. Why would you want "at least 2 files per filegroup" for a single table?
To spread the I/O out, the typical reason 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 5, 2021 at 4:41 pm

#3948422
Reply To: Identify INT,BIGINT,character in stored proc

thbaig wrote:
now I am not discarding wrong data , but sending it back in output.
Ah... that's the ticket. Thanks for taking the time to explain. I was really concerned about...
--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, 2021 at 3:52 pm

#3948394
Reply To: Best practice to store - How many days, minute and second ?

Adelia wrote:
Jeff Moden wrote:
Adelia wrote:
Thanks to all
Adelia,
Don't go yet. I asked you some questions about datatypes that you've not answered yet. If you let me know that the datatypes of 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)

November 5, 2021 at 3:39 pm

#3948389
Reply To: Review Ola hallengren indexoptimize parameters

@databases nvarchar(max)='USER_DATABASES'
@FragmentationLow nvarchar(max) = NULL, /* don't defrag low fragmented */
@FragmentationMedium nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', /* left out index_reorganize because of https://www.sqlservercentral.com/forums/topic/rebuilding-and-reorganizing-indexes/page/2/?bbp-ajax=true */
@FragmentationHigh nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 int = 30, /* threshold medium...
--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, 2021 at 3:16 pm

#3948381
Reply To: Review Ola hallengren indexoptimize parameters

Ah... sorry. Looking back at the original post, I see that REORGANIZE was left out. That's ok... it's still worth mentioning for other people that may read this thread.

--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, 2021 at 1:48 pm

#3948336
Reply To: Review Ola hallengren indexoptimize parameters

Yes. Do not use REORGANIZE. It doesn't work the way you think it does. It's so bad on indexes that fragment that it's actually the cause of the myth 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)

November 5, 2021 at 1:46 pm

#3948335
Reply To: AWS RDS - MS Sql server

I don't know about those stored procedures and can't help there.
Of a much larger concern, suppose you want to restore just one database? Go check the documentation on that. IIRC...
--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, 2021 at 4:35 pm

#3947971
Reply To: New Index Maintenance Methods Recommended by Microsoft

You're presuming an awful lot. Why would you want "at least 2 files per filegroup" for a single table?
Also, I can see some instances where you might have specific reason...
--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, 2021 at 4:26 pm

#3947962

Viewing 15 posts - 4,381 through 4,395 (of 59,098 total)