Viewing 15 posts - 9,631 through 9,645 (of 49,552 total)
rani_rahbani (3/17/2014)
I am already trying to create a dynamic trigger.
No, don't try to create triggers which use dynamic SQL to do anything anywhere. That's going to kill performance, maintainability and...
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
March 17, 2014 at 9:35 am
From a presentation on design I did recently:
Business Analysis/Conceptual design
Process of gathering requirements
Identify entities
Identify attributes
Identify business rules
Produces a conceptual model
Logical Design
Refining of the conceptual model
Define the full set of entities...
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
March 17, 2014 at 9:26 am
Jeff Moden (3/17/2014)
First, having the 80 files won't degrade performance. It won't enhance it, but it won't degrade it.
Too many data files can degrade performance. What too many is...
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
March 17, 2014 at 9:22 am
Books Online (the SQL help file) -> ALTER TABLE
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
March 17, 2014 at 8:41 am
Remove the error handling (database side and client side, since both hide the errors) and have a look at exactly what is being returned
Also try running the stored proc from...
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
March 17, 2014 at 8:36 am
What error are you getting?
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
March 17, 2014 at 8:27 am
paul.knibbs (3/17/2014)
GilaMonster (3/17/2014)
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
March 17, 2014 at 8:11 am
You need a script to drop the constraint and another script to enable it, then some component in your SSIS package which checks that the constraint was indeed recreated and...
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
March 17, 2014 at 8:08 am
altana (3/17/2014)
GilaMonster (3/17/2014)
What errors are you getting?p.s. A catch block which just discards the error is not exactly good coding practice.
I doesn't give any error.
Probably because the catch block...
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
March 17, 2014 at 8:05 am
What errors are you getting?
p.s. A catch block which just discards the error is not exactly good coding practice.
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
March 17, 2014 at 7:52 am
And does that requirement have a reason other than 'because I said so'?
You'll have to drop the constraint entirely and then hope you can add it back successfully. Be...
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
March 17, 2014 at 7:50 am
Switch to delete instead of truncate. Removing the constraint is risky, as it leaves a window where data can be inserted which would violate the constraint.
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
March 17, 2014 at 7:42 am
yuvipoy (3/17/2014)
When i delete the TableB with TableA record exists the query is taking long time thats why i came across Not Exists Vs Not IN.how about leftouter join?
Very slightly...
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
March 17, 2014 at 7:16 am
Siberian Khatru (3/17/2014)
assumed the log was truncated as part of the log backup procedure.
It is. Truncate means to mark portions of the log as reusable. It happens 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
March 17, 2014 at 7:15 am
I just love the way a couple of heavy IO operations turns my (5 month old) laptop into a paperweight. Busy shrinking one DB and zipping the backup of another...
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
March 17, 2014 at 6:45 am
Viewing 15 posts - 9,631 through 9,645 (of 49,552 total)