162 reputation
5
bio website pcgroup.co.il
location Israel
age 31
visits member for 2 years
seen Jul 23 at 8:33

You can contact me at my web site - Website Design And Program Development


Feb
26
awarded  Popular Question
Jan
26
comment SQL Server 2012 Managment Studio not saving auto recovery files
Thank you for the info. In my temp folder I just had an empty 0 bytes file .~sql file :(
Jan
26
accepted SQL Server 2012 Managment Studio not saving auto recovery files
Jan
26
comment SQL Server 2012 Managment Studio not saving auto recovery files
I wonder why microsoft tend to ignore those important bug reports that they always get
Jan
22
asked SQL Server 2012 Managment Studio not saving auto recovery files
Jan
22
asked View scripts ran by a specific user?
Nov
20
accepted How to rollback changes made to the database by a specific user?
Nov
18
asked How to rollback changes made to the database by a specific user?
Jul
13
awarded  Autobiographer
Sep
4
accepted Does 'Cities' deserve a separate table?
Sep
4
awarded  Supporter
Aug
19
comment Does 'Cities' deserve a separate table?
1.Should I really go that far? Could you please give an example something 'bad' happening if street is in Customers table? Is normalization for address field crucial? (from what I understood normalization is not a commandment but should be used when you see an actual benefit)? 2.How come number 2 in your answer 'generating a query to distinct' has anything to do with the 3NF (which says that all fields will be dependant only on the pk)?
Aug
19
comment Does 'Cities' deserve a separate table?
I must say you make an impression that you're pretty good in these academic excersices.. Would you consider separating cities anyway in case that in the future there might be added city_population or for the other benefits mentioned (some space&faster populating combobox) even that it doesn't violate normalization?
Aug
19
comment Does 'Cities' deserve a separate table?
1.How does this alleviates duplicate city name entries? Right now I have a combobox populated from distinct query with an option to add new city, if I seperate it to another table they can still add city 'foo' even though 'Foo' already exists? 2.Do you mean there's something else beyond what u mentioned explicitly by saying "its good design"?
Aug
19
asked Does 'Cities' deserve a separate table?
Jul
26
awarded  Scholar
Jul
26
accepted Is adding rows better then adding columns in case their value is not consistent?
Jul
23
comment Is adding rows better then adding columns in case their value is not consistent?
@HLGEM - Believe me I respect what you people say much more than you think, I'm arguing because I want to UNDERSTAND it myself as well, not just BELIEVE you (and I do believe you!), I'm looking for several examples / circumstances where separate products table would be more efficient than products as columns. (And I do have special different table for reports), the products info is just to store the price of product for that particular customer because prices vary from customer to customer..
Jul
23
comment Is adding rows better then adding columns in case their value is not consistent?
Thank you for giving a practical example because this helps me understand the most. I do have to save detailed sales history, but even if I make a separate products table it won't help, because they deliver to the customers few times a week, the products info is to know how much to charge the customer (each customer has special price). After every purchase I save the details in a special 'Sales_History' table. About your assumption - it's half true. it is a small shop, but they do want many various reports (highest sale, total profit etc. etc.)
Jul
23
awarded  Student