PiMané (11/30/2012)

---

I...

raghavender.2369 (11/30/2012)

---

col1 col2 col3

5.06.03.5

9.59.86.3

9.06.08.0

Col4col5col6

9.56.08.0

6.39.33.9

8.78.08.8

9.08.36.9

8.69.06.2

I have data like this in excel, how to load into 2 different tables

first table contain col1,col2,col3as columns

second table contain Col4,col5,col6 as columns.

Note: Here the number of...

raghavender.2369 (11/30/2012)

---

col1 col2 col3

5.06.03.5

9.59.86.3

9.06.08.0

Col4col5col6

9.56.08.0

6.39.33.9

8.78.08.8

9.08.36.9

8.69.06.2

I have data like this in excel, how to load into 2 different tables

first table contain col1,col2,col3as columns

second table contain Col4,col5,col6 as columns.

Plz help me how to...

raghavender.2369 (11/30/2012)

---

col1 col2 col3

5.06.03.5

9.59.86.3

9.06.08.0

Col4col5col6

9.56.08.0

6.39.33.9

8.78.08.8

9.08.36.9

8.69.06.2

I have data like this in excel, how to load into 2 different tables

first table contain col1,col2,col3as columns

second table contain Col4,col5,col6 as columns.

Note: Here the number of...

Alexisonfire

Its one of the "It depends" questions this.

My two cents, if the load of ServerA is heavily utilised, then running the dtexec process on ServerA might not be a good...

Yeah it is confusing at first.

Both Agent Alerts and Job Notifications use the same behind the covers methods of letting you know something has happened.

They both execute sp_notify_operator which calles...

Alerts in SQL can be for a number of things, either a SQL Server Event, a WMI Event or a SQL Performance Condition event, they notify you of any alerts...

You already specify the WITH RECOMPILE option so doing it in dynamic SQL isn't going to change much.

Please create the indexes and repost an updated execution plan.

Please also include the...

Please post the updated execution plan after creating the two indexes.

Only the primary key as an index? Or do you have other indexes?

IIRC, the CONVERT(INT,A.Acct_no) wont help either as that will cause the query to be Non-Sargable causing a...

Well the major thing that stands out is all the index scans, especially the one on Client_oe_info and All_Holding.

Can you post the table definitions along with indexes of all objects...

Dire Straits

Please follow the link in my signature on posting performance problems, it details in their the steps and information, to help us troubleshoot.

Have you setup the right security so that you can access the SSRS URL?

Firewall rules opened to allow the correct traffic for SSRS communication between client and server?