Quick suggestion towards a SQL Server 2008 solution, which is fine on smaller sets but may need to be improved for large sets. If you are on SQL Server 2012...

This is wrong, NVARCHAR and VARCHAR will hold RTF files just...

Don't worry about removing it;-)

😎

Suggest you look into colour coding the connections in SSMS and paying attention...

peden (7/12/2016)

---

I have a requirement to display a "banner" with a warning message every time somebody "logs on to the database". I looked into possibly implementing a logon trigger,...

sqld-_-ba (7/12/2016)

---

Our production server (VM + SAN) has 32 GB of RAM, the database size is ~80GB. The application uses TempDB heavily - disk is hit ~100 MBps both reads...

Quick question, why are you using IMAGE data type and not NVARCHAR?

😎

torfi (7/12/2016)

---

I´m trying to create FullText Index on Image field witch contains text in rich text format. I´m from Iceland and we use several characters based on our language like...

You are very welcome.

😎

These changes have been slightly annoying but looks like they are slightly improving with each release, make certain you have the latest release of SSMS.

One particularly annoying thing was...

Quick though, NUMA node 2 only has 4 cores, possibly that should be your maxdop limit.

Depending on the type of workload I normally set the Cost Threshold for Parallelism...

If I understood correctly this could be a solution

😎

Foreign Sales X:=CALCULATE

( SUM(Sales[SalesAmount])

,ALL(Sales)

,FILTER(ALL('Market'),'Market'[Market]<>"Ireland")

)

Domestic Sales X:=CALCULATE

( SUM(Sales[SalesAmount])

,ALL(Sales)

,FILTER(ALL('Market'),'Market'[Market] = "Ireland")

)

Quick though, possibly the most straight forward thing to do is to run the Profiler and catch the actual statements being run.

😎

olibbhq (7/11/2016)

---

Thank you, I have been so caught up with the issue I must have mixed up the isbn's! Thank you so much for helping me with the fix, tested...

olibbhq (7/11/2016)

---

Thank you, this works in your example but when I pull it from google it doesnt. Please try with the full script below. (I will replace the api key...

VastSQL (7/11/2016)

---

Eirikur Eiriksson (7/11/2016)

---

VastSQL (7/11/2016)

---

Hi Experts,

The BatchRequest\Sec value for our OLTP system is showing 150 for the most critical time. I felt this as very low , can you guide...