Viewing 15 posts - 12,886 through 12,900 (of 22,224 total)
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
Mikey01 (3/30/2011)
No 2 versions of 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
March 30, 2011 at 5:42 am
bitbucket-25253 (3/29/2011)
SOLVED A BEASTLY PROBLEM THAT WAS PLAGUING YOUR SERVERS FOR...
"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:38 am
Hey guys,
I need a little help with remote access and encryption over here. I don't know squat.
"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:37 am
Viewing 15 posts - 12,886 through 12,900 (of 22,224 total)