Tableau looks pretty nice, but it also looks like it mostly works with cube, or at least it would seem that way with dimensions and facts. Also, I do not...

Anyone know how to get the job name, any help would be very welcome.

I've tried those tables, but neither of them contained the following string.

0xFB668E27919DA3489E3DD97061F25B31

What about sp_configure "procedure cache size"? I've found that earlier, but it does not seem to work on my instance.

Having a horrible time trying to implement RedGate. Some kind of error on my half, I'm sure of it, but I've submitted the support ticket. Can anyone else recommend any...

As far as I can tell, it's twice the price of Red Gate per license.

Yeah, we've gotten a demo from them previously, when our accounting server had some performance issues. Ignite seemed a little complicated to just dive right in, but the support was...

I think something is missing. It is telling me that I must declare @LASTCOMMAND as well.

So, I've looked into DML Triggers, and it seems like the way to go, but the only thing I need is to capture actual syntax or commands being executed on...

Never ran those before, but it's worth a try I guess. Would tracing a single table be that much of a load onto the server? This table barely gets used,...

Phil Parkin (3/6/2013)

---

Cool - is it an ascending number?

The reason I ask: one way to do this would be to query your existing data, get max(id) and then get the...

There is a PK in place, which is a Customer ID.

Maybe I'm missing something, but I don't think there is an MDW database. This data warehouse database was installed by the vendor who also did our Dynamics GP install. I'll...

GilaMonster (2/11/2013)

---

The plan cache is part of the allocated SQL memory, with 26 GB of allocated memory it'll probably max out at somewhere around 5-6GB, I forget the exact formula.

Regardless,...

Looking at a SQL Trace for one minute, I see that stored procedures and functions get called pretty often by the front end software. I have sent the email to...