Suresh.. (1/7/2014)

---

How can I clear the used space for TEMPDB database in sql server 2012 w/o restarting the sql service and w/o shrinking it.

Currently my tempDB is 20 GB in...

SQL_Surfer (1/6/2014)

---

When I run package through BIDs, it runs fine. But it gives the following error messsage while running through agent.

The variable cannot be found. This occurs when an attempt...

The VERY few times I have seen the entire IT stack (or even a significant fraction of it) really play well together and drive the company forward was when there...

One slip Jeff, and I am surprised both that you made it and that no one else mentioned it yet (in my quick review of the thread): you used...

You are correct that Microsoft (and pretty much any technical support these days) is HIGHLY dependent on a number of variables, and for complex stuff it often takes quite a...

Thanks for the comfort, but I was actually able to restore from an image backup I keep using ShadowProtect (AWESOME software) with a refresh of my important files from a...

Oh, in addition to the memory leaks, there was a VERY nasty bug that flushed memory. It was related to NUMA stuff. It was not patched until SP1...

You are mistaken that only buffer pool takes up space in SQL Server's memory space. There are MANY other things that could be making 22GB the "cap" currently allowed...

I haven't looked at the deep internals of transaction logging in some time and my brain is frazzled at the moment from a recent total loss of my main computer...

Theo Ekelmans (12/27/2013)

---

hi.

I have a strange SQL 2012 mirror issue, on a rather large HP DL980 server (32 CPU's, 256 GB memory), on which I mirror about 40 DB's.

38 of...

During many of the SQL Saturday presentations I make I allude to how AWESOME SQL Server is in that my 8 year old daughter can put in an install disk...

what is the OS on each?

is windows 32 or 64 bit?

is sql server 32 or 64 bit?

is max memory set on either box?

what...

If the situation becomes insufferable (I believe it already is), remember that it's easier to find a nice, friendly, well paying job while your employed than it is when you're...

ItsDaveTime (12/14/2013)

---

Thanks for your responses. I've been doing this for many years (as I'm sure you have as well) and have implemented and developed high availability and high transaction...

Try the semi-documented fn_dblog.

ApexSQL also has a very cool transaction log reader/recovery tool

Are you monitoring your mirroring and do you have alerts set to notify you if it...