Viewing 15 posts - 1 through 15 (of 2,444 total)
too many things to consider in order to say if there is a more efficient way - depends on volumes and number of times it is executed as well if...
April 25, 2024 at 10:55 pm
works fine with a few caveats
performance impact will depend on your activity and server spec - bad server with lots of activity and it will be noticeable.
using a custom view/proc...
April 25, 2024 at 10:27 pm
your problem is that your "ltrim" is on the wrong place, and the string compare inside does not find the required matches)
following works
drop table if exists #employee
CREATE...
April 25, 2024 at 10:21 pm
you have 2 issues to address.
1 - if your destination datatype is a date then your variable assignment needs to cast it as a datetime, not as a string -...
April 24, 2024 at 5:56 pm
you most likely have the Azure agent still active on your server (these are installed by default on the azure vm's depending on how they are created - or on...
April 24, 2024 at 12:15 pm
Hello all,
I would like to create an INSERT statement and use a UDF as part of the VALUES() set. The UDF generates a unique product code based on the
April 24, 2024 at 9:27 am
search these forums for PIVOT or CROSSTAB queries and you will find a few answers - google also has plenty of examples.
then get back to us with issues if any...
April 23, 2024 at 12:19 pm
I am trying to set a date filter on several large transaction tables to limit the years loaded.
When I use a hardcoded filter like:
DATEFROMPARTS ( DATEPART(yyyy, GETDATE()) - 4,...
April 22, 2024 at 10:38 am
when I do listen (mostly when working late hours on projects) is this one https://www.mixcloud.com/ovat83/best-90s-megamix-2hour-party-mix-track-select-list-available-in-description/
not quite what most would listen to "smooth" the spirit
April 22, 2024 at 9:30 am
being VMWare I would speak with the team that maintains it and check config of new vm vs old - as well as server specs itself.
things to look at
April 18, 2024 at 10:35 pm
similar hardware does not mean similar performance - so I would check those.
you say they are VM - details? onprem, cloud, vendor (AWS, MS, VMWare) - VM type if cloud
Disks...
April 18, 2024 at 2:46 pm
substring vs like is only "better" if the like contains a wildcard at the start of the string.. e.g. like '%abc%'
on the case above both substring and like will do...
April 16, 2024 at 12:06 pm
Somewhere I found that substring is not necessary, when you compare 2 values from tables, and one of the values has just 10 symbols, and the other has more...
April 16, 2024 at 10:53 am
one other thing that can cause differences is the timezone of the server and the time /day the job runs on the server.
April 15, 2024 at 2:59 pm
Viewing 15 posts - 1 through 15 (of 2,444 total)