SQL Server is a relational database management system from Microsoft.
1
vote
0answers
36 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
24 views
How to use a relative path in sqlcmd script
Can someone tell me how to swap this absolute path with a relative one for my sqlcmd upgrade script?
-- how can I get rid of the following absolute path?
:SETVAR ScriptDir "C:\absolutePath\"
...
-1
votes
0answers
21 views
SQL Server - Fetch data
Project Case:
Send sms communication on Parent's mobile number on the birthday of either Student or Parent for ACTIVE courses.
Data Model:
Following four tables are in picture here. Course Role table ...
0
votes
0answers
9 views
SQL Server - Sum Until Threshold Reached [migrated]
I have a SQL Server database with shift worked information for each employee. The main table (called "shift_worked") is structured like the following:
id employee_id period day hours
1 ...
1
vote
0answers
44 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
votes
0answers
27 views
Using Neo4j in ASP.NET application when collaborating with SQL Server? [closed]
I'm going to develop an online video platform with the feature of social network using ASP.NET. In the requirements, users can not only upload, watch and download videos, but also make friend with ...
1
vote
1answer
44 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
25 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 ...
2
votes
4answers
92 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
52 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
51 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
179 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
67 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
43 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
102 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
77 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
69 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
44 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
505 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
77 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
138 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
46 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
175 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
81 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
55 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 ...
0
votes
1answer
69 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
307 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
324 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
147 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
367 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
116 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
213 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 ...
1
vote
2answers
186 views
Caching query results vs Querying each time (finding a middle ground)
This is kind of an expansion on a previously asked question
Some background info:
Querying Over 5,000 items from SQL database that eventually get sorted
into a list depending on who the user ...
1
vote
1answer
106 views
Knowing when a SQL table is done updating before Querying
I am using a self hosted windows service WEB API as the layer between my Windows 8 App and a SQL Server Database because Windows 8 apps can't directly connect to SQL server like win forms or pretty ...
1
vote
2answers
774 views
.NET Why should I use DAL over direct database access
Yesterday on one of SO chats I've been told I should never connect to database directly from the application and rather use DAL.
I've been told that:
1. Using something in the middle should improve ...
1
vote
1answer
123 views
SQL - Designing a Threshold value table
I need to design an SQL table to be used for "threshold" or special values, which in general would have the following properties:
- key
- value
- comparer (less than and greater than as a start, ...
0
votes
2answers
1k views
A CLR SQL Server Stored Procedure calling an ASP.NET Web API
We are developing a big system with SQL Server database, ASP.NET Web API 2.2 services and another external services.
We need to load more data on a table while we process the current data on it. To ...
7
votes
3answers
729 views
Enterprise software: Where should the code go? [duplicate]
I recently went for an interview with a software company that claims to write enterprise level software. During the interview, the interviewer remarked that its better to use the database simply to ...
3
votes
2answers
399 views
What do I need for a database server for Mobile-Apps? [closed]
I'm struggling getting my head around writing a server for a mobile app. The app is quite simple and would manly rely on geographic data and some other basic stuff liker users etc. nothing special ...
1
vote
2answers
129 views
To convert to accurate data types or maintain default type of string
Scenario:
I have a web application that records and checks data against two temp tables (1 table being a temp source and the other being a destination for the application). These temp tables are ...
1
vote
2answers
297 views
How do I do SQL Server mapping with a new Desktop application written in C#? [closed]
In 2 weeks I will be starting a new job as a software developer in a company that currently does not employ any professional programmers. My first task will be to rewrite a Excel/VBA application in ...
23
votes
2answers
4k views
NoSQL within SQL Server
This question is not about the difference between SQL and NoSQL. I am looking for some rationale for something that really does not make sense to me at the moment (maybe because of my lack of ...
3
votes
2answers
168 views
How to infer the result of a query?
To understand what a query does, I have always thought the following is the procedure on evaluating a query:
Form the table as specified in the FROM clause.
Pick the rows from that table as ...
1
vote
1answer
429 views
Portable Data in C# App
I have developed a C# front end app for management of an SQL Database for the purposes of document control. The project this database is for has several consultants and a client spread in a variety ...
3
votes
1answer
365 views
Is a series of OR or a single IN SQL statement better?
I'm using MS SQL 2008 R2. I have been using a series of OR and have an issue where my app periodically give the following error:
Exception message: Timeout expired. The timeout period elapsed prior ...
2
votes
1answer
1k views
Git workflow for Microsoft SQL Stack
My team of developers are currently working at a client who has required us to move away from SVN and begin using their native workflow program. (Source tree by Atlassian). We are data warehouse ...
2
votes
3answers
218 views
Updating particular properties of EF objects every X amount of days in MVC
I'm building an MVC ASP.NET IMDb-like website which presents various information about movies to users, relying on 3rd party APIs to (initially) fetch movie info.
The IDs representing each movie on ...
-1
votes
2answers
489 views
Storing Dates & Times in SQL [closed]
I have a tool that I am working on which allows people to create meetings. They can select the Date, Time & Timezone that this meeting is occurring in.
I need to determine the best way to store ...
2
votes
2answers
273 views
Implementing “Trending Items” using linear regression in SQL Server
I'm building an MVC .NET website where people can rate and review movies (similar to IMDb). I'm using SQL Server for the back-end.
I'll be implementing a feature where the homepage displays trending ...
