Grant Fritchey (9/23/2015)

---

Ed Wagner (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Lynn Pettis (9/23/2015)

---

Steve Jones - SSC Editor (9/22/2015)

---

jasona.work (9/22/2015)

---

I think I need an intervention...

I keep going back to the "Jet" topic, it's like watching...

JaybeeSQL (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

JaybeeSQL (9/23/2015)

---

Eirikur Eiriksson (9/22/2015)

---

Have a look at this blog post: Microsoft SQL Server...

Kristen-173977 (9/23/2015)

---

WayneS (9/22/2015)

---

In your ISNULL statement, you are building an empty string if the column is NULL. That is not valid for a UNIQUEIDENTIFIER data type.

DECLARE @t UNIQUEIDENTIFIER = ''

This...

JaybeeSQL (9/23/2015)

---

Already...

SQLSACT (9/23/2015)

---

Eirikur Eiriksson (9/22/2015)

---

SQLSACT (9/22/2015)

---

Hi All

When troubleshooting a memory pressure situation on a SQL Server.

I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit...

Lynn Pettis (9/23/2015)

---

Steve Jones - SSC Editor (9/22/2015)

---

jasona.work (9/22/2015)

---

I think I need an intervention...

I keep going back to the "Jet" topic, it's like watching a train wreck and I can't...

Joe Docherty (9/23/2015)

---

Good spot!

I have removed one or two unnecessary details from the result of the SELECT.

"Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

Standard...

Quick suggestion, cast all the non varchar columns to varchar before the concatenation.

😎

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.MyTable' ) IS NOT NULL DROP TABLE dbo.MyTable ;

IF OBJECT_ID(N'dbo.MyTable2') IS NOT NULL DROP TABLE dbo.MyTable2;

CREATE TABLE dbo.MyTable (

[id] INT identity NOT NULL,

[sess_id] INT NOT...

dallas13 (9/22/2015)

---

Hello,

I am trying to run ssis package on sql 2014 which has SFTP task but it gives me below error.

Description: Cannot create a task from XML...

Ed Wagner (9/22/2015)

---

whereisSQL? (9/22/2015)

---

DonlSimpson (9/22/2015)

---

Revenant (9/22/2015)

---

Ed Wagner (9/22/2015)

---

crookj (9/22/2015)

---

anthony.green (9/22/2015)

---

Ham (Brigadier General...

Those TEXT_MIX_PAGEs store the LOB values for whatever objects in tempdb i.e. temp tables, table variables etc..

😎

randyetheridge (9/22/2015)

---

I have a field I am trying to bring into a SQL statement

,ISNULL(Convert(nvarchar(50),OPP1.OriginatingLeadId),'') AS 'OriginatingLeadId'

I get this error message

Conversion failed when converting from a character string to uniqueidentifier.

the field...

balcock (9/22/2015)

---

We deleted some SQL instances and nodes from our SQL 2012 failover cluster but we are still getting DCOM attempts to connect to those servers. I did a...

Joe Docherty (9/22/2015)

---

An application process was failing with "605 Fatal error".

The SQL Server errorlog had many of the 2 rows below over the previous 3 days. They had occurred 2-3...