Viewing 15 posts - 6,706 through 6,720 (of 22,226 total)
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
Koen Verbeeck (2/20/2015)
Grant Fritchey (2/20/2015)
You might want to drop all indexes and foreign keys from the table you're loading...
"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:11 am
Here are a few suggestions in addition to what Koen already said.
You might want to drop all indexes and foreign keys from the table you're loading to, depending on how...
"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 3:35 am
I'm not surprised the event_sequence isn't available in 2008, but I could have sworn they supported sql_batch_completed. Take a look at the events available by running the query from here....
"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 3:00 am
Viewing 15 posts - 6,706 through 6,720 (of 22,226 total)