Viewing 15 posts - 31 through 45 (of 21,374 total)
It would be the standard stuff, sql_batch_complete or rpc_complete. With the batch completion event you can filter by the search string. With the rpc_complete you'll need to first identify stored...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 19, 2022 at 12:12 pm
And you, you should not be in fear for your job. Ha!
You've hit it on the head. I love this stuff. I do. However, like anything, used badly, it's going...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 14, 2022 at 10:16 am
Well, SSDT for Visual Studio 2022 is out as well, so the OP does have a choice of the latest or previous version for Visual Studio 2019 at least....
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 4, 2022 at 7:07 pm
Yep. You need the latest version to work on the latest version. Forwards compatibility is generally not a thing.
Also, seems that you could be hitting a common problem. Scroll to...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 4, 2022 at 2:52 pm
OK. There's a ton to unpack here. Let's try to go through it.
Hello ,
I will proceed in the next few days to configure the columnstore indexes to replace the...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 3, 2022 at 2:30 pm
Basically, it's a marker that something might be suspect, not that it is. So, you go and run a consistency check. If it finds something, there you go. If not,...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 3, 2022 at 2:24 pm
Statistics updates are way more of an art than a science. However, every two weeks, might be a little long. As a general rule, I updated stats once a week....
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 28, 2022 at 3:50 pm
If you move your database to managed instance, you can't back it up and restore it locally again. Think of MI as a newer version of SQL Server. Just like...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 28, 2022 at 1:25 pm
Sure sounds like parameter sniffing. Running the code locally do you hard code the value, meaning:
SELECT x.a
FROM dbo.mytable as x
WHERE x.b = 42;
I would expect that to...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 28, 2022 at 1:15 pm
I'd say there's not a single correct answer for everyone on this question, but I'll put out my two cents.
Yes.
I see three general tracks through work life (VERY broad generalizations...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 28, 2022 at 1:08 pm
Backup and restore is out. It simply doesn't work. The Azure systems are constantly being upgraded and backups from there generally can't be restored down to on-premises. It's similar to...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 28, 2022 at 12:53 pm
Potentially. If they're holding locks, even shared locks, anywhere, you could see contention because of it. However, I suspect you would have seen it by now.
Main concern would really only...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 27, 2022 at 7:09 pm
Nope. Sounds like the application, or applications, has a problem. Time to dig into the code & configurations there.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 27, 2022 at 2:04 pm
SQL Server is a greedy cuss. Running SSIS and SSAS on the same server is going to cause quite a bit of contention.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 27, 2022 at 1:08 pm
Sounds like the transactions are closing and then opening again.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 27, 2022 at 1:07 pm
Viewing 15 posts - 31 through 45 (of 21,374 total)