SQL Server is a relational database management system from Microsoft.
1
vote
3answers
136 views
Is it OK to create and drop databases during unit tests
I am working with EntityFramework 6 code first approach and SQL Server 2014 Express. However, the DBMS may change in future.
That setup allows easily to create a database and add some dummy data for ...
0
votes
0answers
32 views
Writing to a txt file in SQL
Both these methods work.
But which is better practice in a DEV/INT/QA environment? SPs or CMD command?
--method 1
DECLARE @OLE INT
DECLARE @FileID INT
EXECUTE sp_OACreate '...
1
vote
0answers
53 views
T-SQL Development debate, which is the correct approach
The company I work at uses stored procedures (and a home-grown ORM) exclusively for all database interaction, selects, updates, deletes.
We have numerous procs that will insert and/or update and/or ...
1
vote
1answer
147 views
Polling versus push notifications
I have a hybrid web app for android. The webpage or website the app shows is in asp.net. The javascript for the webpage running in the webview of the app is sending out an ajax request every 10 ...
0
votes
3answers
69 views
Excute Procedure in Parallel or Async
I have inherited an application which performs approximately 100,000 executions in a C# for-loop against SQL Server.
for (int i=0; i<100000; i++)
{
//Execution can take 0.250 to 5 seconds to ...
0
votes
0answers
20 views
Using SQL Server CONTEXT_INFO in Classic ASP for Auditing
I'm migrating a classic ASP site to ASP.NET MVC. As part of the migration, we've moved the database from MS Access to SQL Server, and have set up basic trigger-level audit logging on the SQL end of ...
7
votes
6answers
473 views
When should I use stored procedures?
If I have all my business logic in code and make use of Entity Framework, in what situations (if any) would I be better moving some business logic to a stored procedure, instead of keeping it all in ...
2
votes
1answer
49 views
Handling a violation of n multiple unique constraints in insert
I have an asp.net mvc 5 site.
I have a places table / POCO with 3 unique constraints (URL, Email & obviously ID).
Users are able to add places - but they may violate URL or Email unique ...
0
votes
1answer
64 views
Single Database Vs Multiple Database on SQL Server
we have web application which stores information in backend SQL 2014.
currently the way is set up that central database stores all key information for the customers and then we have seperate database ...
9
votes
1answer
246 views
Partial name matching in millions of records
We have developed a web based application for name matching. It operates by breaking names into parts and the Soundex value of each part is stored in a database. The Levenshtein distance metric is ...
0
votes
1answer
39 views
How should I handle Stored Procedure parameters that need to be the same length as a column?
I'm writing a lot of stored procedures for a SQL Server database that take an id or code that is a CHAR instead of an INT. Most of these haven't changed size in a long time, but when a customer wants ...
1
vote
0answers
39 views
Microsoft SQL server R Services GPL
R is licensed under GPL.
How does Microsoft offer SQL R services without providing the source code for the SQL server.
It does provide a the source for the R base packages.
Does this mean that any ...
0
votes
0answers
101 views
Generating reports from large datasets
I'm working on an CRM type application(.NET, SQL Server) that needs to generate reports from large datasets, millions of database rows in a dozen different tables with a lot of aggregation and logic. ...
-1
votes
1answer
71 views
ASP.NET - Data Encryption & Decryption framework designs
I have the following app scenario where i would need to implement the cell-level encryption.
Database - MS SQL Server
Web Technology - ASP.net MVC
Existing app scenario:- Currently the web ...
-1
votes
2answers
212 views
Why use using-statements when you want to reopen connections? [closed]
In a Winforms project I've been working on recently, I've been dutifully using using-statements for objects that implement IDisposable. I want to reopen a database connection, however because the ...
-1
votes
1answer
183 views
What's the best way to populate a new row in a database?
Is it possible to add a new row to a database using DataSet? When I created a new DataSet and dragged the table from the database I could see that in the DataSet methods there was one called insert ...
2
votes
3answers
64 views
Mirror data from SQL Server to MySQL on a computer with dynamic IP
Here is my problem, I have a task to create an android app to display data from our SQL server, the problem is our SQL server is not online.
We have a MySQL server too, the MySQL server is online, so ...
0
votes
0answers
30 views
What is needed server side in order to feed excel pivot users?
Our company has a lot of different business service "silos". They come with their client software, but they do not interop or offer cross domain searches. It is hard to compile the costs of a project ...
1
vote
1answer
62 views
Database Object That Reads From Two Tables and Writes to One
I am updating a database design that must be compatible with old and new applications. My goal is to make a design change which minimizes impact on the existing code.
The Design Change
Currently our ...
-1
votes
2answers
76 views
SQL query - split and run parallely?
I have a master table T1 which has 1000 records and a ColRef a key column.
There are lots other tables all linked by ColRef.
I have a Stored procedure which takes few hours to process.
I want to ...
1
vote
1answer
149 views
Using Entity Framework as substitute for SSIS, SSAS and SSRS
At the moment I have three different sources where my data are. 1. A Dataprovider, 2. inhouse access DB and 3. Salesforce. Now I want to build a datawarehouse (using ms software) where I want to store ...
2
votes
0answers
55 views
Better dynamic user permissions
I support an Internal ERP system and an external Reporting/Dashboard that our customers use that both use the same database.
Internal normal application users can control what customers can access ...
2
votes
0answers
51 views
SQL - Locating closest value in a set
I have a table that contains the percentiles from a reference data set.
CREATE TABLE [Core].[RiskFactor](
[SpecialtyCode] [char](2) NOT NULL,
[RiskCategoryId] [int] NOT NULL,
[Percentile] [tinyint] ...
1
vote
2answers
112 views
How to model the database tables for calculating on peak and off peak usage data
I am using MS Sql Server and my system contains power usage data in one table as timestamp and values for KW(two columns). This data is collected at 1 hour interval.
At the end of the month I need to ...
1
vote
0answers
26 views
Offsetting high usage in a multi-tenant database environment?
I'm writing a research essay over distributed cloud-based systems, and one of the topics that I'm trying to touch on is potential solutions to high database utilization in a single-database multi-...
2
votes
4answers
148 views
How does a query execution plan affect query execution?
I have read some articles on SQL Server query optimization. The point I get is SQL Server generates a query execution plan for each stored procedure when it's executed for the first time. Those ...
4
votes
1answer
57 views
sql server driver scripts seem awkward, is there a better way to batch sql scripts?
I've been writing 'driver' sql scripts (is that the correct name?) to run multiple sql 'sub' scripts in order, writing errors to log file etc. My Oracle version seems to be more or less ok, but my sql ...
2
votes
0answers
87 views
ODBC 3 Multiple Statements vs Multiple Connections
So right now I have a single thread to handle all the requests for the database. Let's say I have 400 requests per second for logins / logouts / other stuff, and 400 requests per second which are only ...
5
votes
3answers
267 views
Use of booleans in a database
I'm using Visual Studio 2013, .Net 4.5 and SQL Management Studio 2012. I have a table that tracks offices in my database. On the application side there are a some display rules regarding the layout ...
0
votes
1answer
79 views
Why storing a payroll in XML type field would be good or bad
We have a PAYROLL issues by the client to make it dynamic i.e. to make the whole process computerized.
It includes:
Employees
Allowances (Scale wise, which could change yearly or monthly or ...
0
votes
0answers
88 views
Authenticate to a SQL Server with Active Directory credentials from a UWP app
I've been tasked to design an application and a database to store information our company's electricians have measured on-site. We need to save in our database who exactly did which measurement.
...
4
votes
2answers
105 views
Why are triggers seen as a last resort to solve multiple paths in cascading deletes?
There is a problem using ON DELETE CASCADE on foreign keys in a SQL database if there are multiple paths from the root foreign key to the leaf. The way around this seems to be to replace the ON DELETE ...
2
votes
2answers
127 views
can a single SQL Server connection be shared among tasks executed in parallel
Can a single SQL Server connection be shared among tasks executing in parallel? Each task would dequeue an item from a ParallelQueue, instantiate a SqlClient command, and insert a row into the table. ...
-4
votes
1answer
130 views
Migrating MYSQL functions and stored procedures to SQL Server
The company i'm working for is selling HRIS management software. It was built using ASP and mysql. But one of our client's demand is for it to be based on MS SQL Server. our team is made up mostly of ...
2
votes
1answer
49 views
Questions about developing for azure
We currently have a .Net MVC web app with a SQL server back-end database and two web services that perform periodically some computing tasks in the database.
I am thinking of packaging this app for ...
0
votes
1answer
2k views
Best way to get push notifications to server from ms sql database
I partially found solution to my question but I'm not really satisfied with the result.
My application consists of ASP.NET MVC + MS SQL Server.
The case is as follows:
External app saves data ...
4
votes
1answer
80 views
How can we rollback a database synchronized over multiple systems?
On a mobile device, a set of operations has been saved in the local DB with a wrong date (because the system date was set in the future). Then the device regularly doing synchronisation with a server ...
0
votes
1answer
217 views
Create an item in two different table with auto-increment C# SQL [closed]
First of all, let me apologize because I know my question will be very confusing since my English is pretty bad.
I am working on a project for a company, mainly create a system to take care for ...
2
votes
1answer
55 views
Adding a complex check constraint
I am working on a table that has a compound primary key that includes a date.
Faculty
PersonId StartDate EndDate Title ....
-------------------------------------------------
I will add a ...
3
votes
2answers
248 views
One wide table or multiple themed tables?
I'm trying to design a database for a simple text based game where the player characters have a large number of statistics that I want to track. Currently I have a few groups of related statistics, ...
3
votes
2answers
92 views
Stored Procedure performance
I'm working on upgrading an application written by a former developer at my work and I've been converting all the SQL queries in the code into Stored Procedures. I'm doing this with the idea that it ...
1
vote
1answer
73 views
MS SQL Server Cell level Encryption options
Recently, i got the task of doing some research into the data encryption at the cell level. I tried using the Symmetric key (by passphrase) & second option i took is Symmetric key (by Certificate)....
0
votes
1answer
79 views
SQL Table With A Call To Action?
This is all done in Microsoft Access 2007 and SQL Server. We are creating a way for our users to quickly make notes on a customer. These quick-notes will contain tags that will prompt the user for ...
1
vote
1answer
529 views
Multi-tenant database design
My boss is currently working on a database design for a multi-tenant capable ERP/CRM system, which will have a Sql Server backend.
Some key points of the design:
A server instance will host a "...
0
votes
3answers
351 views
Why does databases use text? [closed]
This might be a little dumb question but why do we save text in the db instead of something smaller?
Couldn't there be some other way to store data in the db like in a compressed form, and then have "...
0
votes
1answer
178 views
Optional text qualifier in CSV file as input to SSIS package
I receive several CSV files each quarter to process through an SSIS package, and the formatting is inconsistent. This quarter, I encountered what I term optional text qualifiers--text qualifer of ...
1
vote
1answer
16 views
Syncing graph of data to other database (like data)
Switching to new system and need to keep old data going for some time. So, we need to update old database with data when new system being updated.
It's a transactional data, like orders/shipments. ...
-1
votes
1answer
448 views
Connect to MS SQL database from client side [closed]
I had a software that was written on VB .Net and used Crystal Report to print out reports. It was a pain to maintain in my case, so I want to move the report to webpage version.
I did some ...
1
vote
1answer
155 views
Is it a good practice to write distinct queries in a single stored procedure based on input parameters
I am going through the stored procedures written throughout our project and see that multiple distinct queries are written inside a single stored procedure and are called by passing different values ...
1
vote
3answers
286 views
Using auto-increment clustered key and guid primary key together
My boss is the db administrator in a new software project and he came up with that design where every table will have both a auto-increment clustered key and a guid primary key (or possibly composite ...
