Viewing 15 posts - 4,996 through 5,010 (of 22,219 total)
By and large, when creating a new index, I leave the default in place unless I know going in that I'm likely to see lots of fragmentation. Otherwise, I don't...
"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
March 11, 2016 at 6:05 am
johnwalker10 (3/10/2016)
check out the following link maybe this will help you out: http://serverfault.com/questions/111510/how-to-monitor-activity-on-a-single-table-using-sql-server-profiler
Two points on that answer. One, it's doing the same thing with trace that I outlined with extended...
"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
March 11, 2016 at 6:01 am
sql-lover (3/10/2016)
Grant Fritchey (3/10/2016)
sql-lover (3/10/2016)
I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from...
"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
March 10, 2016 at 3:10 pm
sql-lover (3/10/2016)
I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from a simple 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
March 10, 2016 at 1:05 pm
sql-lover (3/10/2016)
Grant Fritchey (3/10/2016)
"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
March 10, 2016 at 1:04 pm
This is easy and difficult at the same time. Tracking an individual table, I assume you want READ/UPDATE/DELETE/INSERT is not something normally done. It's very easy with a batch operation:
CREATE...
"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
March 10, 2016 at 11:44 am
Take direct control of the restore process through scripts rather than relying on some GUI. You can certainly name the files any way you wish when using those products 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
March 10, 2016 at 11:19 am
There is no direct connection between SCOM and Maintenance Plans. You may need to go into SCOM and deselect databases that are not being backed up in order to remove...
"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
March 10, 2016 at 11:17 am
Just in terms of generic storage and retrieval, not talking about any particular query or structure, the best place to put a clustered index is on a monotonically increasing, 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
March 9, 2016 at 9:14 am
It's also a good idea to use roles within the database to assign permissions through the role rather than to individual AD groups. This makes it easier to mix and...
"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
March 9, 2016 at 5:43 am
Yes
"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
March 9, 2016 at 4:21 am
The issue is a combination of bandwidth and data size. There's no "fast" way to delete some of the data from a table. If it can use the primary keys...
"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
March 9, 2016 at 4:21 am
With no details on what the job does, the best thing would be to capture the wait statistics before and after the job runs. You can then compare the two...
"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
March 8, 2016 at 10:06 am
Not enough to go on. What do the wait statistics look like? What is causing the server to run slow. Is it slower than another server? What are the differences...
"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
March 8, 2016 at 10:04 am
SQL!$@w$0ME (3/8/2016)
Thanks. Any possibility of using the existing on-premise AD accounts in azure db?
It has to be through a hybrid environment, but yes. It's in preview right now[/url].
"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
March 8, 2016 at 9:33 am
Viewing 15 posts - 4,996 through 5,010 (of 22,219 total)