Viewing 15 posts - 916 through 930 (of 22,189 total)
You sure you got the question right? Looking through that list I can only see one thing that IS a benefit. Replication does not load balance. Replication doesn't distribute queries....
March 15, 2022 at 12:56 pm
I am not a fan of debugging within T-SQL queries, however, if you want to do it, SQL Server Management Studio is free and it does include debugging.
The...
March 15, 2022 at 12:47 pm
It's the code. I know you've said you can't affect that, but that's where the problem is. You have to use the correct data types. That's how you fix these...
March 8, 2022 at 7:23 am
I checked this table it has no FK, or triggers, and character fields are defined as Nvarchar. There are NO indexes or a PK set of this table.
Are you...
March 7, 2022 at 5:42 pm
Yeah, absolutely.
Although, I have good news. There is an open source software that does a lot of this, OpenQueryStore. I saw this when it was an in-house private bit...
March 4, 2022 at 3:10 pm
I appreciate the feedback.
One reason I've used index rebuilds in the past is because some of the third-party apps we rely on can sometimes end up with a query...
March 4, 2022 at 1:59 pm
Oh!
yeah, the query store data is stored with the database. If you back it up, which you are absolutely NOT doing, when you restore, you will get that data back....
March 4, 2022 at 1:56 pm
Effectively a varchar(50) and a varchar(4000) are the same, so you won't see an implicit conversion there. It's the varchar to int that you're going to see the most.
March 4, 2022 at 1:53 pm
All problems won't be fixed in the code, but I'd start there. Get that right, then figure out how the queries really behave. From there, you can make some good...
March 3, 2022 at 4:38 pm
Query Store is not overwritten during a restore. In fact, it remains completely intact. All Query Store information is in system tables, stored with each database and will get backed...
March 3, 2022 at 2:47 pm
Piling on.
Sounds like statistics are getting out of date. Focus there, not on index rebuilds (although, those will also update statistics).
March 3, 2022 at 2:45 pm
ALL cases.
All of them. Statistics are what the optimizer uses to determine how many rows are likely to be returned from a given table or index. Without statistics, the optimizer...
March 3, 2022 at 2:44 pm
You could provide them with PowerShell commands that run the script. Or, assuming they have a client tool installed, a batch file to run the command. I'd lean towards Powershell....
March 3, 2022 at 2:40 pm
Check all the settings as suggested. Maybe an application server is misconfigured and using different ANSI settings. Look at the query_hash values to make sure they're the same. Normal behavior,...
March 3, 2022 at 2:38 pm
Woof!
So, your parameters don't match the data types of the columns. I know you said you can't change the code, but it's wrong. For example, tinyint, which is what's in...
March 2, 2022 at 4:34 pm
Viewing 15 posts - 916 through 930 (of 22,189 total)