Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,731 through 2,745 (of 59,086 total)

Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
Thank you for the kind feedback and the functions, Eirikur.
Perhaps I'm using the function incorrectly but try the following (and, if so, please let me know)...
```
 SELECT...
```
--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 19, 2022 at 11:22 pm

#4089586
Reply To: Find replace using regular expressions

wrote:
Jonathan AC Roberts wrote:
I would use an SSMS add-in like ApexSQL Refactor.
There is a free version of it here https://en.free downloadmanager.org/Windows-PC/ApexSQL-Refactor-FREE.html
I think you only get a trial period with...
--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 19, 2022 at 2:54 am

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

Jason A. Long wrote:
Jeff Moden wrote:
2. That kinda makes me want to build a query that recursively uses sys.sql_expression_dependencies joined sys.sql_modules to find all schema binding objects that are binding an object and...
--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 19, 2022 at 2:38 am

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

Viewing 15 posts - 2,731 through 2,745 (of 59,086 total)