Jeff Moden

Forum Replies Created

Viewing 15 posts - 211 through 225 (of 59,095 total)

Reply To: Generate number fields

It's actually got a name for that type of process... "Relational Multiplication". The code that Des Norton wrote above will absolutely do the trick. It's also known as a "Cartesian...
--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)

January 23, 2025 at 2:27 am

#4521291
Reply To: Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

I don't have any help to offer because I don't build CLRs on our systems and so have zero experience there.
As a bit of a sidebar, though, what does your...
--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)

January 21, 2025 at 5:22 pm

#4520132
Reply To: Getting blockage on Update Statement

I don't have the links for them but I've recently read a few articles that say the turning off page locking for the table did the trick nicely for them. ...
--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)

January 21, 2025 at 5:08 pm

#4520125
Reply To: Proc cache slowly decreasing in size until restart is required

Like I said on the other thread with the identical name (Note: there is zero need to double post on this forum)...
This sounds like either a "Connection Leak" or a...
--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)

January 20, 2025 at 5:37 am

#4518904
Reply To: Proc cache slowly decreasing in size until restart is required

This sounds like either a "Connection Leak" or a "Memory Leak". A "Connection Leak" is where no connection is ever closed and everyone gets a new connection (which take memory)...
--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)

January 20, 2025 at 5:34 am

#4518902
Reply To: SQL Query to use in MS SSRS server to give you your report structure.

I agree... great post but it should be an article.
I also add...
6. While even Microsoft hasn't followed suit, NOT using semi-colon terminators has been deprecated since 2005 came out.
7. Both...
--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)

January 20, 2025 at 4:16 am

#4518874
Reply To: search text files for multiple keywords

Jeff Moden wrote:
Bruin wrote:
Any suggestions or help..
Many thanks.
I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...
https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2
I'm not...
--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)

January 20, 2025 at 3:46 am

#4518871
Reply To: search text files for multiple keywords

Bruin wrote:
Any suggestions or help..
Many thanks.
I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...
https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2
I'm not testing...
--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)

January 20, 2025 at 3:40 am

#4518870
Reply To: Article Review

frederico_fonseca wrote:
not me (and many of the prior replies are trolls I believe)
Thanks for the reply, Frederico.
I don't know about folks being "trolls" but I've never seen anywhere on this...
--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)

January 20, 2025 at 2:35 am

#4518847
Reply To: Temp table security

The SQL Server documentation says that "global temporary tables are visible to all sessions" and it doesn't seem to identify a work around. That also means that you cannot assign...
--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)

January 19, 2025 at 5:23 am

#4518474
Reply To: Article Review

I'm curious... have any of you that said that you'd be happy to do reviews of articles ever been asked to do an article review?
--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)

January 16, 2025 at 10:09 pm

#4517163
Reply To: Temp Tables not clearing

It's better to NOT drop TempTables. The "schema" can be reused even though they go out of scope and "disappear" at the end of each session.
--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)

January 16, 2025 at 10:06 pm

#4517162
Reply To: Help with parent/child query please

This is a parent/child list. There's a whole lot more that can be done with it if it's recognized for what it can do including but not limited to "Nest...
--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)

January 16, 2025 at 9:32 pm

#4517158
Reply To: How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

Wouldn't it be nice if Microsoft finally figured out that there's been math co-processors built into CPU chips since the mid-'90's??? Even the decimal datatype had issues with resetting 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)

January 13, 2025 at 5:24 pm

#4514872
Reply To: Using ROW_NUMBER() to increment every time a value occurs

Just so people can play if they want, here's all the code I played with.
My findings are that if you can have a Clustered Index on the RowNumber column 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)

January 12, 2025 at 1:52 am

#4514011

Viewing 15 posts - 211 through 225 (of 59,095 total)