Viewing 15 posts - 2,521 through 2,535 (of 59,067 total)
I need to add a single quote in each of the alternate characters. The input string could be a variable length.
As an example:
Input String: 5,1,6,1,69,1
output: '5',1,'6',1,'69',1
Input String: 5,1,6,1,3,2,5,3,69,1
output: '5',1,'6',1,'3',2,'5',3,'69',1
If...
November 2, 2022 at 10:44 pm
A part of the reason why I love my job is... they're all fun! My "favorite" was figuring out a way to display the page density of indexes as a...
November 1, 2022 at 5:14 pm
Hi guys I hope everything's ok with all of you
I have this example to do it in SQL. I want all characters after the space between. like this
October 31, 2022 at 8:58 pm
indeed, Jeff
Sorry, Johan... I'm not sure how to take that. To be sure, it wasn't meant as an insult to anyone (especially you). You hit the nail on the...
October 27, 2022 at 9:35 pm
My question now is... how do you intend to use this new table? There are a few ways and a lot of people get into trouble because there's only a...
October 27, 2022 at 7:48 pm
Generate your dates and then play the following function against those dates using "3" as an @DateFirst parameter. Post back if needed.
The dates don't need to be contiguous. You could...
October 27, 2022 at 6:12 pm
The flow chart at the following MS link identifies where to find all the steps based on your configuration.
The main article that came from is at the following.
You just need...
October 27, 2022 at 6:06 pm
But this returns the total number of read and writes from the start.
So use LAG to find the difference between the current reading and the previous reading to find...
October 27, 2022 at 5:50 pm
sys.dm_io_virtual_file_stats returns data since last startup of SQLServer.
To get what you aim for, you should persist its data yourself.
By itself that data means nothing at all.
It's only use...
October 27, 2022 at 5:48 pm
It could also be that that data isn't being deleted in the same order as the Clustered Index. If that's true, you can recover the space left by the deletes...
October 27, 2022 at 5:24 pm
Something like this using a tally table or function:
DECLARE @startDate date = '2021-01-06'
DECLARE @nextYear date = DATEADD(year,1,DATEADD(year,DATEDIFF(year,0,@startDate),0));
SELECT DATEADD(WEEK,Number,@startDate ) AS StartDate, DATEADD(DAY,6,DATEADD(WEEK,Number,@startDate )) AS EndDate,...
October 27, 2022 at 5:15 pm
Hello, I want to be able to view the number of read and writes for a database or (tables in the database) in a day or week or month....
October 26, 2022 at 7:05 pm
Often a project has multiple customers and multiple perspectives. A developer trying to satisfy an external customer, might prioritize that party over an internal customers like a DBA. Time...
October 26, 2022 at 7:00 pm
Excellent article, ...
I absolutely love it when the challenge at hand requires a graceful and carefully engineered solution, but I also find it gratify to simply craft something...
October 25, 2022 at 6:58 pm
Viewing 15 posts - 2,521 through 2,535 (of 59,067 total)