Are you using NetApp for your SAN storage?...

Could you elaborate on the snapmanager for SQL issues you've been experiencing? We've went virtual and now looking to implement it as our backup strategy but having issues with single...

could it be that the table is accessed twice (subquery or the likes) in the query and using the clustered index as a scan and the NC as a seek...

the easiest option would be to setup a config database / table as opposed to using a config file

thanks for that info. Brad says "Out of the Box" its not compatable, i'm interested to know if anyone has managed to do it with a bit of tweaking??

The requirement is to utilise the full 64gb of ram in the box as was intended. Just started here this week and one of my first tasks is to configure...

i...

Bit of an update for those interested:

Found that the reason for the duplicate entries is down to SET options being different in the procedures which call this procedure. There are...

Thanks for that, i'll do some more digging before splashing out on Microsoft support which i've found in the past to be of very little use 😉

Bound to be something...

@Grant:

Not sure what you're refering to? Whats not on the same SP? We're on Service Pack 3 Cumulative Update 4 on live and Service Pack 3 Cumulative Update 5 on...

@Gila:

If you create this:

CREATE PROCEDURE [dbo].[spProcTest]

AS

BEGIN

CREATE TABLE #qwerty

(

id INT

)

SELECT * FROM #qwerty

END

and get and estimated plan on it then it works. I can 100% guarantee that there is not...

@Brandie:

Temp tablename is a typo from me, i changed the tablename when copying the code and error.

As stated in my original post, i do create the temporary table in the...

@chudman

How long did you find it takes to restore a snap of a LUN? Also, how large do the snaps grow to once taken? I know this is...

....and SP2 😀

We've just implementing dbProtect and a modified version of appdetective pro for auditing. Looks promising so far, if not a bit faffy to install and configure.