djj (9/30/2014)

---

SQLRNNR (9/29/2014)

---

Along the same line of thinking, you need to tell them what they want to hear. If you seed the idea and make it theirs, then when...

You're welcome

Eirikur Eiriksson (9/29/2014)

---

djj (9/29/2014)

---

They hire me to be a DBA and then they do not take my suggestions.

I tell them they should only store a standardized value. A prime...

Erm, chances are often just about as good as them listening to an FTE.:-D

http://il-adan.blogspot.com/2013/07/hyper-v-clone-machine-with-sql-server.html

Here is an example on how to do it.

And a recommendation from VMWare on their best practice recommendation

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004588

Ha, I saw...

It is best to quiesce the databases before cloning the machine. You can achieve that through stopping the SQL services.

Not an XSL, but it is better than that.

Here is a deadlock shredder by Wayne Sheffield.

http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/

You can take the xml from the graph that is produced by XE and just...

You are getting a cross contamination from the index stats for other databases. SYS.DM_DB_INDEX_USAGE_STATS contains entries for every database and sometimes index_id and object_id might be the same in...

sludge

Koen Verbeeck (9/29/2014)

---

Hopefully you didn't change them right away, because there was no...

andrew.ing (9/29/2014)

---

Something I've never quite understood is why RAND() is like it is - that is, contrary to what perhaps most people would want and expect: creating a (pseudo) random...

Yup this will work. I...

ARRRGGGGHHH

Looks good.