Viewing 15 posts - 12,886 through 12,900 (of 22,219 total)
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
DBANewbie (3/30/2011)
Thanks for your replies so far, i keen to learn as much as i...
"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:36 am
It depends on the object. For example a heap table can have four, DatabaseID:FileID;PageID:Slot (or row). So, what kind of object are you looking at?
"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 29, 2011 at 1:56 pm
Yes, they can run side-by-side. On my old desktop I had 2000, 2005, 2008 and 2008 R2 all running at once.
But, on a real server, with real users, they...
"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 29, 2011 at 12:34 pm
Here's information on manipulating your connection string.
"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 29, 2011 at 12:18 pm
awan-413156 (3/29/2011)
Set-up I: two SQL engines set up as cluster and all accessing DB files on a separate SAN drive. One SQL engines dies the other...
"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 29, 2011 at 10:55 am
Viewing 15 posts - 12,886 through 12,900 (of 22,219 total)