My problem is as follows. I have user thats is a member of to AD groups A, B, C and D. These groups A, B, C, D are members in group AA, BB etc. And...
What is the simplest way to get Table Usage Statistic. Numbers of reads, writes, updates etc.
The database is in the collation Finnish_Swedish_CI_AS and I have table with a datetime column. We have an application that u are able to change...
Google and found this. select USER_NAME(p.grantee_principal_id) AS principal_name, dp.type_desc AS principal_type_desc, p.class_desc,...
I have tried that and that gives me the error as sa and my own account, member of sys_admin.Msg 15404, Level 16, State 19, Line 1 Could not obtain...
A Domain Windows Account has rights execute a Scalar Value Function that it not should. The Domain Windows Account is member of Domain Windows Group...
...
Yes found that also, will collect a new log and look for Avg. Disk Sec/Read and Write instead. MS told me that 10ms - very good 10-20ms - normal...
We have EVA4000 storage Network. The configuration is like this; 1 disk Group, 2 Virtual disks in vraid1 and 26 physical disks in data group. Is it...
Understand you are using a dotnet program to make the database? Or is schedule sql? If it’s a program I wouldstart using SMO. Just after calling...
My opinion is Dynamic memory,unless u has some specific memory requirement for another application. For IE64 we have use fixed else the serverhangs....
-- Possible to first check sys.dm_exec_sessions, over 50 to get only users? select * from sys.dm_exec_sessions where session_id > 50 -- Cheking...
Yesterday I had problem withthat a sp that contained join that the developer had forgotten the where part. Thesp join very large tables and sp took...
I will check with vendor.
I found this in the help file for Check Database Integrity Task All databases Generate a maintenance plan that runs maintenance tasks against all...
Well my nightly job reported…. DBCC CHECKDB (tempdb) executedby AIR5XXXX found 48 errors and repaired 0 errors. Elapsed time: 0 hours 0minutes 0...
If have found a table intempdb that’s are givning me dbcc checkdb errors. I don’t know how to besttrack this. I have the object id of the temp...
Use the Instance Name page of the SQL Server Installation Wizard to specify whether to create a default instance or a named instance of SQL Server. A...
At my workwe have Itanium with IE64, If we don’t set this server fixed max value we getproblem with server constant freezes. We have been in...
Separate names with a comma.
