Viewing 15 posts - 4,411 through 4,425 (of 59,067 total)
@Y.B. Thanks for the awesome compliment on the articles but neither they nor I made you look like a rockstar. I'm seriously honored that you cited me and them but...
October 27, 2021 at 11:05 pm
Hi Team,
I am retrieving files and file created date and file modified date from table based on the created date. All files are same file name. My output is...
October 26, 2021 at 8:39 pm
First of all, if you've done a REBUILD on an index and you very quickly exceed 30% logical fragmentation, then you're ACTUALLY CREATING A PERFORMANCE ISSUE and it can be...
October 26, 2021 at 8:35 pm
While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀
Don't worry I'm sure it's just...
October 26, 2021 at 12:28 am
Jeff Moden wrote:Nice function, Jonathan. Well done!
Thank you Jeff, that's a great compliment coming from someone as experienced as you.
I just used the function to hammer out a solution to...
October 26, 2021 at 12:02 am
Let's try something a wee bit different and let's use a really nice tool written exactly for this type of thing. The tool was written by Jonathan Roberts, is a...
October 26, 2021 at 12:01 am
Great article but, having been there and done that, be REALLY careful that you don't (as my Grandmother used to say) "Jump from fat to fire" (reference to a cast...
October 25, 2021 at 9:09 pm
While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀
October 25, 2021 at 6:09 pm
The big thing for partitioning for me has nothing to do with queries. As Grant indicates, partitioning almost never improves performance. Even so called "partition elimination" is usually slower than...
October 25, 2021 at 5:56 pm
SQL2005 doesn't have XE!
Check your default trace file or run a trace to figure it out !
Ah... thanks, Johan. Shows how much I use EE.
The problem with using...
October 25, 2021 at 12:23 pm
Thank you for the great feedback and the quote from BOL.
Now if we could get the OP to cough up the reason for wanting to do this task. 😀
October 24, 2021 at 6:30 pm
This is getting the data I need, but not the format.
select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','')
10212021102437
I want YYYYMMDD before the time portion.
Thanks.
Just out of sheer curiosity, why do you...
October 23, 2021 at 10:26 pm
A lot of the methods posed so far do the job but are actually relatively slow because of all the string manipulation using both concatenation and REPLACE. Using a nice...
October 23, 2021 at 7:33 pm
My goal is to replace the numbers 1-9 in a column with a different number. For this example the numbers would change to
1=7
2=3
3=9
4=1
5=4
6=2
7=5
8=6
9=8
I tried using the replace function shown...
October 23, 2021 at 5:44 pm
p.s. Using VARCHAR with no length is one of those code smells that you might want to avoid.
It would default to varchar(30) , but still to wide for...
October 23, 2021 at 5:37 pm
Viewing 15 posts - 4,411 through 4,425 (of 59,067 total)