ricardo_chicas (8/20/2010)

---

Ok lets do this, forget about the original problem

what I really want to know is for a suggestion on what is the best way to retrieve large amount of...

ricardo_chicas (8/20/2010)

---

Ok, the T-sql program loads all the needed data into a table, then another process use that data for a webpage ( believeme all of that data is needed)...

R0gu3Tr4d3r (8/17/2010)

---

I have 2 sql server 2005 instances running on 2 different boxes, one is 32 bit Win Server 2003, the other is a 64 bit.

now, I load a table...

Can you explain a little more in detail exactly what you are doing ?

You say the report is a T-SQL program.

Exactly what does that mean ?

Do you have a stored...

Bhuvnesh (8/20/2010)

---

Stefan_G (8/20/2010)

---

i will...

PradeepVallabh (8/18/2010)

---

My production servers are not high OLTP system but i have to defragment some of the indexe's daily(fragmentation level sometimes goes as high as 85%).....I am trying to resolve...

ricardo_chicas (8/19/2010)

---

Hello All,

I have this situation:

For several reports we need to extract about 5 millions records from a table of 124 million ( 173 gb)

I am able to use the...

GilaMonster (8/19/2010)

---

It quite...

If you do not already have your query as a stored procedure you can simply create a temporary procedure, like this:

use AdventureWorksLT2008

go

declare @sql varchar(max)

-- Assume this is the...

Well lets look at this in more detail then.

Your original data looks like this:

1:char(1) + char(124)

2:char(1) + char(124) + char(1)+ char(124)

3:char(1) + char(124) + char(2)+ char(124)

4:char(70) + char(124)

5:char(70) + char(124)...

To me this sounds like you are getting different execution plans. Have you checked the actual plans for your test procedure both when it executes fast and when it executes...

Ok, some more help:

I have created a sample SSIS package that can read data from a text file and write the data to a table containing a geometry column.

The package...

The reason for the strange sort is that SQL server pads all strings with spaces (ASCII 32) to a common length before comparing.

For normal printable strings this means that shorter...

Unfortunately there is no built-in support in SSIS for spatial data.

You will have to implement it yourself.

The following articles might be helpful:

http://www.sql-server-performance.com/articles/biz/spatial_data_support_ssis_p1.aspx

http://msdn.microsoft.com/en-us/magazine/dd434647.aspx

OK, I give up.

I would have liked to analyze this on site, but it is just too inefficient and frustrating to try to diagnose this remotely.

One final suggestion is to...