keshab.basnet (6/11/2015)

---

Could you please say that dead lock is coming in select query in application because of index. It is identified after enabling trace in database and identified by reading...

SQLJay (6/10/2015)

---

Hi Everyone,

Over the weekend, we placed our major database on a SSD based SAN. Prior to that, the database / tempdb latency was high, now practically non-existent. Interestingly enough,...

Cursor

Worker

Quick suggestion, use FOR XML PATH('') concatenation on the Account number column

😎

Quick suggestion, add a where clause

😎

WITH XMLNAMESPACES (

'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' as ns1,

'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' as ns2,

'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd,

DEFAULT

'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'

)

SELECT path as ReportPath, name AS ReportName, CreationDate,...

Quick question, can you post some sample data?

😎

Jeff Moden (6/10/2015)

---

I know it doesn't help except that misery loves company. I've never seen a new revision of SQL Server where there weren't some horrible slowdowns even if...

Quick thought, piecemeal'ing the information like this can go on forever, far too many pieces of information missing. Do post the storage configurations (as complete as possible) and in addition,...

Further on Jeff's reply, here is a quick sample on how this can be done by importing the file as a single lob and parse it afterwards. Mind you that...

adonetok (6/9/2015)

---

I need to create a survey application and store answer in a SQL table.

There are about 50 questions.

Most questions are check box like

[check box ] No [check box]...

Generations

Adding on to Phil's question, what is the compatibility mode of the database? What are the two storage configurations etc.? Lots of variables left blank.

😎

mpdillon (6/9/2015)

---

Both solutions worked. The Union only worked fine. So did the double CTE. I didn't know that (a second CTE) could be done. The key seems to be the...

FootyRef (6/9/2015)

---

GilaMonster (6/9/2015)

---

You've talked about having monthly partitions and switching partitions out of the...