info.sqldbamail (5/2/2016)

---

Thanks for your time I got the answer, There is no need to restart the SQL Server services if we change the Cost Threshold Parallelism value from 5, If...

The first thing that comes to my mind is after the migration have you updated your statistics and rebuild indices?

arkiboys (4/27/2016)

---

Hello,

We have sql server 2008 R2 with ssis, ssas and reports...

I would like to write-up a document on upgrading to sql server 2014.

In the document I...

cmc123 (4/25/2016)

---

Hi,

We have an estate of 120 Prod & DR Servers. We looking for efficient monitoring tool. we would like to know Top 10 tools in market.

Please assist me on...

Very hard to give you any recommendations with out seeing the actual query and schema. First thing i would check if your stats are upto date. There could be other...

What issue are you trying to solve. If you really want to cache, you would do that at app layer not really at DB layer since DB will cache data.

Bob Dorr strongly recommended to use 64KB cluster size regardless whether your underlying disks are on SAN or direct attached because though your block size is 64KB at the OS...

Below is the code that i use. Basically there is a sproc to create a trace file and a sproc to control the trace file and load data.

-- Create...

Thank you Jeff and yes i should have provided more details, sorry posted in haste:-P. Below is the script for the table and the code that i used to get...

Did you try updating meta data in fulltext index? Look in the properties.

Nice :)....Jokes aside, would be cool is i can actually execute my t-sql scripts on MySQL.

Depends, that...

On the slower one you are pulling about 20K more records in slower one and the amount of data is doubled ( 2MB vs 1MB) and so you are also...

I would start from making sure stats are update on both the sides or may be just update the stats with full scan if possible. Then execute the queries on...

kyyo757 (3/29/2016)

---

Hello All,

I thought I'd share my solution to this problem after numerous searches on Google and not finding a solution to fit my particular needs.

Summary: We are not using...