Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,366 through 4,380 (of 59,087 total)

Reply To: How to learn SQL?

Michael L John wrote:
These are MySQL forums https://forums.mysql.com/
As a bit of a side bar, I just took a look at that. It's quite extensive but, lordy... try scanning all 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 6, 2021 at 7:31 pm

#3948677
Reply To: SQL query help

jcelko212 32090 wrote:
Since the table is an unordered set, the concept of a previous record doesn’t apply in SQL.
That's not actually true but, even if it was, the logical selection...
--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 6, 2021 at 7:26 pm

#3948675
Reply To: How to get Feature Name and Feature Value separated by $ for table AllData ?
I was careful to preserve as much of the original code as possible and to document this as well as the original code was. 😉
```
UPDATE Codes
 ...
```
--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 6, 2021 at 7:08 pm

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

ScottPletcher wrote:
Jeff Moden wrote:
As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?
I'm not sure which specific "problem" you're referring to.
The one below,...
--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 6, 2021 at 3:12 pm

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

Viewing 15 posts - 4,366 through 4,380 (of 59,087 total)