Viewing 10 posts - 1 through 10 (of 10 total)
My recommendation would be SQL Server 2019 at this point. It is at CU16 at present and this is important. For more than 8 years it has been my practice...
April 21, 2022 at 11:52 am
You are fine with SQL Server 2017 -- https://docs.microsoft.com/en-us/lifecycle/products/sql-server-2017. October 2022 is end of mainstream support. Extended Support is October 12, 2027.
https://www.brentozar.com/archive/2019/01/which-version-of-sql-server-should-you-use/ is worth reading on...
February 17, 2022 at 1:51 pm
I would run the query with 'SET Statistics IO ON' and run the query with the actual execution plan. Chances are the execution plan will give you a missing index...
January 29, 2021 at 4:49 pm
I got the 50000 error also on a SQL Agent Job. In my case Step 2 | Advanced | On success action drop down was 'Quit the job reporting failure'. ...
November 29, 2018 at 8:18 am
My largest database is 1.6 TB and it takes 84 minutes for a full database backup.
The database is a content management database, Columbiasoft Document Locator, so the majority...
June 4, 2018 at 10:25 am
It has now been a good 2 weeks of modified cursor and my full and differiential backups are now backing up all user databases under my SQL Server Instance. In...
October 27, 2017 at 11:05 am
Thank you munzelj for your post.
I am using a store procedure to backup my databases and once in...
October 10, 2017 at 7:51 am
Thank you. I copied and pasted the above code and it worked great!
February 26, 2016 at 8:01 am
When I tried this code I got a syntax error on the A - B as TEST. Am I doing something wrong?
February 26, 2016 at 5:31 am
In looking at my fulltext index within SSMS, the population status is now, 10/13/2014, reading Idle. After my upgrade and when I started the fulltext index rebuild as suggested...
October 13, 2014 at 7:40 am
Viewing 10 posts - 1 through 10 (of 10 total)