Viewing 15 posts - 45,556 through 45,570 (of 49,552 total)
That's a big topic. Worthy of a book or two.
When use an index - Anytime you want a query to run without having to scan the entire table to find...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 1:37 am
bohra_anand (7/18/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:36 am
The roles that the users are assigned to. The object level permissions that the users have (if applicable)
The first you can query from sys.database_role_members and sys.database_principals. The second you can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:31 am
You can read through the error log to get a high-level overview. The details are quite complex. I saw a section in a book I read recently and the description...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:29 am
Maybe. Are they all members of 1 or more roles? Do all the users have the same permissions? If not, do you have a table or export file somewhere with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:18 am
ALZDBA (7/18/2008)
And sweet is the odor of victory 😎But sometimes no one acknowleges it ... "after all you just did your job".
The best part was that a few months later...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:15 am
Mostly it's if you notice queries running poorly because of out of date statistics. Normally that happens on large tables (million + rows) where the index is on an increasong...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:10 am
Yes. Assigne them to the required roles or grant them the permissions that they should have.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:08 am
That depends on what your fix user script does.
Oh, for your info. SysUsers ins't a table in SQL 2005. It's a view.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:03 am
rinu philip (7/20/2008)
Think this method below would help you : 🙂BACKUP LOG name WITH TRUNCATE_ONLY
USE db
DBCC SHRINKFILE (name_Log, 1)
Be very careful of Backup log with truncate. If you are running...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 12:01 am
It depends what you're looking for. What's your (or your manager's) definition of database health?
I'd start with things like Transactions/sec (to get the throughput), Buffer cache hit ratio and page...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2008 at 11:58 pm
Waseem Jaleel (7/20/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2008 at 11:52 pm
Do all the users have the same permissions? If so, create a DB role, grant the permissions to that and assign each user to the role.If not, you'll have to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2008 at 11:49 pm
I'm not sure I understand your question. Processes within SQL, processes visible to the OS, something else entirely?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2008 at 11:44 pm
vidhya sagar (7/20/2008)
(You can update the tables if you connect to server as DAC)
You can read the system tables if you connect with the DAC. Updating them is still not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2008 at 11:42 pm
Viewing 15 posts - 45,556 through 45,570 (of 49,552 total)