Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-express]

For questions about Microsoft SQL Server Express (except Express LocalDB).

Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications. It has restrictions that make it unusable for large-scale applications. For more, see http://www.microsoft.com/sqlserver/en/us/editions/express.aspx or http://en.wikipedia.org/wiki/SQL_Server_Express.

191 questions
9
votes
2 answers

Differences between the different installers of SQL Server 2014 Express

I'm trying to understand the differences between the different installers of SQL Server 2014 Express. If you are able to tell me whatever you can or find documentation on them, I'd appreciate…
JustBeingHelpful
  • 2,082
  • 18
  • 45
  • 60
6
votes
3 answers

SQL Server Express 2012 Database Size Limit

I checked the forum there are other similar topics but my scenario is different. for myDatabase under database properties -> General tab it shows: Size : 25285.31 MB Space Available: 3989.13 MB And on disk myDB.mdf = 10.0 GB (10,745,806,848…
Nisar Afridi
  • 63
  • 1
  • 1
  • 5
3
votes
3 answers

Which SQL Server Express edition is right for me?

I have developed a Java program which works with SQL Server as it's database. I have installed SQL Server 2012 Enterprise edition on my Windows and designed the database via SQL Server Management Studio; for example: I have designed its tables, have…
soheil.mernoosh
  • 33
  • 1
  • 1
  • 3
2
votes
2 answers

Can't shrink WSUS SQL database

I have a Windows SBS2011 installed. It has file sharing, Exchange and WSUS running off it. WSUS console was, and always been, running slowly - I have no comparison with any other system, so I considered it normal; it was (and is) usable. One day I…
StanTastic
  • 123
  • 1
  • 6
2
votes
1 answer

How do I reindex my SQL Server Express database to free up space when it's already full?

Being the naive guy that I am, I let my DB get full (10GB is the max for SQL Server Express), and have now decided to drop columns to reclaim space. I'm dropping 10 columns from a ~50M row table to save space, but even after dropping them, I keep…
ijustlovemath
  • 353
  • 3
  • 14
1
vote
1 answer

SQL Express 2014 Installation Fails with SSL Error

I've got a user that wants to install SQL Server Express 2014 on his Windows 10 laptop. The default installation fails: 2017-11-13 13:39:31.31 Server Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Feb 20 2014 20:04:26 Copyright (c)…
kraligor
  • 111
  • 2
1
vote
1 answer

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some limitations, or is it a complete different software? i.e.…
user6219126
  • 11
  • 1
  • 2
1
vote
1 answer

Failed to attach SQL Express DB, Could not continue scan with NOLOCK

We have a remote client that had to rebuild their server and has been having trouble with their SQL Express database since. I cannot remotely connect to this client unfortunately. I had them run "DBCC CHECKDB" and it showed one of the tables to be…
Kris
  • 143
  • 1
  • 5
0
votes
1 answer

Is having SQL Server express database on client better than querying data on a remote server?

I'm planning to create a SQL Server Express database on each client machine that will sync with the remote server's data. What I'm trying to achieve is to have a faster processing and querying of data wherein the client application connects to its…
Benjie Mangulabnan
  • 1
  • 1
0
votes
1 answer

Define relationships for 3 tables

I have 3 tables that are currently defined as: Is this the best way, or should I use an associative table? I put the relationships backwards, 1 group can contain many users and many students. There is no other relationship between the user and the…
Fragmond
  • 3
  • 4