Viewing 15 posts - 12,706 through 12,720 (of 22,219 total)
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
Glad to hear it worked. Did you patch the server first?
"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:49 pm
SQL Backup from Red Gate is very good about centralizing management of your backups. Plus it has other benefits, like backup compression for 2000 and 2005 databases and backup...
"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 7:59 am
This is a classic "are you sure really need everything, every time" discussion that you should have with your application team. Also, I suspect, it's hard to know based just...
"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 7:56 am
forsqlserver (4/18/2011)
Thanks...from Where I can start..Currently with close we just start installtion wiith very fw checks...:-D
You have to set up the monitors. Start now. For a general set of monitors...
"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:35 am
You might see a speed up in the start up process if you have fewer databases, but overall performance wouldn't be affected at all.
"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:30 am
Viewing 15 posts - 12,706 through 12,720 (of 22,219 total)