Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:688080
More Search Options
RSS Available
Matching Posts
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
Page 1 of 1 (3 items)
ASP.NET:
Tip#100: Did you know… How to view ASP.NET trace information?
ASP.NET:
Passing anonymous objects to MVC views and accessing them using dynamic
Channel 9:
Channel 9 Live at PDC09: Coding 4 Fun
Channel 9:
Channel 9 Live at PDC09: Stephen Toub
WindowsClient:
Mouse Gestures for Internet Explorer
Channel 9:
Controlling concurrency in Rx
Channel 9:
Dev Tools Ecosystem Summit Videos Available
WindowsClient:
Using Cerebrata's Cloud Storage Studio To Download IIS logs from Multiple Instances of Windows Azure
TechNet Edge:
TechNet Radio: Office 2007 Setup and Configuration (Part 1)
Channel 10:
How-To: Listen to Your Zune Pass Music on Your WinMo Phone
Channel 10:
Share Your Screen with SharedView
Channel 10:
Get Microsoft Tinker Game For Free
Channel 10:
LG eXpo WinMo 6.5 Unboxing Video
Channel 9:
ADFS 2.0 RC is Here!
Channel 10:
Bing Reference Updated with New Sidebar Features
Channel 10:
Look Behind SurfaceScapes
ASP.NET:
Moving your ASP.NET Application to Windows Azure – Part I
TechNet Edge:
Windows Server 2008 R2 Quick Look- Installing the Migration Tools
WindowsClient:
My latest videos – WPF, Silverlight, Sensors, and PDC09
WindowsClient:
Developing an installer for your Surface application
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online