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

Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but I'm putting...

Grant Fritchey (4/10/2015)

---

Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but...

Especially when it's pushed forward to the day of the publication,...

maurer.martina (4/10/2015)

---

new thought: a kind of syntax-check

Example-Statement: delete from mytable

allowed characters between "delete" and "from" and "myTable" are only blanks, right?

If I erase the blanks in the definition, there must...

yusufm 48726 (4/10/2015)

---

Hi Guys,

I am trying to create a report from view and I am stuck on dates and Value.

I have got scenario like

Date ...

dlsilsbury 63952 (4/10/2015)

---

Hi,

I'm new to the forums. So Hello, hello.

Quick question! Is this syntax valid?

"FOR XML AUTO, RAW"

I can't see that it is but I'm due to take my 70-461...

Escaping the quotation marks produces the correct output

😎

INSERT INTO dbo.Staging_Temp_1 fnGetFirstOcurrences(col001, '¯',@Columns),LoadDate...