hegdesuchi (10/14/2016)

---

Hi All,

I have to update target table and I am good with below logic.

MERGE testdb.dbo.targettable r

using dbo.sourcetable s

on s.id=r.id

...

Quick guess, the GUI has SET ANSI_WARNINGS OFF while SSMS has SET ANSI_WARNINGS ON

😎

mitzyturbo (10/13/2016)

---

Exec plan attached

I'm wondering if this might be combination of using the <= operator in the inner join along with using a temp table which might be throwing the...

Can you post the actual execution plan for the query?

😎

Further on Jeff's fine reply, here is an example of "Generic" table auditing with few extras for education and entertainment.

😎

USE TEEST;

GO

SET NOCOUNT ON;

/*

--------------------------------------------------------------------------------------------------------------------------

Name: ...

How large is the dbo.sysjobhistory table in msdb? Seen similar on the same version/patch level when the table grows huge.

😎

This looks entirely wrong to me, two instances of a parameter object with the same name in the same scope, using parameters in non-parameterized code, no command is executed. My...

BLOB_EATER (10/12/2016)

---

Eirikur Eiriksson (10/12/2016)

---

BLOB_EATER (10/12/2016)

---

Hi guys, is anyone willing (and kind enough) to review a post I am doing on SQL Memory? Basically I want to talk about total vs...

BLOB_EATER (10/12/2016)

---

Hi guys, is anyone willing (and kind enough) to review a post I am doing on SQL Memory? Basically I want to talk about total vs target and show...

Quick question, what is the full output of SELECT @@VERSION

😎

Not clear what the problem is here, can you elaborate further?

😎

BI_Dev (10/11/2016)

---

Hi,

Is it possible to block all users from querying a table while it's being refreshed (truncate/insert into) by a maintenance job? I'm not a DBA but would like...

Quick question, do you have a POC (Partition, Order, Covering) index to satisfy the row_number?

😎

As mentioned before, check the parentheses, here is a suggestion

😎

SELECT

bi.ref

,st.design

,bi.qtt

,bi.qtt2

,st.fornecedor

,st.epcult

...

This is well documented on BOL: Using XML Data Types

😎