Viewing 15 posts - 151 through 165 (of 22,224 total)
Migrating between data platforms is a massive undertaking. It's not just data types, although that's a big part of it. You also have to take into account connection mechanisms within...
"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
November 27, 2024 at 2:13 pm
Just know that moving data OUT of Azure costs money.
"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
November 25, 2024 at 2:22 pm
Couple of things. It's now maintaining an index in addition to simply dumping data into a heap. Also, depending on how your data is ordered on retrieval, you may be...
"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
November 25, 2024 at 2:21 pm
You deserve a lot of credit for bringing people, quite literally, to the table to talk. Well done.
And thank you for all your help over the last couple of years.
"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
November 25, 2024 at 2:19 pm
The size of your log backups over time are a very good indicator as to how much stuff is passing through the logs.
"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
November 19, 2024 at 4:08 pm
Yeah, you do have to take care of yourself. Otherwise things get rocky. And happy to help anywhere I can.
"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
November 18, 2024 at 3:19 pm
Since you don't need realtime, the cheapest and easiest way will be backup and restore. Nothing to it.
"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
November 15, 2024 at 3:35 pm
Oof. Even if you put an index on the SpoolSrtDt column, because you have a function to convert the value you're going to get scans anyway. Why do that? It'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
November 15, 2024 at 3:31 pm
Thank you Grant. I know this was a broad one. I will enable the query store (of course I'm assuming that it does not effect things too much) to...
"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
November 13, 2024 at 4:54 pm
Lots of differences between 2014 and 2019. It's hard to say that it's going to be any one thing in particular. Your best bet is to do a bunch of...
"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
November 13, 2024 at 2:51 pm
Well that was one heck of a three days...
First Summit Seattle under my belt and I'm both burned out and still geeked. I wasn't able to attend even 1/2...
"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
November 12, 2024 at 8:36 pm
The problem is we are the last generation that studied mathematics seriously, as pre-condition to use it in programming, later databases.
What's this "we" stuff. I'm a film school...
"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
November 12, 2024 at 7:23 pm
Guess it depends on how the optimizer likes it. Either approach can be valid, depending.
"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
November 12, 2024 at 1:02 pm
Instead of removing the original question, you could have posted the solution so that if others hit it, they can benefit. Just a thought.
"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
November 12, 2024 at 12:59 pm
Personally (and I can hear the collective groans), I'd put Extended Events to work on the database. Capture all queries run against. The reason I say this, index usage stats...
"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
October 31, 2024 at 12:56 pm
Viewing 15 posts - 151 through 165 (of 22,224 total)