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...
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...
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...
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...
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...
...
<p><span><font face="Arial" size="2"><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font size="3"><font face="Calibri">During...
I need helpwith better solution to copy my bak and trn files to a file server. This is thebackground. I use to dump the backup files directly to the...
We todayhave 3 different indexes on a table that look like this CREATE INDEXIX_01 ON TORDLOG ([REGDAT]) INCLUDE ([ORDENR], [SUBNRX]) CREATEINDEX...
Hi I’m in theplanning stage for Mirror or log shipping solution for a database. The problemis how to copy “System Objects†as Logins, Linked...
Hi I’m going to rebuild index on a server. I’m using a loop based on the dm_db_index_physical_stats, 5-30% the I reorganize and > 30% I make a...
Hi Yesterday I tried to copy a backup to my local computer and I got very low speed. Lately the ppl have complained that response time on this...
I have tried to calculate the granularity of table with fields from A, B, C … n in some general formula. Don#%92t if this is right way to do it....
I have been using a modified version of isp_ALTER_INDEX written by Tara Kizer. I don#%92t have Enterprise and are not able to make online...
Newbie DBA is back: D, life was much easier as developer. For a week ago I started to have problem with Check Database Integrity Task in my SSIS pack...
We updated a server to 2005 this weekend got the problem with DBCC TRACEON(20<img src='/community/emoticons/emotion-11.gif' alt='8)' /> and excel...
Anybody that has script from DMVs (if possible) that gives when information when table is last accessed.
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on...
Separate names with a comma.
