That is a fair guess as the after trigger execution is appended to the insert statement in the execution plan.

😎

Guess shrinked is the simple mode and shrunken is the...

First suggestion is to set NOCOUNT ON to eliminate the unnecessary network traffic.

The message can be from a select / update / insert / delete within the code, even "select...

Flash from the Access database passed :sick:

😎

Steve Jones - SSC Editor (7/30/2014)

---

Lynn Pettis (7/30/2014)

---

It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try...

Quick suggestion, if you are on SQL 2012 or later, use the concat function.

😎

DECLARE @recordcount INT = 007;

DECLARE @mysubject varchar(500) = CONCAT('Number of unprocessed records on SQL1 ',@recordcount);

SELECT @mysubject;

Sean Lange (7/30/2014)

---

No kidding. I sure opened a can of...

Somehow messed up the order of the days, here is the correct code

😎

USE tempdb;

GO

DECLARE @Date DATE;

/*SET @Date = GETDATE();*/

SET @Date = '2014-08-07';

DECLARE @TEST_DATA TABLE

(

DT_ID INT ...

Koen Verbeeck (7/30/2014)

---

Why is compression not an option? Because...

Chowdary's (7/29/2014)

---

Hi All,

Am using 2008 Sql server.

In my database one of the table containing 20gb of data.I need to check that table means what are the data updated and...

michael_alawneh (7/29/2014)

---

None of the queries are XML. Simple selects just outputting as file.

SET NOCOUNT ON

SELECT Blah

, Blah

FROM dbo.tblBlah

If it's a default for the UTF-8 format I'm...

No worries, I think...

Quick question, the query used for this wouldn't by any chance have a FOR XML statement in it? What you are seeing there is the UTF-8 BOM or Byte Order...

Here is a quick solution, more generic than using a specific format file for the import.

The first part is a CSV splitter function which is based on Jeff Moden's...

v4vaas 19815 (7/29/2014)

---

Hi, I am doing a performance testing for In-memory option is sql server 2014. As a part I want to insert 500 million rows of records into a...