Starting 2014 major change has been made to carnality estimator as mentioned here . Lot of speakers have also talked about this during PASS 2015 conference.

In our organization, if there are business users who are more interested in data they use some sort of reporting tools like Tableau or SSRS, so for business users this...

Can you copy paste the log from setup boot strap folder?

mikefle (11/11/2015)

---

Hi,

With the dta utility I can specify a test server for workload analysis (I cant in the GUI and I know this is documented), and with the GUI I...

You can use Microsofts Keberos configuration manager from here , open the tool and connect to sql instance. If there are duplicate SPN's it will indicate and give you the...

GilaMonster (11/9/2015)

---

Extended stored procs don't typically show useful wait info, because as soon as the extended proc starts to run, it's outside of the SQL scheduler control. You'll probably see...

Steve Jones - SSC Editor (11/6/2015)

---

Glad you figured it out. If you reply to a post, you also have the option below the edit box to subscribe (or unsubscribe) to...

Based on reading just few lines of your error , i think first thing you need to do is create a dedicated windows account for SQL Services and make...

curious_sqldba (11/6/2015)

---

I looked around under my profile but couldn't find a place to enable alerts , i would like to get notified if anyone asks a question in a forum....

Thank you for prompt...

Thank you Mark. Looks like this Enterprise Password Vault should get me what i want. Apparently they don't...

i am fine if the queries from serverB are hitting the data files on server A. Can i even take a snapshot from one server to another server?

Great post. Any thoughts on polybase in 2016?

mtlsql (7/7/2015)

---

I am a developer (not DBA) for a company, and have inherited the following scenario: A database was created on a Virtual Machine. The VM was then cloned twice,...

doug 88182 (8/24/2015)

---

I have a similar challenge.

I have 40 servers.

Each server has a [dbadb] database.

Each database has a view named v_DatabaseFiles that shows information on the database files...