.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Is this worth the effort?

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server

This post comes as a result of a discussion related to this post in the Database Design forum:


I used this table for test purposes:

create table dbo.someTable
( record_id integer not null
  constraint pk_SomeTable primary key
  constraint ck_someTable_Record_Id
   check (record_Id > 0),
 filler char(50)

 L1 AS (SELECT 1  

View Complete Post

More Related Resource Links

EL 5.0 is it worth it?


I have used EL in the past (2.0) and I remember it being a real pain to install and deploy. Has it gotten any better and is it worth the effort?

Is it worth upgrading from 3.5 SP1 to SP2 if I don't want any of the new features?


I am currently running SQL CE3.5 SP1 and have a lot of problems with crashes, access violation exceptions, strange lock errors etc. Is it possible that upgrading to SP2 might help at all with stability, or does it only add new features, not any bug fixes?


How Prepopulated Table will Change into the client PC with minimal effort.


Hello Everyone

I am using SQLCE and some prepopulated table,
but whenever master data will chage so we need to chage my whole code.
Wherever I had wrriten my Category and CoAName so is there any way we can't change my code,
but I am able to access my CoA(Chart of Account Table).


Worth it to start a new project using WPF


In a previous thread "Is WPF dead or going to be" http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/7edc8165-e1a6-4451-ac9c-f112d1d17957 JamiePattison asked, "if its worth learning WPF in case its not used in future". The thread primarily discussed life, death and uncertainty. I am starting this new thread because its focus is quite different. My questions is quite simply: Is it worth committing business resources to developing a new project in WPF?

Since this is the WPF forum, I would expect a lot of support for WPF; I welcome that support. While there are rumors than MS is planning to drop WPF, as far as I can tell they are only rumors and should not be of immediate concern. I am not interested in comments on the viability of continuing to use a dead or dying technology; that subject is irrelevant to the question.

We are developing a suite of programs which will mostly operate on Wintel desktops, laptops and tablets. Some programs will be used by trained experts in the back office; others will be designed for general users in a particular field of study. Some programs will have all information on local machines; others will access information from remote servers. One or two

How to use friendly url's, performance costs, and if it's worth



I am building a web app (a web community) in which about 1000 users will have its own website (standard but customized), and I want that website has a friendly url like http://www.mycommunity.com/petersmith      

With this url in the address bar, I want to show the initial customized web page (called for example: initial_page.aspx) but without showing that page name and extension file, so, only http://www.mycommunity.com/petersmith . I am thinking to use that name of the user at the end of my web address (petersmith) to search in my database which user number is that name, and display the customized data and design accordingly.   

After that, once the visitor has logged in that initial page, I want to show the main page of that user's website, and I think it would be nice to continue displaying in the url the name of the user (http://www.mycommunity.com/petersmith/main_page.aspx). What do you think about this? It has important costs? The user will appreciate this detail of personalization of his website? I think the website http://www.myspace.com does a similar thing with their users, but I ignore if the

Can I Describe a Flat File Source to Save SSIS User Some Effort


I'm a complete SSIS beginner.  I suspect the answer to my question is out there I just don't know enough to construct the search that would find it.

I'm writing a program to generate fixed width format text files from proprietary databases for use as Flat File Sources in SSIS packages.  I know I can provide a header row containing column names.  But I have a lot more information about the file (obviously!).  I know how many columns there are, what the width of each column is, what the type of each column is, etc.

Is there some way I can record the information I have so that the SSIS user consuming my file doesn't have to input all that information through the Import and Export Wizard? 

For example, if I were generating these files for use with the BCP utility I could create a Format File to describe the structure of each field in my data file.  Is there some similar capability in SSIS or do the consumers of my data files have to input InputColumnWidth, Data Type etc. through the Advanced editor dialog box?

8 Of The Best AJAX Frameworks Worth Considering

A Comprehensive list of Top 8 AJAX Frameworks you must know about as a web developer. You can understand the points to consider before choosing one of them.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend