Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,541 through 6,555 (of 59,091 total)

Reply To: What is XE_SERVICES_RWLOCK and why am I seeing it so much?

Ah, sorry, Jason. I should have known better just because it's you. And I saw the post from SQLSkills right at the top and made the sorry mistake of assuming...
--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)

August 26, 2020 at 10:14 pm

#3783943
Reply To: Of Hedgehogs and Database Design

hmbacon wrote:
It seems to me some leaders incorrectly use Agile to rationalize skipping design.
And a whole lot more "SQL sins" like no documentation, little testing until it hits prod, nasty...
--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)

August 26, 2020 at 10:12 pm

#3783942
Reply To: What is XE_SERVICES_RWLOCK and why am I seeing it so much?

I found plenty about it and what it is...
https://www.google.com/search?q=XE_SERVICES_RWLOCK
--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)

August 26, 2020 at 8:40 pm

#3783921
Reply To: find group of time

sharon-472085 wrote:
thank you vary much 🙂
next time not lazy:)
😀
Sorry... my reference was about creating readily consumable data. You can see one way to do that in the article at 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)

August 26, 2020 at 5:55 pm

#3783857
Reply To: Best place to find SQL Server Consultants

Mysterio wrote:
Thank you for both of your answers.
To provide a bit more context: I am looking at someone who is an absolute expert in data modelling creating very efficient 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)

August 26, 2020 at 5:24 pm

#3783840
Reply To: find group of time

sharon-472085 wrote:
hi all,
i have the follwing table : 10 lines
i want to show only row after 30 second (should be paramter :)) between them. ( as summery of previous records)
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)

August 26, 2020 at 2:14 pm

#3783781
Reply To: find group of time

ktflash wrote:
For those are too lazy to copy paste for testing, added 2nd Colum for True False:
You should speak to the OP about the "lazy" thing. 😉
--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)

August 26, 2020 at 2:03 pm

#3783768
Reply To: How to dynamically create a table in SQL from a Excel file using SSDT

p.s. And, no... this process doesn't use "SSDT", "SSIS", or any of the other 4 letter words in SQL Server. It's all done in T-SQL and it runs very quickly. ...
--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)

August 26, 2020 at 1:51 pm

#3783760
Reply To: How to dynamically create a table in SQL from a Excel file using SSDT

Awesome. I have a totally automatic solution for that that will also auto-magically adjust for new columns, deleted columns, new spreadsheets, etc. The key is that it auto-magically maps 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)

August 26, 2020 at 1:50 pm

#3783759
Reply To: Calling Procs from PowerShell with Parameters

frederico_fonseca wrote:
Jeff Moden wrote:
Other that creating a parameter table the job reads from, I don't know anyone else that has been able to do it either.
out of curiosity what did 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)

August 25, 2020 at 10:45 pm

#3783511
Reply To: How to dynamically create a table in SQL from a Excel file using SSDT

Nelson B wrote:
If needed I can provide examples of the excel files.
This can be done but I need to have a look-see... Attaching a couple would be a big help.
Of course,...
--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)

August 25, 2020 at 7:28 pm

#3783476
Reply To: Replace cpecial characters from SharePoint

PSB wrote:
Hi,
Thanks for the solution. It works as expected. Just noticed the main table has an extra space at the beginning of each 1st value. How do I change 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)

August 25, 2020 at 7:06 pm

#3783474
Reply To: Replace cpecial characters from SharePoint
Brahmanand Shukla wrote:
Try this.
SELECT Original
,Cleaned = REPLACE(Original,';#',', ')
FROM #ReplaceCharacters
;
Ah, careful now... 😉 It doesn't produce what the OP wanted. Instead, it includes a leading comma on all...
--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)
August 25, 2020 at 6:19 pm

#3783446
Reply To: Trigger on View

adisql wrote:
But my actual goal is , if the record insert into the underlying table then same record will be insert into the other table.
But the trigger should be 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)

August 25, 2020 at 4:52 pm

#3783413
Reply To: string compare again .. :)

Alan Burstein wrote:
Jeff Moden wrote:
Agreed. I said similar in this post from above...
I missed this.
The difference is that I did the split using an indexed view. This way the split only happens...
--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)

August 25, 2020 at 12:26 am

#3783108

Viewing 15 posts - 6,541 through 6,555 (of 59,091 total)