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

ankithimmatlalshah (4/10/2015)

---

Hello everyone,

I'm trying to export the data from SQL database to Flat file.

The data gets exported to the destination but it does not contain the header columns.

Can anybody advise...

philosophaie (4/10/2015)

---

I am trying to write a connection string that works for SQL Server 2012.

Here is my attempt but I am using data from:

http://www.connectionstrings.com/sql-server/

I believe the below is the...