Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,256 through 3,270 (of 59,067 total)

Reply To: explicite alternative to FORMAT() concerning DATE

Zidar wrote:
Q: Sorry, but I'm not seeing it. How would such a thing be used to improve the performance of the query the OP posted?
Valid point, chances are good it...
--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)

June 26, 2022 at 9:23 pm

#4055271
Reply To: Shared Work Spaces: Hell, Heaven, Both?

Ohhh... no extended comment from me... none of it would pass HR. Let's just say that "I'm lovin' the lockdown" and seriously enjoy working remotely on all fronts.
--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)

June 26, 2022 at 8:57 pm

#4055270
Reply To: Interview question to test beginner SQL competency?

Sounds like a prelude to spam... why would anyone in their right mind try to take an average on such an identifier column? Really bad question and, since you say...
--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)

June 26, 2022 at 5:35 pm

#4055241
Reply To: T-SQL : Slicing time Islands and gaps

One of the fastest methods ever created for doing this type of thing is documented in the following article.
https://blogs.solidq.com/en/sqlserver/packing-intervals/
It's an older article so solution #3 can be made work 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)

June 26, 2022 at 5:17 pm

#4055239
Reply To: how to remove duplicate rows in sysobjvalues

This was an interesting subject that I'd not heard of before. I checked and found the following article by Paul Randal. What most interesting is his answer to one 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)

June 26, 2022 at 4:32 pm

#4055227
Reply To: how to remove duplicate rows in sysobjvalues

Just out of curiosity sake, can you post the entire CREATE UNIQUE INDEX statement you were running to get this error?
--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)

June 26, 2022 at 4:17 pm

#4055226
Reply To: SQL Server 2016 SP3?

Matthew145 wrote:
Looking for a close to issue. Expecting more reply.
Be advised that your post looks and smells like a precursor to spam, especially considering your other replies, which hadspam links...
--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)

June 26, 2022 at 1:17 am

#4054993
Reply To: Creating index for a very huge table

Jonathan AC Roberts wrote:
With a table of that size it might be better to look at partitioning the table.
Heh... yeah... but you'd first have to rebuild the index to partition it. 😀
--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)

June 26, 2022 at 12:05 am

#4054975
Reply To: Creating index for a very huge table

JasonO wrote:
My developer recently execute an index creation job...
Just exactly what does that "job" consist of?
And, yes... there's a way to do this (I do it all the time) 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)

June 24, 2022 at 7:38 pm

#4054550
Reply To: Strange Write Statistics

VastSQL wrote:
Hi Experts,
I ran the below query and for a table I am getting very high writes and its increasing every second. The table here is a master table which...
--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)

June 24, 2022 at 7:27 pm

#4054547
Reply To: How to get creole language

krypto69 wrote:
thanks sir - kinda figured that !
Heh.. I wouldn't use the "current logic"... it uses some pretty slow RBAR. Use DelimitedSplitN4K, instead.

--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)

June 24, 2022 at 7:19 pm

#4054543
Reply To: How much memory is allocated when you UNION ALL?

Scott-144766 wrote:
If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run all the individual queues in one, or will it make...
--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)

June 24, 2022 at 1:21 am

#4054118
Reply To: explicite alternative to FORMAT() concerning DATE
Zidar wrote:
Since Tally Table of dates was mentioned, here is how to construct it:
1. create fnTally - table of numbers, by Jeff Moden, here https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally
2. use the function 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)
June 24, 2022 at 1:17 am

#4054117
Reply To: How to avoid using operator when there are different values on two tables ?

jimmyblack21 wrote:
To compare data by using the New Data Comparison Wizard On the SQL menu, point to Data Compare, and then click New Data Comparison Identify the source and target...
--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)

June 24, 2022 at 1:07 am

#4054115
Reply To: How to avoid using operator when there are different values on two tables ?

wrote:
Using joins to compare columns by priority among the table. For example, left join returns all values from the first table and null value for the not-matched records from...
--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)

June 24, 2022 at 12:19 am

#4054100

Viewing 15 posts - 3,256 through 3,270 (of 59,067 total)