-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a big stored procedure on a MSSQL 2008 Express SP2 database that gets run about every 200 ms. Normal execution time is about 50ms. What I am seeing is large inconsistencies in this run time. It will execute for while, say 50-100 times at 40-60ms which is expected, then seemingly at random…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Can I create a table without colum in MS SQL Server by t-sql?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm using MSSQLExpress named instance in my Silverlight 4 application.
The database located in the web application data folder. I attached the db via VS2010.
The program works, but the db doesn't show up in Management Studio Express.
If I delete the connection from within VS2010, and Try to attach…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello, I have an ASP.NET 2.0 application that I made to keep track of disruption reports about our public transport system. The architecture is pretty straight-forward; an MSSQL Express 2008 database, ADO.NET and a DataSet/DAL with a few methods to access the database. There is a set of .aspx pages…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hi
Running Windows Server 2008, 74GB raptor drive and noticed we only had about 500MB left - yikes!
So deleted some old backups we don't need, but can't track down where about 30GB seems to be taken up. If I go to C: and select all folders and go to properties, this comes to around 30GB but in My…
>>> More