Viewing 15 posts - 2,056 through 2,070 (of 39,771 total)
March 26, 2021 at 5:09 pm
I'm one of those who spend more than an hour working on a problem. Steve, I appreciate what you're saying, and it makes a sense, but I'm finding it...
March 26, 2021 at 4:41 pm
I am guilty of banging my head against something for more than an hour, but I have found that if you ask someone (anyone really) to lend you their...
March 26, 2021 at 4:37 pm
I completely agree, Rick, on both points. Time is valuable, and we ought to be thinking more than we code. Observe, learn, and think.
It's also not finished. Early DevOps view,...
March 25, 2021 at 1:48 pm
My guess is someone changed or never set this Agent to start up. The service ought to be dependent on SQL Server, so that it won't start until the database...
March 24, 2021 at 10:39 pm
+1 to what Brian wrote. Analyze a number of things to try and find the bottlenecks. Bad code can cause the CPU to rise, which may not be a problem...
March 23, 2021 at 7:53 pm
Patching: https://www.brentozar.com/archive/2015/02/patching-sql-server-availability-groups/
For DBCC, if the primary fails, the DBCC work is lost. This is an internal snapshot of the db. Losing this doesn't hurt, but the DBSS work is...
March 23, 2021 at 7:52 pm
DCAC is Denny Cherry and Associates, the consulting company.
There is no "PASS" anymore. I'm going to get an independent SQL Sat org, community run, up and running. The Summit will...
March 19, 2021 at 7:00 pm
I think this is something to start a discussion thread in that forum about. I am looking to put up some "free"-ish hosting of things. I have a SQL Sat...
March 19, 2021 at 5:37 pm
My pleasure.
FWIW:
https://popbi.wordpress.com/2012/05/02/fuzzy-match-your-data-without-enterprise-edition/
https://www.sqlservercentral.com/articles/roll-your-own-fuzzy-match-grouping-jaro-winkler-t-sql
If you find one of these to be helpful in your work, I'd love to work with you on an article to help others.
March 19, 2021 at 5:30 pm
If you don't see the named instance listed, that is strange. Can you post what you see in config manager?
Typically the default instance listens on 1433. Named instances get a...
March 19, 2021 at 2:33 pm
It doesn't quite appear you've asked a question, and this isn't well formatted to understand what you want. Please format code as code, and explain what results or logic you...
March 19, 2021 at 2:31 pm
Do you mean in SSIS? Or in Full-Text or something else?
If SSIS, doesn't appear to be: https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver15
March 19, 2021 at 2:30 pm
The the KB page (https://support.microsoft.com/en-us/topic/kb5000685-cumulative-update-23-for-sql-server-2017-22b653c7-8487-4564-9db2-b5c1bd465145) for the latest, scroll down. There is an uninstall section.
March 19, 2021 at 2:21 pm
Viewing 15 posts - 2,056 through 2,070 (of 39,771 total)