Viewing 15 posts - 12,901 through 12,915 (of 22,224 total)
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
You can get that information, if you have both individual logins and your connection strings include the app that is connecting. If you're using a service login for the applications,...
"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:41 am
DBANewbie (3/29/2011)
Out of interest; would you see it as a significant increase in risk to allow connections via enterprise manager considering that we already allow access via RDP?
You must have...
"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:39 am
Yeah, it can work. But you have to use SQL logins as well as expose the server through the firewall. From a security standpoint, I don't like it. But 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 29, 2011 at 9:54 am
You could try going with a slightly different approach. Set up the views under a different schema and then grant the user SELECT access to that schema.
"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 9:43 am
Have you look at locks and wait states to understand why it's doing this? You should be able to at least narrow down the problem.
App code or not (and 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 29, 2011 at 7:55 am
At your currrent skill level, what you can honestly charge, you should be looking at local non-profits, schools, that sort of thing. Then, as you build your skills, you can...
"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 7:11 am
That's similar to what I've done in the past. I always try to find a task that I'd like to get done but don't have time to do because it'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
March 29, 2011 at 7:08 am
I'm not sure why someone would say that SCOM is not good for that type of job. In fact SCOM is pretty much designed around specifically that. It would be...
"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 7:05 am
If you're looking to do versions of data, you might want to take a look at this article[/url] I wrote for Simple-Talk. Better still, take a look at the comments....
"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 6:40 am
The share has to be accessible, but then you just use the UNC path for it:
RESTORE ... FROM DISK = '\\servername\sharename\filename'
Since the filename is likely to be different each and...
"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 6:36 am
Viewing 15 posts - 12,901 through 12,915 (of 22,224 total)