Skip to main content
Software Engineering

Questions tagged [sql-server]

Ask Question

SQL Server is a relational database management system from Microsoft.

360 questions
Newest Active Bountied Unanswered
173 votes
21 answers
164k views

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 ...
Community wiki
4 revs, 3 users 86%
user673740
144 votes
4 answers
205k views

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 ...
webnoob's user avatar
  • 2,179
42 votes
3 answers
173k views

I'm learning T-SQL. From the examples I've seen, to insert text in a varchar() cell, I can write just the string to insert, but for nvarchar() cells, every example prefix the strings with the letter N....
qinking126's user avatar
  • 561
39 votes
2 answers
88k views

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 JOIN...ON.....
MCP_infiltrator's user avatar
  • 735
38 votes
10 answers
52k views

I generally use auto increment IDs as Primary Keys in databases. I am trying to learn the benefits of using GUIDs. I have read this article: https://betterexplained.com/articles/the-quick-guide-to-...
w0051977's user avatar
  • 7,219
35 votes
6 answers
10k views

The system I'm working on started as a small training project within the company I work for but quickly caught interest from management as a means to help to standardize the existing excel-heavy ...
ElderFuthark's user avatar
  • 467
28 votes
2 answers
5k views

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 ...
Andy Clark's user avatar
  • 425
22 votes
6 answers
21k views

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 ...
Amy Barrett's user avatar
  • 493
20 votes
2 answers
23k views

I would like to ask you, your opinion when it comes to implement a filtered search form. Let's imagine the following case: 1 Big table with lots of columns It might be important to say that this SQL ...
j0N45's user avatar
  • 351
18 votes
7 answers
12k views

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-...
Phil Wright's user avatar
  • 409
15 votes
7 answers
22k views

When should I use the XML data type in Microsoft SQL Server?
FarligOpptreden's user avatar
  • 261
14 votes
13 answers
2k views

I was just curious if SQL Devs write their code freehand or do they make use of the visual query designer to generate queries? In the majority of the cases, the query designer can create most of non-...
James's user avatar
  • 203
14 votes
2 answers
21k views

We have a large news-oriented site that has high web traffic. The architecture is your often seen DB - Repo Layer - Services Layer - Asp.Net MVC. The problem that we've been seeing is around read ...
John's user avatar
  • 479
14 votes
5 answers
7k views

I'm starting a new project and using SVN (with Tortoise) as my Version Control System. I was wondering if it was possible to also maintain a SQL Server Database using the same system. I'd want to ...
user avatar
13 votes
2 answers
9k views

We have an application that has a mix of both fast (< 1 second) and slow database migrations (> 30 seconds). Right now, we're running database migrations as a part of CI, but then our CI tool has ...
ben_makes_stuff's user avatar
  • 323

15 30 50 per page
1
2 3 4 5
…
24