Viewing 15 posts - 8,761 through 8,775 (of 49,571 total)
Luis Cazares (6/11/2014)
I'm not so sure about this, but you could deny delete on your tables/schema. http://technet.microsoft.com/en-us/library/ms176128.aspx
That's an option, but bear in mind that anyone with sysadmin can still delete...
June 12, 2014 at 3:03 am
First thing you can do is turn autoshrink off. That's a setting which should never be enabled.
June 12, 2014 at 2:20 am
Dormant (sleeping) sessions aren't doing anything. Therefore they cannot be using CPU.
June 11, 2014 at 2:53 pm
The first decision that needs to be made is whether you're splitting the data across disks for performance reasons or for backup/restore/recovery reasons.
June 11, 2014 at 11:45 am
dax.latchford (6/11/2014)
My concern is that this would have broken the chain
No.
June 11, 2014 at 10:03 am
It can be a problem when the domain account is removed. For databases most things will work, then a few things (like replication) will give odd error messages. Jobs may...
June 11, 2014 at 3:28 am
Elliswhite (6/11/2014)
You need to go with external software which can resolve it accurately.
No, he needs to restore the backup he has.
2 year old thread.
June 11, 2014 at 2:54 am
To delete from one table and have matching rows automatically deleted from other tables, you need to create foreign key constraints between the tables. When you create the foreign key...
June 11, 2014 at 2:31 am
Create foreign keys between the tables and have ON DELETE CASCADE set on them.
June 11, 2014 at 2:22 am
Ha! That's what I suspected.
That index doesn't support those queries. They filter on the second column of the index only, meaning they have to scan the index. Hence they will...
June 10, 2014 at 1:26 pm
wall str33t (6/10/2014)
Also, are you distinguishing between IN (val1, val2, val3, ...) and IN (SELECT ...), which are processed completely differently?
Yes, this is what I was referring to when I...
June 10, 2014 at 1:21 pm
Looks fine, I'll check them tomorrow.
Can you post the definition of the index please (the create index statement)
June 10, 2014 at 12:53 pm
andrew-petre (6/10/2014)
"Standard edition doesn't have parallelism - it's disabled. We need Enterprise Edition."
Hahahahahahahaha. Nonsense.
June 10, 2014 at 12:08 pm
Jeff Moden (6/10/2014)
But that's what I'm talking about. That doesn't sound "fully durable" to me but I could be mistaken in what my definition of "fully durable" means.
Hang on,...
June 10, 2014 at 11:47 am
Viewing 15 posts - 8,761 through 8,775 (of 49,571 total)