Viewing 15 posts - 676 through 690 (of 7,501 total)
Have a look at my little article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"
March 9, 2022 at 7:29 am
Thank you for the feedback!
March 3, 2022 at 7:06 am
and kick the designer in a place where it hurts ...
February 28, 2022 at 1:56 pm
It is a best practice to follow up on SP & CU for your sqlserver version. Especially inspect for issues you experience.
Here's a prep list I found on one of...
February 25, 2022 at 1:12 pm
The biggest down side of an in-place upgrade is that is keeps things working, hence it may leave fixed issues open to keep it working with the settings of SQL2008.
That...
February 23, 2022 at 11:56 am
I would make sure to have my SQL2019 upgraded to one of the most recent CU's !
February 22, 2022 at 10:13 am
have a look at CharIndex
/* from https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql */
DECLARE @document VARCHAR(64);
SELECT @document = 'Reflectors are vital safety' +
...
February 21, 2022 at 12:28 pm
What queries have you tried out yourself?
February 21, 2022 at 8:25 am
well ... actually ... a couple of months ago I got my IoT thermostat (Netatmo) because it regulates my temperature way better than me due to its learning mode.
However, I...
February 18, 2022 at 9:35 am
Spot on, Jeff !
The main point for people to prefer varchar over char is that their GUI development tool doesn't have to bother with trailing spaces.
Lordy. I understand...
February 17, 2022 at 12:27 pm
Moving the fetch next statement fixed my issue.
Thank you!
aaaand .... you missed the most important message !
You may have fixed this little issue, but you are still using a...
February 17, 2022 at 6:59 am
Why do you want to use a cursor to do this.
Think SET !
you are using 3part naming to address the new matchcode object, remove "USE [test]" before statement INSERT INTO...
February 16, 2022 at 6:50 pm
Write better code and you might be surprised just how scalable your system proves itself to be.
Spot on! (no matter the chosen technology)
February 16, 2022 at 8:59 am
Alternatively have a look at "Get packages from SSIS Catalog"
it uses Powershell to download the packages
February 14, 2022 at 1:29 pm
It was an error while creating the temp tbl. this is resolved after I removed the [AccountKey] from insert.
Temp tbl improved the performance in my scenario.
You should have removed...
February 14, 2022 at 7:28 am
Viewing 15 posts - 676 through 690 (of 7,501 total)