Viewing 15 posts - 3,781 through 3,795 (of 22,219 total)
Everyone,
Thanks for all the wonderful feedback. I appreciate the discussion.
I will add one point to the editorial. I'm not a fan of how Microsoft handles their...
"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
June 5, 2017 at 7:30 am
Reinforcing what Gail said and adding one more wrinkle. The nice thing about the side-by-side install is that you can use log shipping to set up a process that will...
"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
June 5, 2017 at 6:27 am
There just isn't a single answer here that's going to satisfy all situations. I've maintained systems that had statistics maintenance running anywhere from weekly to daily to, for one table...
"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
June 5, 2017 at 6:23 am
Absolutely directly.
Slower and fewer CPUs mean less processing power. Less memory means more disk I/O to process data. Slower and fewer disks means slower disk reads and writes....
"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
June 2, 2017 at 10:35 am
Thanks for the response - looking for a quick fix as this is affecting...
"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
June 2, 2017 at 7:22 am
You have to look at the T-SQL within the extended event. There isn't a tool out there that captures metrics by table. Any given query or batch can be hitting...
"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
June 2, 2017 at 7:16 am
I'm not aware of something inherent in 2016 that would make that run slower. You are going to be dealing with the new cardinality estimation engine (at lease when the...
"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
June 2, 2017 at 7:14 am
It sounds like your machine is completely underpowered. You need memory. I/O implies disk, but it includes reads and writes to memory plus reads and writes to disk. If you...
"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
June 2, 2017 at 6:01 am
Connecting from ADO in Powershell should be the same as VBA. I use the full server name provided: xxx.database.windows.net. That ought to work for you. You will need to make...
"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
June 1, 2017 at 8:01 am
There are a bunch of things it could be, probably most of them on the client side. However, the paranoid DBA in me says, check for corruption of the database...
"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
June 1, 2017 at 7:59 am
"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
June 1, 2017 at 6:45 am
"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
June 1, 2017 at 6:15 am
The ATTACH function is what you're looking for to "open" an MDF file. This does assume you have some version of SQL Server installed. SQL Server Express edition...
"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
May 25, 2017 at 6:38 am
If you can use an ALTER, do that. It won't work in every situation and then you'll need to CREATE the new table, migrate all the data and constraints as...
"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
May 25, 2017 at 5:37 am
"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
May 25, 2017 at 5:24 am
Viewing 15 posts - 3,781 through 3,795 (of 22,219 total)