Viewing 15 posts - 76 through 90 (of 148 total)
Just in case you (or anybody else) would like to read yet another post on the topic, I've written about this.
May 28, 2012 at 7:00 am
Cool, I had the PerfMon counters poster but not the DMV one. Thanks!
May 28, 2012 at 6:57 am
SQLDBA360 (5/28/2012)
One other thing is that local administrators of the server are in the sysadmin role by default in SQL 2005 they are not in SQL 2008
Good point. Also,...
May 28, 2012 at 6:55 am
As far as I know, SQL Server doesn't out-of-the-box record and save column-usage statistics. You'll need to implement your own method here. You can get creative with a...
May 28, 2012 at 6:54 am
When you rebuild an index, the corresponding statistics are automatically updated as part of the process.
May 28, 2012 at 6:40 am
As per BOL: "Members of the sysadmin fixed server role can perform any activity in the server."
In either 2005 or 2008, sysadmin is still God rights where members can do...
May 28, 2012 at 6:31 am
Have you been monitoring and recording disk space utilization for the past duration of time? If so, you can use this as trend analysis and see where that is...
May 25, 2012 at 5:59 am
I don't believe this is possible. When a transaction is executing under the READ UNCOMMITTED transaction isolation level, it basically just doesn't issue shared locks. I don't think...
May 22, 2012 at 6:24 pm
It all depends on exactly what the jobs are doing. You're basically seeing maximum concurrency (or close to it at least). We need to know a lot more...
May 18, 2012 at 7:57 pm
Ok that makes sense. Thanks for the explanations!!!
May 17, 2012 at 6:04 pm
Ok, Local System is a highly privileged account. It is not recommended to be using this as the SQL Server account. If this is in production, I recommend...
May 13, 2012 at 1:08 pm
Not a problem, and you are correct. I do recommend getting a beginner's book on SQL Server, as there are a lot of introductory topics that are required to...
May 13, 2012 at 12:53 pm
Yes, you can join more than 2 tables. Take this for example:
select
*
from table1 a
inner join table2 b
on a.id = b.t1_id
inner join table3 c
on a.id =...
May 13, 2012 at 12:45 pm
Have you checked to make sure your SQL Server service account has permissions on that file/directory?
May 13, 2012 at 12:29 pm
Not sure if this is what you're looking for, but you can set up a SQL Audit, and have a Server Audit Specification with an Audit Action Type of DATABASE_CHANGE_GROUP....
May 11, 2012 at 11:32 am
Viewing 15 posts - 76 through 90 (of 148 total)