Just drop all users after restore (see the commented part of my last reply here for a script to do this). They have been scripted out anyway.  When you recreate...

Updated to include dbo and drop existing users (commented out) to run in restored db.

/*

This script will script the role members for all roles on the database.

This...

• This reply was modified 4 years, 5 months ago by  Andrew G. Reason: Used Code block

Try get the exact SQL text from the cached plan instead of profiler, I've found profiler is not the best way as you can miss auto parameterized queries.

I had to research this but found a good explanation here:

• Aaron Bertrand’s, and Boris Baryshnikov’s ‘Using the Resource Governor’

Which is linked on https://www.red-gate.com/simple-talk/sql/learn-sql-server/resource-governor/

When you...

How to use a SQL format function: first learn .NET

Link to datetime format strings: https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

Some issues that I've had that were "Not the database"^tm
Server slow - VMWare balloon driver taking RAM
Failed authentication - Change in AD Server version incompatible with old...

Hi Steve, I use your script so much so I've got an update for you which includes some of the suggestions from the comments.

My main problem was when scripting out...

So to round a number less than 1 it needs to be cast to scale 2, precision 1 (or 0) .. I dont even..

select round(cast(0.7 as numeric(2,1)),0)

-- 1.0

Thanks for the script John.

I noticed that @AcctName is not populated at any stage of the script, so the 0x534 logic will not work correctly.

Also, AD accounts and groups can...

I dont know what hap

Thanks S. Kusen, great script.

You might also want to add SET NOCOUNT ON and update the URL in the comments to this new V4 article.

Also interested in what others are doing.

We have a native backup to separate LUN which is picked up by an archiving solution (currently using both Avamar & Commvault).

Dedupe is fairly...

CREATE NONCLUSTERED INDEX ix_tblEventSample_fkeventtype ON dbo.tblEventSample (fkeventtype, fksample) WITH FILLFACTOR = 90 ON [INDEXDBGROUP] --[PRIMARY]

That seems to resolve the index scan. See how long after that.

vMotion only helps for hardware failure, AG for either hardware or software failure.

vMotion supports the infrastructure team in allowing standard OS, drivers, easily replaced hosts.

AG supports the dba team, allowing...

Sounds almost exactly like this issue solved by Denny Cherry

http://itknowledgeexchange.techtarget.com/sql-server/tempdb-latch-timeouts-with-lots-of-ram/

He has a link to a MS blog post on the issue.

http://blogs.msdn.com/b/slavao/archive/2005/04/29/413425.aspx