did you double check the "slow" instances service account is authorized to use Instant File Initialization ?

Since the date is in your result set, which date to you want it to have ?

Select EmpName, min( PayDate) as PayDate, WageType, PayRate

from Whatever

group by EmpName,...

can you share what you have tested and why distinct cannot be used ?

a simple group by on the 4 columns will also work and may even use available indexes

Spot on for the weak spot detection !

Enjoy your holiday !

how about this:

/* still using the recursive CTE */

Create table MyTable ( Id int not null, Name varchar(128) not null, IdParent int NULL );

go

Create...

I guess your interesting read would be Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] and the sequels 😉

just solving your simple example using a cte can...

please refer to http://stackoverflow.com/questions/7843733/confused-about-updlock-holdlock

apparently just being member of 'public' on a database is enough to be able to script the create database statement. :crazy:

is the user member of any powerful instance level security group(s) or has the account been granted things 'on any database' ?

someone must have granted 'view definition TO ...' ;

e.g. to public ( not my favorite ! )

try:

deny view definition TO [ThatSpecificUser]

IMO that must be something that comes from either:

- someone executing DDL for implementation of stuff

or

- a dynamic sql statement someone is executing.

SQLserver will not let you implement DDL...

HowardW (9/10/2014)

---

I'm assuming it's the conversion from a binary(8) to varchar that's causing the problem. If you output cast(eqs.query_hash as varchar(255) ) in the select, does it look different?

You might...

I know you the values of query_hash and query_plan_hash are different and the columns serve different purposes.

My points are:

- why is query_hash of the sqlplan not equal with the query_hash...

start reading here : Database Mirroring (SQL Server 2012)

itmanagers (8/27/2014)

---

Hi,

Hope you are doing fine.

I'm new using SQL backup jobs with multiple full, diff and log backups.

I have the following scenario

full- every day at 8:00pm

diff- every 4 hours

log- every...