Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 59,069 total)

Reply To: How to solve this

I've got to ask, as well. Why the requirement of doing the transfer with (ugh!) XML? That is, quite possibly, the absolute slowest and "pipe heavy" method that you could...
--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 1, 2021 at 2:13 pm

#3946719
Reply To: How to convert int primary key to uniqueidentifier

Sorry... posted in the wrong spot. Deleted this post.
--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 1, 2021 at 2:04 am

#3946515
Reply To: How to convert int primary key to uniqueidentifier

UPDATE:
Like the rest of the world, I had been duped into thinking that Random GUIDs are bad. The two most cited reasons are that they're 4 times bigger than an...
--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 1, 2021 at 2:00 am

#3946514
Reply To: Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

alen teplitsky wrote:
Has anyone done this on servers with numerous applications accessing them? How do you handle applications slowing down due to the loss of indexes? And how does Always On...
--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)

October 31, 2021 at 11:19 pm

#3946493
Reply To: Recursive Query to get get diff between two rows for same client

Ah.... sorry.... What do you want the output to look like for the test data you provided? I ask because you have multiple clients and you've not identified what you...
--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)

October 30, 2021 at 1:58 am

#3946160
Reply To: Recursive Query to get get diff between two rows for same client

Heh... you really should trying running your own code before you post 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)

October 30, 2021 at 1:44 am

#3946159
Reply To: Replace Numbers

Steve Collins wrote:
A numbers splitter is a really nice solution. I thought the question was already answered. What else could be done with a numbers splitter?
Converting Integers that look like dates...
--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)

October 30, 2021 at 1:30 am

#3946157
Reply To: what this constrain meaning ?

To summarize what Thom has so correctly stated, it's "DEI", which stands for "Declared Entity Integrity" and, along with "DRI" (Declared Referential Integrity), it forms the backbone of what properly...
--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)

October 30, 2021 at 12:36 am

#3946147
Reply To: Importance of Community

Y.B. wrote:
I almost forgot about that Jeff. I've always wanted to contribute more but I always feel like someone else has already done it better. Besides, in the example 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)

October 29, 2021 at 11:49 pm

#3946143
Reply To: What ate all my DB resources?

Without the queries that caused the CPU to stick to the ceiling, there's really no way to help here.
I will tell you that if you didn't do your inserts 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)

October 29, 2021 at 11:04 pm

#3946134
Reply To: Update table FirstName & LastName from Email addresses

DaveBriCam wrote:
What is the code for the function DelimitedSplit8K?
\
If you'd like to learn more about it, there's a whole article on it.
https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function
--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)

October 29, 2021 at 10:43 pm

#3946131
Reply To: Recursive Query to get get diff between two rows for same client

If you'd post some readily consumable data, that would help us help you with an answer. See the first link in my signature line below for one of many ways...
--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)

October 29, 2021 at 10:38 pm

#3946130
Reply To: Recursive Query to get get diff between two rows for same client

Tallboy wrote:
Thanks for your quick reply at the moment is on sql server 2008r2, so it doesnt have LAG I think...
You posted in a 2019 forum. 😉
--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)

October 29, 2021 at 10:37 pm

#3946129
Reply To: TSQL: Create dynamic partition DataRange

Lidou123 wrote:
Hello @jeff Moden and @jonathan-2 .
Thank you for your help.
I will test this solution too.
Thank you for the feedback, Lidou
--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)

October 29, 2021 at 10:32 pm

#3946128
Reply To: Printing Strings Longer Than 8000 Characters

RonMexico wrote:
No luck with the results to file. Thanks for the help though
Perhaps BCP from a LOB column to a file?
--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)

October 29, 2021 at 10:30 pm

#3946127

Viewing 15 posts - 4,396 through 4,410 (of 59,069 total)