Viewing 15 posts - 1 through 15 (of 32 total)
Could it be this?
https://docs.microsoft.com/en-us/archive/blogs/queryoptteam/fun-for-the-day-automated-auto-indexing
June 19, 2020 at 6:11 am
It's actually pretty small, <500MB, there has to be something going on with the application.
July 16, 2005 at 12:49 am
We tried to restart SQL but it wasn't responding so we had to reboot the server. Everything recovered fine and I was able to truncate the log of that...
July 15, 2005 at 11:28 am
Yes, they did a memory check and that came up clean.
July 5, 2005 at 8:11 am
Absolutely, that was my first thought. But my sysadmins assure me that the firmware is all up to date and the disks are fine. I've seen the latch...
June 30, 2005 at 11:12 am
Ah, thank you Noel! Method 1 was the only one I hadn't tried and it worked.
Much obliged!
~Pam
February 17, 2005 at 2:46 pm
I stopped SQL, deleted the files, restarted SQL. The new tempdb was created at 15GB (completely empty) and it still won't shrink via EM or QA.
February 17, 2005 at 1:40 pm
Yes, sorry if that wasn't clear. I've tried to shrink it several times using Enterprise Manager and Query Analyzer. It always says the shrink was successful but it...
February 17, 2005 at 12:28 pm
Yeah, I thought the same thing, but given the fact that they didn't mention anything about interfaces in the question or the answers provided I just assumed they didn't change.
February 3, 2005 at 9:05 am
I'm sorry, I still need clarification. How should the question be worded so that the dependencies answer is the one and only correct one? As stated previously, even the Startup...
January 10, 2005 at 10:34 am
HA! Yeah well, I find SQL gurus are few and far between and they seem to be too busy to sell t-shirts so I take what I can get. Perhaps...
December 17, 2004 at 3:56 pm
Ahh, well, check out my personal fav:
December 17, 2004 at 3:11 pm
I rest my case... How many t-shirts from ThinkGeek do you own?
December 17, 2004 at 2:59 pm
Way too much time on your hands... (funny though)
December 17, 2004 at 1:42 pm
Viewing 15 posts - 1 through 15 (of 32 total)