Viewing 15 posts - 8,761 through 8,775 (of 49,552 total)
What's the definition of the procedure?
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
June 12, 2014 at 3:05 am
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...
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
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.
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
June 12, 2014 at 2:20 am
Dormant (sleeping) sessions aren't doing anything. Therefore they cannot be using CPU.
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
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.
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
June 11, 2014 at 11:45 am
dax.latchford (6/11/2014)
My concern is that this would have broken the chain
No.
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
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...
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
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.
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
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...
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
June 11, 2014 at 2:31 am
Create foreign keys between the tables and have ON DELETE CASCADE set on them.
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
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...
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
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...
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
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)
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
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.
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
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,...
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
June 10, 2014 at 11:47 am
Viewing 15 posts - 8,761 through 8,775 (of 49,552 total)