Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,746 through 2,760 (of 59,098 total)

Reply To: how to remove schemabinding from all functions and view in one go.

Jason A. Long wrote:
Jeff Moden wrote:
Since the OP never came back on this, let me be a bit more succinct... it's STUPID to do this without knowing the ramifications it will have...
--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)

September 16, 2022 at 8:02 pm

#4088651
Reply To: how to use Space or Tab :b Matches either space or tab characters.

drew.allen wrote:
Jeff Moden wrote:
The key here is to realize the misnomer. What you find in SSMS is NOT a full version of RegEx. I'm not sure it even qualifies as 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)

September 16, 2022 at 4:31 pm

#4088588
Reply To: Need TABLE DDL to define finite list of column values

Express12 wrote:
thx all -- for your valuable feedback. Ed B, exactly what I was looking for! thank you.
While there's likely no better way to do this, the trouble with something...
--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)

September 16, 2022 at 2:33 pm

#4088556
Reply To: how to remove schemabinding from all functions and view in one go.

Since the OP never came back on this, let me be a bit more succinct... it's STUPID to do this without knowing the ramifications it will have for each...
--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)

September 16, 2022 at 2:25 pm

#4088542
Reply To: MDF size increasing without table size increase

You never came back with answers to my questions about the "autogrow" settings and version of SQL Server. Did you ever get this issue figured out?
Fast Inserts Issue?
If it's still...
--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)

September 16, 2022 at 2:20 pm

#4088540
Reply To: how to use Space or Tab :b Matches either space or tab characters.

The key here is to realize the misnomer. What you find in SSMS is NOT a full version of RegEx. I'm not sure it even qualifies as a valid subset.
--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)

September 15, 2022 at 6:54 pm

#4088249
Reply To: Tsql batch script does not stop
In the following snippet of your code, tell me why it won't just update the same 4999 rows forever?
```
--Update the BankName and BankBranch value in temp table
Declare...
```
--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)
September 15, 2022 at 5:48 pm

#4088225
Reply To: i have to increase the size of all my stored procedure's varchar

frederico_fonseca wrote:
to use UTF8 in SQL 2019 NVARCHAR is not required (see https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16#Unicode_Defn) - but increasing the size of the existing varchar MAY be required.
have a look at https://techcommunity.microsoft.com/t5/sql-server-blog/introducing-utf-8-support-for-sql-server/ba-p/734928
Oooooooo... thank...
--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)

September 15, 2022 at 2:43 pm

#4088126
Reply To: how to use Space or Tab :b Matches either space or tab characters.

rajemessage 14195 wrote:
hi,
from this link https://docs.microsoft.com/en-us/sql/ssms/scripting/search-text-with-regular-expressions?view=sql-server-ver16
i found :b matches either space or tab charcters , pls tell me how to use. i used but it was not working.
We have no idea...
--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)

September 15, 2022 at 2:30 pm

#4088121
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

Thanks for the feedback, Thomas. I'll have to leave that up to the individual user because, although close, UNIX TimeStamps are not quite the same as UTC even if people...
--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)

September 15, 2022 at 2:05 pm

#4088111
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?

And, my apologies... I left left the "K' off the 120 above (just fixed in my original post above) but that's still a long way away from the millions 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)

September 14, 2022 at 10:02 pm

#4087834
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?

Here's another good one... the Op recently marked an answer as accepted on the other thread and said nothing on this one. Fun, eh?
It would likely be faster still if...
--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)

September 14, 2022 at 9:07 pm

#4087818
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?

Jason A. Long wrote:
Jeff Moden wrote:
Jason A. Long wrote:
I suspect that the bulk of the cost is coming from the sort operation in the STRING_AGG() function. And assuming that sort is necessary to meet requirements,...
--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)

September 14, 2022 at 8:50 pm

#4087817
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?

Jason A. Long wrote:
I suspect that the bulk of the cost is coming from the sort operation in the STRING_AGG() function. And assuming that sort is necessary to meet requirements, that same...
--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)

September 14, 2022 at 7:39 pm

#4087802
Reply To: Are the posted questions getting worse?

Removed what's probably an inappropriate rant based on extreme frustration.
--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)

September 14, 2022 at 7:31 pm

#4087800

Viewing 15 posts - 2,746 through 2,760 (of 59,098 total)