Viewing 15 posts - 4,426 through 4,440 (of 59,067 total)
Any help please?
If you want faster help in the future, please see the first link in my signature line below for one of many different ways to post "Readily...
October 22, 2021 at 7:10 pm
This looks like it might be used for the old and totally unsafe hack for "encrypting" SSNs and other critical numeric information. If it is, STOP! Do it correctly with...
October 22, 2021 at 7:04 pm
Replace all that with
SELECT FORMAT(GETDATE(),'yyyyMMddhhmmss')
You need to be really careful there. FORMAT is about 43 times slower than just about anything you might want to do with CONVERT. It's...
October 22, 2021 at 6:05 pm
Read up on OUTER joins. This will do it for you.
https://docs.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver15
SELECT p.ProjectId
,p.ProjectName
...
October 22, 2021 at 1:34 am
One of the things that I've been fascinated about for a while is how the camera software on our phones not only puts a box around human faces but also...
October 22, 2021 at 1:20 am
I have sql server 2005 and recently my tempdb is hitting the limits of the logical disk drive and cannot expand. It's usually about 1- 4 GB in size,...
October 21, 2021 at 9:45 pm
Thanks for the response, i was able to get the solution:
((CAST(Length AS Float)/12)*(16.33)) as Price
Thank you for the help.
You title said you were trying to cast to an INT. ...
October 21, 2021 at 9:41 pm
p.s. Using VARCHAR with no length is one of those code smells that you might want to avoid.
October 21, 2021 at 9:35 pm
You can cut out one of the REPLACEs. Look at format # 112.
October 21, 2021 at 9:31 pm
That's exactly the conclusion that I came to but had to ask. Thanks, Grant.
As a bit of a sidebar, long live xp_CmdShell! 😀
October 21, 2021 at 9:17 pm
Have any of you ever solved the problem of something in EE being used to easily identify and delete old files by session without having to jump through a flaming...
October 21, 2021 at 3:02 pm
So, the answer is "No". You don't know how to determine the code that is causing TempDB to grow.
October 21, 2021 at 1:25 am
I agree. I hope people don't read that and think it was the partitioning that did it though. It was the better index that did it. I also state that...
October 19, 2021 at 8:25 pm
We use enterprise edition.
Yes I think partitioning would be helpful for stats to run fast, but I did not see any performance improvements in the queries.
Normally, partitioning will actually...
October 19, 2021 at 3:54 am
Performance issues with maintenance tasks like update stats takes forever
This is SQL 2014, so we can have only 1 index on the table..
I tried implementing partitionning in dev,...
October 19, 2021 at 3:47 am
Viewing 15 posts - 4,426 through 4,440 (of 59,067 total)