Quick question, can you...

Quick solution that works with the sample data provided

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SampleData ([ColumnA], [ColumnB], [ColumnC], [ColumnD]) AS

(

SELECT 5060,'04/30/2015','05:30', '08:30'

UNION ALL SELECT...

Piling on, there is nothing wrong with being prepared, much better than frantickly having to start looking. Get someone to review your CV, maintain your Linkedin profile, gather some connections...

Communication

quirky

Ed Wagner (6/11/2015)

---

eccentricDBA (6/11/2015)

---

djj (6/11/2015)

---

Ed Wagner (6/11/2015)

---

crookj (6/11/2015)

---

Ed Wagner (6/11/2015)

---

djj (6/11/2015)

---

42 (I had...

keshab.basnet (6/10/2015)

---

I have Full database backup upto previous day and transaction logfile of Today transaction. my database has crashed.

I have restored previous day's Full backup. I have faced difficulty to...

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...