Viewing 15 posts - 646 through 660 (of 1,353 total)
Why or how does this matter?
It makes the database a little more robust because isolating the system tables from the data tables and indexes reduces the chance that the system...
May 4, 2015 at 9:11 am
It's not just the defaults. Almost every database I come across has a single PRIMARY file. I always separate the system tables out like so:
USE MASTER
GO
--Note: Filepaths...
May 4, 2015 at 6:55 am
We do code reviews. I review all the TSQL and database object creation. Our senior programmer reviews all the code. This is especially so for new employees/consultants.
April 24, 2015 at 6:56 am
The "no business logic in the database" argument is regularly used to doom projects to failure by assigning data integrity maintenance to the front end and forbidding the use of...
April 21, 2015 at 9:46 am
"Business rules" has a meaning that is generally understood within the development community. It doesn't refer to the relationship between tables. At some level, that is a business...
April 20, 2015 at 1:45 pm
"In my opinion, all external database access should occur through stored procedures."
I don't disagree with this out of hand, although if dogmatically adhered to rules out using batch updates. ...
April 20, 2015 at 1:32 pm
"Best Practices" is so overused
This is a response I've seen from designers who don't think primary and foreign keys are important. And that's just the start. And it...
April 20, 2015 at 1:18 pm
For index changes, I believe SQL will leave the fillfactor the same as it was on that index.
True, but since we weren't talking about altering an index, I was trying...
April 20, 2015 at 1:11 pm
The function of a relational database is to enforce the business rules
No, it's not. The function of the database is to store information in a manner from which it...
April 20, 2015 at 12:58 pm
Someone argued that stored procedures are not able to scale.
It could be
If stored procedures related to the database in a way that they could be placed on separate servers apart...
April 20, 2015 at 11:07 am
There are no "ivory towers" where I work
There are no ivory towers where I work either. But there is the expectation that all know and understand best practices...
April 20, 2015 at 10:12 am
there is a pre-set default fillfactor, but I've seen it set as low as 70%, it's not automatically 100%.
What does this mean? The default is 0 (100%). If...
April 20, 2015 at 9:47 am
There are some logical items in SQL Server that are very efficient and certainly you may want some calculations to be consistent no matter how the data is calculated.
Could...
April 20, 2015 at 9:38 am
The simple way to go about it is to drop all indexes , then create the clustered index , then the non clustered ones. Not 100% but this method may...
April 20, 2015 at 9:30 am
I agree with the previous comment regarding language. We should be able to express ourselves more professional. I'm not above swearing, but I don't swear at others or...
April 20, 2015 at 8:37 am
Viewing 15 posts - 646 through 660 (of 1,353 total)