Viewing 15 posts - 646 through 660 (of 7,472 total)
indeed that setting reverses.
btw the errorlog file is so polluted with SQLMI loggings of backups etc, and are not persisted over failovers
March 15, 2022 at 10:33 am
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
Viewing 15 posts - 646 through 660 (of 7,472 total)