Viewing 15 posts - 7,771 through 7,785 (of 22,219 total)
The only thing about replication in the Books Online is about disabling indexes. I've never heard you couldn't rebuild indexes because of replication. I know I used to use 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
July 9, 2014 at 11:52 am
GilaMonster (7/9/2014)
Personally I still schedule index rebuilds on all servers. But I schedule targeted ones that rebuild just what needs rebuilding and only larger tables.
+1
"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
July 9, 2014 at 9:07 am
I'm pretty mixed on index fragmentation. Unfortunately, I've seen it cause problems, so, if I can defragment indexes for little or no cost, I'm going to do it. If 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
July 9, 2014 at 8:14 am
I am not a fan, but you should at least take a look at the built-in functionality for auditing.
"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
July 9, 2014 at 7:48 am
Koen Verbeeck (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
He's being a tad lazy now.
I'll move 'em...
"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
July 9, 2014 at 7:45 am
I'd suggest going to the link I provided and just following the instructions there. Here's a sample:
CREATE EVENT SESSION [QueryMetrics] ON SERVER
ADD EVENT sqlserver.rpc_completed(
WHERE ([sqlserver].[equal_i_sql_unicode_string]([sqlserver].[database_name],N'AdventureWorks2012'))),
ADD...
"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
July 9, 2014 at 7:43 am
ChrisM@Work (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
Bwahaaaa! I was so tempted to post "Haven't 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
July 9, 2014 at 7:31 am
Yeah, or sys.dm_exec_sql_text to see the queries currently in cache. You'll want to combine that with sys.dm_exec_query_stats just to make things a little easier to put together.
"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
July 9, 2014 at 7:25 am
You parameterize the values passed to the query, not the tables and columns. Those have to be explicitly stated. As Gail said, you can build those statements dynamically, but 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
July 9, 2014 at 7:09 am
Maybe, but I wouldn't. Take a look at sys.dm_exec_requests. Backup processes will give you a ballpark completion percentage. That should help you know how long you might have to wait.
"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
July 9, 2014 at 7:02 am
Try DBCC UPDATEUSAGE and see what things look like then.
"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
July 9, 2014 at 7:01 am
Well the mommy data and the daddy data loved each other very much so....
"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
July 9, 2014 at 6:59 am
If I understand what you're asking, then I'd suggest either using extended events or a server-side trace[/url]. You can capture the queries and with the queries you can tell what...
"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
July 9, 2014 at 6:56 am
I'll come right out and say it. No, it's impossible to just migrate your database over using any straight method.
I agree with the steps Hanshi laid out for a...
"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
July 9, 2014 at 6:52 am
Keep an eye out for the SQL Skills Immersion courses. They have a lot of detailed internals knowledge. And it's in-person and travels. Not sure what the schedule is, but...
"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
July 9, 2014 at 4:55 am
Viewing 15 posts - 7,771 through 7,785 (of 22,219 total)