Viewing 15 posts - 9,406 through 9,420 (of 39,936 total)
Don't use the GUI.
Use DBCC Shrinkfile( tempdbdata, 1500);
Or something close to the current size. Just get it to run. If it does, then work on slowly shrinking.
August 31, 2015 at 9:52 am
Desktop
Windows: 38.2GB
Program Files: 12.8GB
Program Files (x86): 21GB
Lots of crap here though.
Laptop (< 1yr old)
Windows: 33.5GB
Program Files: 3.75GB
Program Files (x86): 11.9GB
These are both VS2013. Need to upgrade.
August 31, 2015 at 9:46 am
You need to restart SQL Server. What is the initial size for tempdb? Also, what code did you run? Did you manually run dbcc shrinkfile?
You do want to be in...
August 31, 2015 at 9:39 am
I'd use what Jacob suggested. This an easy way to move rows to columns when they are aggregated based on some value in the rows.
August 31, 2015 at 9:09 am
What code did you run?
What I find is that tempdb is hard, because there's usually a load in it. I'd shrink files, not the database, and shrink it in...
August 31, 2015 at 9:05 am
Interesting W10 experiences. I did my homebuilt desktop first, and it went smoothly. A mouse driver seemed a little flaky with hesitations, but otherwise the W8.1-> 10 had no issues,...
August 31, 2015 at 8:54 am
ZZartin (8/31/2015)
My opinion on foreign keys is that they are much less important, orphaned records are not necessarily a big deal and they don't prevent the application from having to...
August 31, 2015 at 8:40 am
Lempster (8/26/2015)
August 27, 2015 at 3:40 pm
The DB stores some internal SQL Server stuff. What, I'm not exactly sure, and why in a DB? No idea.
However it's a stable resource for a particular build.
August 27, 2015 at 3:39 pm
We are looking. We had some strange networking problems between the DB and website. We have a ticket open with the colocation facility
August 26, 2015 at 8:46 am
Can you show an example of what you mean? Without seeing code, it's hard to understand what you mean.
August 25, 2015 at 11:13 am
Also says if you exceed the $200, they suspend your services.
August 25, 2015 at 10:04 am
I believe free trial is an amount. If I look at the main Azure site, I see the trial is listed as a $200 credit in the FAQ. That means...
August 25, 2015 at 10:03 am
Does this limit editing of the job itself? I was looking for a way to let Dev A edit jobs 2 and 3, b but not 1 and 4.
It does...
August 25, 2015 at 9:58 am
Viewing 15 posts - 9,406 through 9,420 (of 39,936 total)