Questions tagged [sql-server]
SQL Server is a relational database management system from Microsoft.
16 questions
173
votes
21
answers
164k
views
Stored Procedures a bad practice at one of worlds largest IT software consulting firms?
I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...
10
votes
5
answers
24k
views
Should I store images in my database or file system in this application? [duplicate]
I'm using ASP.NET MVC 4 and SQL Server 2012. I have no problem going for either of these solutions but I want to know which one would fit better in the particular application I'm creating now.
I'm ...
- 1,031
144
votes
4
answers
205k
views
Creating database connections - Do it once or for each query?
At the moment I create a database connection when my web page is first loaded. I then process the page and run any queries against that conection. Is this the best way to do it or should I be creating ...
- 2,179
8
votes
3
answers
11k
views
Which is better : Storing/retrieving images on/from SQL server or in a directory on server
I am working on a project in Asp.net MVC and need to work with images. There is an SQL database with a Product table. Every product in the table will have it's own image. I have two ways to do this :
...
- 5,090
7
votes
6
answers
4k
views
How to create a timed-event architecture using a SQL database
The title of my question is general because I feel like this problem is of a general nature, but to set the stage I'm going to provide a specific example.
We use a homegrown workflow engine that is ...
- 201k
6
votes
5
answers
1k
views
How do you keep track of the meaning of your SQL fields? [closed]
The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data.
I use SQL ...
- 267
3
votes
6
answers
3k
views
How to include database changes during application publish
I am maintaining a WinForms application, which talks to a SQL Server database. Sometimes I have to change database schema (for example to alter a sql procedure or add new one). For this purpose I have ...
- 222
18
votes
7
answers
12k
views
500 databases or 1 database with 500 tables or just 1 table with all the records? [duplicate]
I currently have an application that is used by a single end customer. For ease of discussion assume the application only needs a single database table for all records. I now need to support multi-...
- 409
10
votes
1
answer
3k
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 ...
- 229
9
votes
3
answers
2k
views
Can anyone recommend coding standards for TSQL?
We've long had coding standards for our .Net code, and there seem to be several reputable sources for ideas on how to apply them which evolve over time.
I'd like to be able to put together some ...
- 338
5
votes
2
answers
4k
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, ...
- 173
4
votes
2
answers
8k
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 ...
- 69
3
votes
3
answers
6k
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 ...
- 3,498
2
votes
2
answers
1k
views
Sql Server: Compact and LocalDB Denali
Does anyone knows the differences between these ones?
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx (Look for CTP3 LocalDB in the page)
http://www.microsoft.com/sqlserver/en/us/...
- 171
-2
votes
1
answer
630
views
What is a simple implementation of onion architecture for C# ASP.NET Core WebAPI and SQL db that is not full DDD and CQRS?
I'm a programming teacher. My students learn structured and then object oriented programming in JavaScript and C#. They learn SQL, MS SQL Server, Dapper and EntityFramework Core.
After this they ...
- 115