Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert SP takes Forever
Message
De
25/02/2016 12:21:43
 
 
À
25/02/2016 11:53:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2008 R2
Divers
Thread ID:
01632022
Message ID:
01632075
Vues:
43
>
>Strange, I have 200GB free on my C: drive and 157 GB free on the drive where the database files are. The database is just about 10GB. Hmmm, this is the express version and I know that's the size limit, I wonder if that is why I'm getting the error.

Quick question - are you using SQL Express for production work, or is this a test development environment?

On the 99% - I am amazed you didn't get more catastrophic errors from SQL Server. When fragmentation gets that high, the overhead is severe and that probably explains much of the performance issue.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform