You searched for the word(s): userid:688080

More Search Options

RSS Available

• Re: One big table vs. small ones – multi language application, 1 500 000 rows per each language

  Hi all, thanks for all the useful opinions. I have decided to store the data in a big table. If I’ll see the performance of the Views is not optimal I’ll try to use 4 tables instead the Views and update them once a day. Thanks for help. Marw

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MarwCzech on 7/6/2009

• One big table vs. small ones – multi language application, 1 500 000 rows per each language

  Hi all, I’m trying to do an optimal database design and I’m stuck. In a nutshell what I have and what I’m looking for: - There is a multi language (4 countries) application - For each language I need to store 1 500 000 rows per year - The table has only 4 columns and one FK - There is a view selecting in the actual country: employee, sum of top 10 salaries, count of work shift in a month - Insert into DB is 1 a day, selecting from the view is 1000 a day The question: Shall I store data in one big

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MarwCzech on 7/4/2009

• Re: When I read from an Excel, it doesn't read all the cells...

  Hi, I had same problem. Solutions is simple In connection string set this: Extended Properties = "Excel 8.0;HDR=NO;IMEX=1;ImportMixedTypes=Text;"

  Posted to Other Databases (Forum) by MarwCzech on 10/23/2006