Viewing 15 posts - 1,006 through 1,020 (of 22,232 total)
Extended Events is our friend.
Take a look at the object_created event. You could filter by object_type and only see when indexes get created.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2022 at 1:32 pm
If you're moving the entire data set every time, I don't think a relational database is the thing for you. It's adding all sorts of overhead that just doesn't seem...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2022 at 1:25 pm
You want to look at Extended Events. sp_cache_remove is the key to understanding what's going on. Here's an example session for detailing cache behaviors:
CREATE EVENT SESSION...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2022 at 1:07 pm
>>>>Eirikur Eiriksson wrote: >>>Grant Fritchey wrote:
>>Sean Lange wrote:
>And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 5:00 pm
And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new position as a full time DBA. Even more...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 4:11 pm
Just a test here... did anyone get an email notification of this post?
Yep. It was down, but now it's working.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 4:10 pm
A spreadsheet into the database is pretty much any of the standard stuff. You can link to the database from Excel and insert from there. You can script stuff out...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 2:02 pm
I see Id & fbocode, the PK from the table, in the other table. Aren't those the correct columns?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 2:00 pm
The likelihood of them doing it manually and getting all the permissions right is not very high.
HA!
WHAT?!?!
No, surely a purely manual process across lots of servers will be perfectly...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 12:53 pm
How about if we can have an article for multi subnet AlwaysOn (without stretched VLAN) involving one node in Azure as well.
I think that will cover 2 major topics
-...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 12:52 pm
Thanks Jeff and Grant for responding. I now have two articles waiting for Steve's approval.
Don’t know if those will make the cut. Let’s see.
He's got a backlog, but I'll...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 12:51 pm
Carriage return and line feed acts as a secondary terminator. The one most people use most of the time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 12:50 pm
Oh, absolutely not worth an argument over. It's long been a bit of an issue the lack of support for Azure through SSMS. It's there... mostly, sort of, as long...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2022 at 7:32 pm
We had a directive from corporate to upgrade all our server OSes to 2019. I was informed by IT that they were going to in-place upgrade the SQL Server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2022 at 7:31 pm
PostgreSQL also sort of, but sort of doesn't, require semi-colon's.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2022 at 5:04 pm
Viewing 15 posts - 1,006 through 1,020 (of 22,232 total)