sql-server which owner should i use?
i have about 10 scientists writing to a mysql database
i have migrated to sql server and now i have to deal with OWNERS
does it matter which owner i choose? when i do automate migration frmo mysql to sql server it assigns DBO. is that OK? should i continue to use that?
so now i have to do:
SELECT TOP 1000 [rid]
I'm building an application that needs to query a lot of data that is written once and not changed anymore. Should I use MySQL for that or should I use something like SimpleDB or BigTable? (I need to
In MySQL, in which cases should I use REPLACE and in which ones should I use UPDATE. Adding to this as a bonus, in what cases should I use a combination of DELETE and then INSERT in comparison to the
I have a big rhyme database with 360000 words (entries). Every word has a category (for example: 'sheet' and 'meet' have the category 'eet'). A query to find suitable rhymes is somekind of slow on my
Which of Zotero's export format would you recommend regarding - the portability with similar programs - possibility of reading and adding new entries with a Perl script?
I often see the abbreviation en-US, which corresponds with the 2-character language codes standardized in ISO639-1. I also understand that the format of language tags generally consists of a primary
I got 2 classes: A(Activity subclass) which generates the phone location infinitely and class B (thread subclass) which takes the location from A and send it to the db. Since it's an activity it's sto
While setting WCF client service configuration, there is an option collection type which defaults to System.Array. If I change it to Generic List, is there any performance loss?
I am trying to figure out which data types I should use for my tables. Does someone have a very good, simple, tutorial on SQL Server 2008 datatypes (has to be practical!) ?
Which Timer object should I use in long running processes in .Net? The timer will be used in a Windows Service, and I wish to find the best fit performance wise.
Which Google API search module for Perl do you recommend? REST::Google::Search or Google::Search Ease of use is important because I only really need to get the top two, maybe three results from the we
Flex vs. PHP: What are the pros and cons of each? Which language should I use?
I'm thinking of doing some experiments on WebCL. I'm good in OpenCL/CUDA on GPUs. How different is the experience in general and which implementation should I use? Samsung or Nokia.
A quick question, I got this news app that I want to recode to study Android programming better. It looks like this: http://prntscr.com/4k1fuf The entire page can only be vertically scrolled, unless y
I are using EJB 3 on a fairly large J2EE project, by default with Netbeans sets the persistent provider for the entity beans to TopLink. There is the option to change the provider to one of the follow
Im currently working on a project that has a requirement to be able to generate reports.. I first thought of using telerik for this but their control is too limited and I'm now looking for a new repor
I have web service designed for Mobile applications. This web service accesses the MySQL database. There may be many users who runs the mobile app say 100000 concurrent. I am very much in confusing th
Which package from CPAN should I use to send mail? Sometime the timtowtdi approach is very tiring. For me, especially when it comes to package selection. So all I want is to send email, potentially HT
I want to start a project in which I want to do authenticated boot for Android based on ARM's TrustZone technology. Which board should I use? The minimal requirements: ARM V7 instruction set USB, VGA
I am trying to write a kind of simple search engine. I have a determined number of main subjects that are associated with specific keywords. The aim is to recognize the main subject from an input part
I am a Mac/Ubuntu user. I have folders such as AWK, awk, awk_tip and awk_notes. I need to archive them, but the variety of utilities confuse me. I had a look at Tar, cpio and pax, but Git has
I am trying to crawl a website which loads pages if i click Show more products. I am using perl mechanize. Here is the content I got from the website. What should I specify in click_button() so that
I've a problem while working with JQuery UI. What I'm trying to achieve is this: I have a sortable list ( .form_container ), with objects. When their position are changed, ajax call updates the DB. O
I have a situation in a project I am currently working on at work that has left my mind restless the entire weekend. First, I need to explain my scenario, and the possible solutions I have considered.
Which type I should use to save many objects with same key? I should post data to server where one of parameter is suggestedTo and it contains userId. This parameters should be more then one. So I'm c
I'm wondering about which driver is the best between the following : mongodb-csharp driver simple-mongodb driver NoRM which one consider the best !>
The current (as of Dec 2008) iPhone SDK allows me to pick between 3 versions when I want to build an app: 2.0, 2.1, 2.2. -- I'll ignore 2.1 below. My assumptions: 2.2 has more API functions available
Should I use a local copy of jquery, or should I link to a copy provided by Google or Microsoft? I'm primarily concerned about speed. I've heard that just pulling content from other domains can have p
I am in python and there is a lot of ways to access files. Method 1: fp = open(hello.txt, w) fp.write(No no no); fp.close() fp = open(hello.txt, r) print fp.read() fp.close() Method 2: open
In my app Users can Like Programs. Each of those is a model, Like is polymorphic. At some point I will want to see all the Users that Like a Program or all Programs a User Likes. Is it better to have
I have a nodejs application and I want to write data into hadoop HDFS file system. I have seen two main nodejs libraries that can do it: node-hdfs and node-webhdfs. Someone have tried it? Any hints? W
I am currently building a module for the Linux Kernel. My working revision is 3.8-rc3+. My work lead me to implement some ioctl() commands. As you know, my commands should return an appropriate error
What are the scenarios in which I should use timestamps? I know what a timestamp is, but I'd like to hear how it's helped folks in real-life projects.
I was about to use the aside tag, but it's not for sidebars apparently. So, what HTML 5 tag should I use for a sidebar that would contain links of related articles, last posts added and popular pos
Difference between equal to and exactly equal to term comparison operators explains the difference, but an important question is also: which one should I use, when I don't compare floats to other thin
I have been using com.sun.org.apache.xpath.internal.XPathAPI for some time and it seems to work ok. Recently I tried to use the TPTP profiler in Eclipse but it could not find the XPathAPI class. I hav
I want to generate signed APK in Android Studio and it offers me an option to run ProGuard. It asks me to give config file path, but I don't have config file. How to create one? Should I use ProGuard
im working in a Django project that aims to manage warehouses, items and presonell. I have the following models: WarehouseMode, ItemModel and PersonellModel. The admin must be able to create users and
I am writing a simple tool to check duplicate files(i.e. files having same data). The mechanism is to generate hashes for each file using sha-512 algorithm and then store these hashes in MYSQL databas
I'm running Django (1.5) on App Engine and I need to use some kind of key-value cache. I know App Engine's memcache API and also the Django's cache framework. I wonder which one should I use. On one h
I have been requested by someone starting a non-profit organization to build their website. They basically want to have users be able sign up, create profiles, send messages, etc. and then have chari
I have a number of custom objects of type X. X has a number of parameters and must be unique in the collection. (I created my own equals method based on the custom parameters to examine this) In each
I initially saw this: http://facebooksdk.codeplex.com/ but than found out https://github.com/facebook/csharp-sdk now, which should I use?
I'm woring against a model which consists of a number of different types (Properties, Parent, Child, etc). Each type is associated with a set of functions from a c api. For example: Type Properties:
I want to create a game for smartphones and I don't know where to start. There is so many game engines out there and I have no idea which suits me best. Here is what I want: develop on a ubuntu compu
I've noticed there are a few solutions to allow the use of memcached on C# / ASP.NET: memcacheddotnet enyim.com Memcached Client BeIT Which one should I use? It seems like the enyim port has more ac
I have a table which contains a location of all geographical locations in the world and their relationships. Here is a example that shows the hierarchy. You will see that the data is actually stored a
I would like to develop one application which record voice messages and stores in cloud. it works like this 1) user calls mobile phone and record message. 2) The recorded voice message/voice mail sho
I'm looking to build a web interface for an existing Ruby app and I'm trying to figure out which version of Rails to use - the latest current version 2.3 or the soon-to-be-released version 3.0. The re