Viewing 15 posts - 19,546 through 19,560 (of 49,552 total)
To what tables?
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 27, 2012 at 7:36 am
Brandie Tarvin (3/27/2012)
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 27, 2012 at 7:34 am
Which of those tables needs to reference one or more of the others? So what 'foreign keys' do you need?
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 27, 2012 at 7:10 am
Ok, put them in for now. So what do you have at this point for entities and attributes?
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 27, 2012 at 7:06 am
If you think they are part of order then put them there, if they don't belong it'll be picked up later. Just don't say description, that doesn't give enough details....
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 27, 2012 at 7:01 am
Is it just me, or does a term like 'That can be done, but people usually learn better' rankle when applied to something you've said?
Feels a little condescending.
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 27, 2012 at 6:54 am
I had a feeling this was homework...
Seriously, what else constitutes an order? Think about orders you've placed before, online sites or the like.
These tables and this design is so simple...
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 27, 2012 at 6:51 am
Looks to me like that's mostly done.
Does orders really only have an order date? No other information about what was ordered and how much was paid?
Last step here 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
March 27, 2012 at 6:34 am
Ok, terminology problem here...
Statistics in SQL Server are objects that are stored in the database, you;'ll see them listed in sys.stats. So when you said 'statistics getting dropped', people would...
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 27, 2012 at 6:30 am
Eugene Elutin (3/27/2012)
Even, with using GUID's, if you want your client/middle layer to be super fast, you would want to cache pre-allocated range of keys.
Why would you want to cache...
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 27, 2012 at 6:26 am
So the 4 entities that you've identified are:
Customer
Order
Stock
Supplier
Next step, which of the attributes that you've identified belong to which entity?
p.s. CustomerID sounds like an artificial primary key, like a identity...
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 27, 2012 at 6:19 am
First step: Identify entities and candidate keys. What different 'things' are there in that set of attributes? What column or set of columns uniquely identifies a row in that each...
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 27, 2012 at 6:02 am
Eugene Elutin (3/27/2012)
GilaMonster (3/27/2012)
Eugene Elutin (3/27/2012)
Nothing wrong with a guid primary key...
Nothing wrong! But with a real life experience you learn, that it would be much better to stick with...
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 27, 2012 at 5:58 am
A large log (and 9GB is far from large) will not impact performance. Lots of VLFs (regardless of log size) can and do affect performance of backups, database recoveries 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 27, 2012 at 5:12 am
It's materialised from the row version store, so it will be in memory, spill to TempDB if necessary.
Where it is is not important though, it is just referenced by the...
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 27, 2012 at 5:10 am
Viewing 15 posts - 19,546 through 19,560 (of 49,552 total)