with that amount of CPU/RAM your main contention will be I/O

Don't just grab from the top shelf if you don't require it, you will probably waste money.

Depending on your speed...

ok, i got the first part, finding where it is

ex:

select B.* from table cross apply sys.fn_PhysLocCracker(%%physloc%%) B

edit:

@jason

Thanks, I am working with a copy of the production database...

Thanks everyone, I think I got the point.

Now the only thing I'm still curious is to find the actual row location, and a way to migrate all of into into...

SQLkiwi (3/18/2011)

---

dant12 (3/18/2011)

---

Given that, my only choice is to drop the iTVF and use a while-based multi-statement one. Perf tested and it seems while-based speed > on-the-fly tally-based speed for...

SQLkiwi (3/17/2011)

---

dant12 (3/17/2011)

---

the function does this. it appends the delimiter to the string before and after the string. thats why the simple select works. the question is why it doesn't...

coalesce will only work if you always only have 1 column filled, if col1 = 'a' and col2 = 'b' coalesce...

you need UNPIVOT

DECLARE @a TABLE (COL1 VARCHAR, COL2 VARCHAR,COL3 VARCHAR)

INSERT INTO @a

SELECT 'A',NULL,NULL UNION ALL

SELECT NULL,'B',NULL UNION ALL

SELECT NULL,NULL,'C'

SELECT X

FROM

(

SELECT *

FROM @a

) A

UNPIVOT...

GSquared (3/17/2011)

---

If the string doesn't have the delimiter in it, you'll get a LEFT(string, 0) or LEFT(string, -1) essentially, and that is an invalid value for the LEFT function, hence...

If you are just syncing stuff and not actually using this common database it CAN be a good thing.

You probably want to set up replication on those objects so when...

Agree with Chris, your best option is to always insert the excel sheet in a staging table and MERGE it with the actual table doing update when matched and inserting...

you should be profiling the queries that are being run against the server together with perfmon, even if you don't think a period should be experiencing "heavy loads" some poor...

i often use something more simple

DECLARE @TARGET INT

WHILE 1=1

BEGIN

DECLARE KILLCONS CURSOR LOCAL FAST_FORWARD FOR

SELECT SPID FROM MASTER..SYSPROCESSES WHERE DBID = DB_ID('DB NAME') AND SPID >=50

OPEN KILLCONS

FETCH NEXT FROM KILLCONS INTO...

Just got error 0xC0047020(unable to process the data) on the ado.net source then a following 0xC02090F5(something with PrimeOutput method in the message) error

I have no idea what this means and...

the way im doing it right now is a foreach loop only to loop through the 5 databases i need to query.

the query also returns parts of the destination folder,...

Phil Parkin (2/24/2011)

---

Hmmm, wasn't clear to me! But now it is and my suggestion was not valid.

My first idea would be to use an Execute SQL task to populate an...