Viewing 15 posts - 6,706 through 6,720 (of 22,229 total)
It really depends on what you're trying to do. If you're trying to identify long running queries, you'll probably get most of them using the approach outlined. If you're trying...
"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 23, 2015 at 10:32 am
For the most part, tooling from Microsoft is backwards compatible, but not forwards compatible. Meaning, SQL Server Management Studio for SQL Server 2012 will connect readily to SQL Server 2008....
"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 23, 2015 at 10:20 am
Just remember that those queries are completely cache dependent. If anything has aged out of cache or queries that don't go into the cache (such as queries with RECOMPILE hints),...
"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 23, 2015 at 10:18 am
It's generally a good idea to have SQL Server run on a machine by itself and not share the server with other processes. SQL Server only consuming 85% sounds like...
"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 23, 2015 at 4:25 am
Bouke Bruinsma (2/23/2015)
GilaMonster (2/23/2015)
Bouke Bruinsma (2/22/2015)
First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether.
Absolutely not. 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
February 23, 2015 at 4:14 am
Run DBCC CHECKDB.
The output will tell you what is corrupted. If you're lucky, it's a nonclustered index. You can drop it and recreate it and walk away a winner. If...
"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 22, 2015 at 6:05 am
You can only update multiple rows in a single statement if they have matching criteria. For example, there's a ShipByDate and they all have the same value, then the WHERE...
"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 22, 2015 at 6:03 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
February 21, 2015 at 8:25 am
I've heard about this being an issue before, but I'm not sure what the solution is. In most circumstances, you shouldn't be running SSMS on the Production server. Instead 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
February 20, 2015 at 10:30 am
Ed Wagner (2/20/2015)
Grant Fritchey (2/20/2015)
Sean Lange (2/20/2015)
Grant Fritchey (2/20/2015)
Ed Wagner (2/20/2015)
jasona.work (2/20/2015)
Lynn Pettis (2/18/2015)
"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 20, 2015 at 8:02 am
Sean Lange (2/20/2015)
Grant Fritchey (2/20/2015)
Ed Wagner (2/20/2015)
jasona.work (2/20/2015)
Lynn Pettis (2/18/2015)
"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 20, 2015 at 7:55 am
BOR15K (2/20/2015)
Grant Fritchey (2/20/2015)
"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 20, 2015 at 7:52 am
Yeah, the queries run on the server. Filtering, ordering, etc., that are defined within the query, will all be done on the server. Now, once you have the result set,...
"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 20, 2015 at 7:29 am
Ed Wagner (2/20/2015)
jasona.work (2/20/2015)
Lynn Pettis (2/18/2015)
... Mark one off, 9 days on the calendar to go. 9 days on the calendar to go, 9 days to go, ...
Remember to stay...
"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 20, 2015 at 7:26 am
The query will return what the query returns. So, in your first example, all the 1,000 rows are loaded into memory in Australia and then they're sent over the wire...
"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 20, 2015 at 6:14 am
Viewing 15 posts - 6,706 through 6,720 (of 22,229 total)