This was after the database restore and at the end of the log restore. Only thing in the logs are lots and lots of IO waits. I did not use...

xp_cmdshell being disabled is a matter of choice and frankly overkill. You can simply enable it, use it and disable it if security folks are that paranoid. I've worked at...

You can monitor network share space very simply. Just use the DIR \\sharename cmd and the last value is free space 🙂

EG.

DECLARE @cmd VARCHAR(2000)

SET @cmd = 'DIR "\\SHARENAME"'

EXEC xp_cmdshell @cmd

haha no worries, I guess with the multi-national nature of this site it is well worth remembering to be absolutely clear on terminology 🙂

I know that 🙂 ok fussy, instance resource! happy now 🙂

Are you sure this senior dev doesn't mean something like a work or staging database? i.e. something pre-production and isolated on a different drive? That I could understand.

As Gail states,...

Sounds like you're trying to add a column mid-table which is causing a table rebuild and hence it won't automatically do this unless you de-select the option from => Tools...

Well your table definition has changed then as this doesn't match the 2nd picture you posted. i.e. that column should allow NULLs according to picture, but it doesn't...

Dooh! Pict 1 old! Pict 2 new!

anyway, still think the inserts wrong unless you just want everything else empty. If it was an identity column though surely you wouldn't receive...

No I don't. I think you need to revisit what you are trying to do.

Perhaps you should be UPDATE'ing that field? Your INSERT statement implies you just want to...

It looks like your insert statement is failing as that's the primary key for the table and it will not allow NULL values.

Either way, on assessing your best fit you'd have to compare performance over a defined time period in order to really find your best fit for this setting. And after...

As I understand it, with MSCRM the performance white paper recommends you use MAXDOP = 1 due to how MSCRM works/performs.

I'd advise you look up these documents as there are...

I think its worth clarifying that this is the sort of db you never expect to see under any sort of serious load. With that in mind ppl may well...

Great article and in my experience with table variables its usually devs not implementing them properly in complex queries 😉 I shall ensure part of this article goes into our...