Viewing 15 posts - 12,871 through 12,885 (of 22,219 total)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
"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 31, 2011 at 7:40 am
Krasavita (3/31/2011)
Hi, here is another stored procedure I found with a problem with nested Loop.Can you please help me to identifiy which update statment is wrong.Thank you so much
You're still...
"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 31, 2011 at 7:38 am
Let's assume that the view is fairly straight forward. It's a query against a table or a small set of tables that is properly configured. In that case, the optimizer...
"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 31, 2011 at 5:44 am
Sounds like a perfect solution for SQL Azure. You have data that you want everywhere you go, right? There it is.
"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 31, 2011 at 5:37 am
Last company I worked for made the decision to stay on 2008 on most servers because the licensing cost was too severe. The exceptions were SSRS servers, servers supporting spatial...
"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 30, 2011 at 7:34 pm
Jack Corbett (3/30/2011)
Grant Fritchey (3/30/2011)
Oh, and for those interested, I've heard through the grape vine that the call for speakers goes out soon and will be abbreviated this year. Get...
"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 30, 2011 at 6:35 pm
Again, maybe, maybe not. You're also looking at the resources on the system. How much memory is there? Is it possible that you've pushed the DBCC check to the point...
"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 30, 2011 at 6:31 pm
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
And that blank spot is where the miracle occurs?
"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 30, 2011 at 12:20 pm
CirquedeSQLeil (3/30/2011)
using the spid of that process, use dbcc inputbuffer to...
"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 30, 2011 at 12:19 pm
Chad Crawford (3/30/2011)
Wahoo! After 4 months of wrangling, got the PASS Summit approved (and paid for) today!
congratulations.
Oh, and for those interested, I've heard through the grape vine 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
March 30, 2011 at 11:56 am
Sorry, I don't get what you're getting at. The queries and the code are all available with the article[/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 30, 2011 at 11:55 am
Start here:
SELECT * FROM sys.dm_exec_requests
You'll see what is running and you should be able to see what is locked. Look here
SELECT * FROM sys.dm_db_index_operational_stats(dbid, tableid,NULL,NULL,null) AS ddios
You can at least...
"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 30, 2011 at 11:51 am
I knew I could get some help in 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
March 30, 2011 at 9:42 am
hlpearl (3/30/2011)
I like your idea on the book management system with versions of books. But the question I have is; if part of the key contains a version representation what...
"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 30, 2011 at 9:41 am
You have a lot going on under the covers here. Remote queries are likely to cause issues when you're trying to join data. This query:
UPDATE dbo.NED_Employee
SET
Department_ID=d.Department_ID
FROM [DB1].MIT.dbo.National_Employees ne, dbo.ADP_Department d
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
March 30, 2011 at 8:14 am
Viewing 15 posts - 12,871 through 12,885 (of 22,219 total)