SQL Server is a relational database management system from Microsoft.
-1
votes
1answer
56 views
When to use non-embedded databases over embedded databases
We are trying to start a web base project that need to develop based on MS technologies such as C#,.net, IIS etc. This is a web application suppose to sell as a product with a single installer.
Now ...
2
votes
3answers
155 views
How do I cache data that rarely changes?
In my ASP.NET application there is some data that doesn't change often and so there is no point in querying the database to re-check it every time.
In my current situation I am checking user ...
1
vote
2answers
364 views
Data Transfer Best Practices
At my company we have some vendors that we transfer data to and from. Sometimes the data is pulled into our local SQL database for business reporting. Other times we pull data from one vendor, ...
1
vote
2answers
54 views
Could someone help me understand SQL TDE Database encryption?
I don't quite follow how it works. According to the MSDN Article there is a big hierarchy of keys protecting other keys and passwords. At some point the database is encrypted. You query the database ...
0
votes
1answer
75 views
How should I evaluate the Database Solution for Large Data Application
Background
I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
3
votes
2answers
71 views
Handling changes to data types and entries in a database migration
I'm fully redesigning a site that indexes a number of articles with basic search functionality. The previous site was written about a decade ago, and I'm salvaging about 30,000 entries with data ...
0
votes
2answers
259 views
Using lucene and sql server togheter. Newbie needs directions [closed]
Basically the whole thing can be explained simply:
I need to index one or more SQL Server 2005 databases with lucene so I can search the various records.
I found a lot of examples and documentation ...
7
votes
4answers
387 views
What exactly does it mean that storing “large blobs in the database reduces performance”?
To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...
2
votes
4answers
419 views
Database is performing slow, even all the tables are having normalization
One of the interviewers asked me this question:
Tables are created with appropriate normalization rules, However the database is performing slow. [Ie.: The select, insert statements are taking ...
-1
votes
1answer
236 views
Increase speed of a VB.net Application to SQL server 2008 and Hamachi VPN [closed]
Our current Information System (complete with path for pictures for records stored in db) has the following specifications:
A desktop application was developed in vb.net
We use SQL server 2008 r2 as ...
0
votes
1answer
118 views
How can I consolidate data from a group of remote SQL Server instances?
I work for a company whose point-of-sale service uses IIS servers tied to static IP addresses at each of our stores. My boss wants a better real-time stat tracker than what the point-of-sale service ...
1
vote
4answers
176 views
How to factor out data layer in nopCommerce and replace MS SQL with RavenDB?
I am new to nopCommerce and ecommerce in general but I am involved in an ecommerce project. Now from my past experiences with RavenDB (which mostly were absolutely pleasant) and based on the needs of ...
-4
votes
1answer
1k views
how to write a stored procedure to insert data in to a sql server database in a datagridview in a form?
I need to insert data through a form using a datagridview connected to a SQL Server 2008 R2 database. is it ok, if I write a single insert stored procedure query in a while loop in the form.cs
1
vote
3answers
431 views
Best way to process a queue in C# (PDF treatment)
First of all let me expose what I would like to do : I already dispose of a long-time running webapp developed in ASP.NET (C#) 2.0. In this app, users can upload standard PDF files (text+pics). The ...
5
votes
2answers
89 views
Tracking changes to posts
I'm currently in the process of writing a support ticket system... Let's say it's a small forum application, or something like Uservoice.
Now I want my users to be able to edit their tickets, but ...
0
votes
1answer
136 views
Different ways to generate the latest int type primary foreign key in code
I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key in the other. The type of the keys is integer. Now I want to generate the keys in the code and assign ...
1
vote
1answer
220 views
Running SQL Server Express on Micro/Extra Small VM
I'm exploring options for running a small cloud Windows Server (either AWS EC2 Micro or Azure Extra Small).
The server won't be hit very hard, but I need to run a simple relational database, which ...
1
vote
1answer
251 views
Reading CSV files located on a Linux server and updating the tables in a SQL Server database
I was wondering how we could ingest CSV files located on a Red Hat Linux server into SQL Server database tables.
I know we can write a stored procedure/bulk insert to read the files that are located ...
0
votes
1answer
242 views
Are there any SQL servers that support compiled queries?
Can SQL queries be compiled into byte code or equivalent to enhance performance?
I know that most database servers support prepared statements, but is that the same thing as compiling? Most ...
-1
votes
2answers
361 views
SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]
When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
0
votes
2answers
275 views
Will SQL Server autonumber reuse a value if a record is deleted?
The titled basically states it. If I have a bigint column with primary key and autonumber, and a record is deleted, will SQL Server ever reuse that now available value?
The underlying issue is that I ...
2
votes
1answer
360 views
JOIN vs. INNER JOIN and FULL OUTER JOIN
I know there is a difference between INNER JOIN and FULL OUTER JOIN, I can see it, but, what is the difference between the two following: JOIN ... ON... and INNER JOIN...ON... and still yet ...
0
votes
4answers
254 views
Storing application users in SQL: create a new “Users” table or use built-in database user management?
I am specifically interested in SQL Server, but the same question applies in general. When creating a new application, the way I see it, there are two options:
Create a table called "Users" and ...
3
votes
1answer
380 views
Rewriting C# Formula Calculations in T-SQL
We have a 3-tier application with a C# client that connects to a C# web service via WCF and requests data from a SQL Server database.
One feature in our application is a user-created form app in ...
2
votes
4answers
484 views
ado.net or EF for a point-of-sale system
We have a point-of-sale system that was developed using ado.net, our current concern is to make the application real fast in creating transactions (sales). Usually there are no performance concerns ...
0
votes
1answer
185 views
Advanced Search Stored procedure
So I am working on an MVC ASP.NET web application which centers around lots of data and data manipulation.
PROBLEM OVERVIEW:
We have an advanced search with 25 different filter criteria. I am using a ...
0
votes
2answers
119 views
Full Text Search Strategy For My Website
I have a website that allows users to search for items in various categories. Each category is a separate area (page) of my website. For example, some categories might be cars, bikes, books etc. At ...
3
votes
3answers
2k views
Best practice for storing HTML coming from text fields to a database?
I have an application that allows users to edit certain parts of text and then email that out. My question is what is the best way to store this in a Microsoft SQL Server database. Right now I have ...
0
votes
0answers
62 views
What is a solution in keyword trend analysis with a FreeText field in SQL Server 2008R2?
I am currently using a SQL Server 2008 db, where in a table, I have a freetext field defined.
I would like to perform some trend analysis on one field, where I would provide the base for the trend, ...
8
votes
3answers
762 views
Using Sql Server Change Data Capture with a frequently changing schema
We are looking into enabling Sql Server Change Data Capture for a new subsystem we are building.
It's not really because we need it, but we are being pushed for having a complete history ...
3
votes
1answer
118 views
Database Design - Optimise Relationships
I am about to embark on a redesign of an application, one where querying the database is particularly annoying. I intend to redesign the database as much as possible but the data shape cannot change ...
1
vote
2answers
184 views
The Proper UML Model of a System for Non-Technical Boss
I've taken on some side work for this non-profit and last week was my first week on the job. They have two SQL Server Databases each with many tables in them that represent over 20 different ...
0
votes
3answers
170 views
Keeping SQL Server DB Up to date in Team environment [duplicate]
We are working in a Visual Studio Environment using TFS.
When developers get the latest source code it includes a copy of the 'update' sql scripts for the database of the application.
The challenge ...
0
votes
0answers
43 views
XML vs SQL for content display on an ecommerce website [duplicate]
I am in process of developing an e-commerce application which is using SQL Server 2008 as a DB. I was suggested to use XML for content/product display, I bought the idea of using XML as a datasource ...
2
votes
3answers
143 views
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries.
The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
1
vote
6answers
875 views
Wise way to implement a website login and database tables for a small shop
Im building this website for a small store and I was told that its better not to keep the login and the rest of the users information on the same table.
Now im wondering, what is the best way to ...
0
votes
3answers
164 views
SQL Server + database design and non mandatory fields
I am developing an app which allows a user to upload a maximum of 20 photos, the straight forward way is of course adding 20 columns to my database table but if the user only uploads 1 image, the ...
0
votes
0answers
209 views
Best option to send image from javascript client to SQL server
From a client (browser), using javascript I want to send an image to sql server ( and store with user profile) (sql server), along with other data such as user id or name.
Which option is better? ...
0
votes
1answer
961 views
Oracle Database Integration with Team Foundation Server?
So my company is using TFS and SQL to Manage their Database (MS SQL Server). It integrates with the nightly build servers to do builds and produce scripts to build the entire Database. Also the ...
6
votes
4answers
898 views
Should I Do Calculations in T-SQL or Program?
I am creating a stored procedure that is logging some data. The data ultimately needs to end up in 2 tables. The incoming data is coming from a JSON string containing 15 parameters, and the data is ...
6
votes
6answers
973 views
How do I make my ASP.NET application take an action based on time?
I have an ASP.NET MVC4 application. Suppose that I wanted to execute some code (such as emailing a user) 2 days after a user has signed up.
One way is to have code executed on every request which ...
0
votes
2answers
187 views
Should I retrieve one large set of data to filter or smaller individual sets of data?
I have a company intranet that utilizes a similar set of data across many different pages and many different methods.
Speaking in generalities, is it closer to "best practice" to retrieve a large ...
0
votes
3answers
137 views
Search on multiple values
I have a database having around 15 tables.Currently I am working on a report generation page, which is having 16 criteria.The values are distributed among multiple tables.User can select any number of ...
1
vote
1answer
130 views
Way for store User recent playlist in database
Every time when user hears one music on system, the system stores this music to recent list, but I am afraid to pass over than decimal(19,0) limit in future. If I do Reseed I will get some problems ...
-3
votes
2answers
314 views
Best way to get a copy of Visual Studio? [closed]
What's the best way to get a copy of Visual Studio to learn C# and SQL Server on?
5
votes
4answers
366 views
Architecture suggestions on a multi-project multi-database 'intranet'
Here is the situation I have inherited:
We have approximately 10 websites (Asp.net web forms) that each have their own database.
Each of these databases houses some site specific data, and each has ...
2
votes
1answer
158 views
Write data to SQL Server directly from BizTalk or use external service?
An external source will be sending us XML data that BizTalk will pick up and transform into an internal schema. We need this data to be loaded into a SQL Server database as we're going to expose some ...
2
votes
1answer
218 views
Is it okay to convert dataset from stored procedure to IEnumerable
So, I am working on a project with a team and we are using Entity Framework. We basically want to use linq to entities, and not use stored procedures. I use quite a bit of lists and IEnumerables and ...
1
vote
1answer
223 views
Table scaling with partitions or with separate databases?
Let's say I have a table (let's call it BigTable) which could experience 5,000,000 INSERTS per day (with possibly just as many SELECTs). Each row inserted is about 50kb.
These daily INSERTs are ...
1
vote
1answer
49 views
Multiple Display of a Document and persist each viewer change in a single document
i have a scenario where i have to make available a document for viewing and editing to multiple users, the users can edit and view the document at the same time. Now the problem arises here if for ...
