Viewing 15 posts - 12,706 through 12,720 (of 22,224 total)
It's impossible to suggest anything to you without more information. The execution plan and a complete table structure are the minimum we need to begin to make even somewhat intelligent...
"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
April 20, 2011 at 4:55 am
Take a look at sys.dm_exec_requests and sys.dm_os_waiting_tasks and you can tell exactly what the process is waiting on and if it's blocked.
"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
April 20, 2011 at 4:54 am
It's just a standard RESTORE operation using the REPLACE keyword, probably along with MOVE. Look it up in Books Online. There are even examples of how to replace a 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
April 20, 2011 at 4:52 am
There isn't one single way of doing this, but in general, it would be the DBA responsible for the rollout. To really get into deployments in detail, I'd suggest getting...
"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
April 20, 2011 at 4:51 am
You can try using ping to see if you can at least get to the server. There's also a utility for download somewhere called sqlping that's a bit more specific.
"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
April 20, 2011 at 4:48 am
Oh, I think I see. The formatting was WAY off there.
Take a look at the command GROUP BY. You can perform aggregate operations on your data using that. SUM() would...
"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
April 19, 2011 at 6:16 am
Is the problem the server or certain queries. If it's the server, you need to focus on server settings and configurations. Min/max memory, parallelism, cost thresholds, cpu affinity, all that...
"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
April 19, 2011 at 5:25 am
Indications are, you may have different versions of SQL Server on your client machine and on your server. I'd check that first. You should be able to load SMO. That's...
"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
April 19, 2011 at 5:23 am
The first thing I would do is see what a select statement with this as the WHERE clause looks like:
WHERE CO='01' AND BRANCHID<>'CLNT'
What kind of execution plan are you getting?...
"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
April 19, 2011 at 5:18 am
I'm confused, based on the data provided, how does RAJ get a value of 800? What is it that you're trying to do?
"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
April 19, 2011 at 5:16 am
This was a while ago, but I wrote two articles on how to do unit testing with TSQL using some open source tools[/url] and using Visual Studio tools[/url]. And one...
"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
April 19, 2011 at 5:10 am
Just to pile and beat on your bruises a bit, you're spending too much time, especially in the second abstract defining the problem. You need to define the problem space...
"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
April 18, 2011 at 5:40 pm
If all you're looking at is sys.dm_os_wait_stats then no, you can't narrow that down to a database. But if you start using some of the other DMOs like sys.dm_os_waiting_tasks, 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
April 18, 2011 at 5:34 pm
Uripedes Pants (4/18/2011)
"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
April 18, 2011 at 2:21 pm
GilaMonster (4/18/2011)
CirquedeSQLeil (4/18/2011)
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
Yup. Booked flights so that I get 4 and a bit days at leisure in 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
April 18, 2011 at 1:51 pm
Viewing 15 posts - 12,706 through 12,720 (of 22,224 total)