Does anyone have an idea on how to solve this problem?

😎

Quick thought, it is going to be somewhat tricky to correlate the actual tempdb I/O to an execution, here is an example alternative that checks for # or tempdb in...

Quick suggestion with a CTE and ROW_NUMBER ordered by the length of the prefix

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_PREFIX

(

PREFIX_VALUE...

Quick thought, let's not forget that tables can have more than one partition

😎

SELECT

OBJECT_NAME(SP.object_id) AS TABLE_NAME

,OBJECT_SCHEMA_NAME(SP.object_id)...

Quick suggestion, use openrowset bulk

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_SCRIPTFILE

(

SF_ID ...

corrosion

Refactoring

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if...

sql-lover (4/10/2015)

---

Thanks for the responses so far.

I need 100% certainty. The DMV/count is needed to identify the table(s) with an empty set. A massive DDL change will be deployed against...

Luis Cazares (4/10/2015)

---

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're...

Quick suggestion, simplify the query, the difference between the first and the second is 50%

😎

SELECT

t.name table_name,

s.name schema_name,

p.rows AS total_rows

FROM sys.tables t

join sys.schemas s on (t.schema_id = s.schema_id)

join sys.partitions p on...

Can you tell us a little bit more about what you are doing,i.e. Source, Destination, Network etc.? Can...

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're in situation...

ankithimmatlalshah (4/10/2015)

---

I've tried many things.

Like deleing the destination and source components again.

Check/uncheck the first column is data column

Even when I tried to export the table from SQL server, it does...

If I remember correctly, you have some kind of an issue with using OSS, so you...