Viewing 15 posts - 12,886 through 12,900 (of 22,227 total)
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
Andy Leonard is one of the best guys I know for teaching people how to use SSIS. Here's a blog post on incremental loads. It can help to get 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
March 30, 2011 at 8:04 am
Krasavita (3/30/2011)
Guys, I loadedThank you so much
I don't think that uploaded correctly. It's only 399 bytes.
"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:39 am
Or watch this video on how to do it.
"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:05 am
Access Denied is a hard error message to argue with. It's telling you the service account that is running the backup can't access that device. You need to double check...
"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:02 am
If you drop everything and reinsert everything, you have to log the deletes and the inserts, so you need space in your log to support it.
First, best, choice; don't reload...
"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:00 am
If you really want to lock down access, you could set the transaction level for the connections to serializable. That will block pretty much everything until a given transaction completes....
"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 5:55 am
Welcome!
Remember, keep your hands and feet inside the vehicle at all times.
I think Jason's list over on Amazon covers most of the basics. The one thing I would add 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 30, 2011 at 5:51 am
Viewing 15 posts - 12,886 through 12,900 (of 22,227 total)