Forum Replies Created
Viewing 15 posts - 1 through 15 (of 33 total)
-
Reply To: Does anyone have the Microsoft Auto Index Tuning DB
Could it be this?
https://docs.microsoft.com/en-us/archive/blogs/queryoptteam/fun-for-the-day-automated-auto-indexing
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Ghost Cleanup
It's actually pretty small, <500MB, there has to be something going on with the application.
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Ghost Cleanup
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...
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Latches and Access Violations
Thank you very much, I'll check that out!
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Latches and Access Violations
Yes, they did a memory check and that came up clean.
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Latches and Access Violations
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...
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Shrinking Tempdb Revisted
Ah, thank you Noel! Method 1 was the only one I hadn't tried and it worked.
Much obliged!
~Pam
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Shrinking Tempdb Revisted
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.
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Shrinking Tempdb Revisted
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...
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Question of the Day for 03 Feb 2005
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.
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Question of the Day for 10 Jan 2005
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...
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Question of the Day for 17 Dec 2004
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...
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Question of the Day for 17 Dec 2004
Ahh, well, check out my personal fav:
http://www.thinkgeek.com/tshirts/frustrations/595d/
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Question of the Day for 17 Dec 2004
I rest my case... How many t-shirts from ThinkGeek do you own?
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger -
RE: Question of the Day for 17 Dec 2004
Way too much time on your hands... (funny though)
The greatest obstacle to transforming the world is that we lack the clarity and imagination to conceive that it could be different. -- Roberto Unger
Viewing 15 posts - 1 through 15 (of 33 total)