bitbucket-25253 (9/2/2011)

---

I will point out that my Dad worked for wages, hard work, and bought me up to never, ever expect a had out for doing nothing. My thoughts on...

Can you create a nonclustered index on serverId/timestamp only, and then re-check the max function? That should cure your issue, if not, I'd like to see the execution plan...

Hey Rog, you seem semi-new around here, but when asking for code assistance it helps if we can test it before we hand it to you. There's too many...

Having done this wholesale about 2 years ago, some thoughts:

1) Watch all FOUR bottlenecks. Network I/O, Disk I/O, CPU, Memory. One server bit us in the butt when...

jeeva.nadarajah (8/29/2011)

---

Switching it to varchar(max) didn't slow down anything but not including deploymentlog in select did.

Am going to see what the max length on deploymentlog is and switch it to...

jeeva.nadarajah (8/29/2011)

---

Thanks Everybody!

Since there is so little data in the table, I've switched the type to be VARCHAR(max) and am refactoring to remove the deploymentLog from queries.

That makes it a...

tracmonali (8/29/2011)

---

This is more regarding creating an SSIS package. While I create an SSIS pkg, I am using the sql command

RESTORE DATABASE db

FROM DISK = '\\'

WITH REPLACE

I get an...

Rod at work (8/29/2011)

---

Revenant (8/29/2011)

---

jn_gray (8/29/2011)

---

I think that all developers start out as specialists and over time become generalists unless they decide to make a concerted effort to remain a...

jeeva.nadarajah (8/29/2011)

---

Thanks for the prompt response. I'm looking into whether or not we can change the type for that field without much intrusion.

That's what you meant by by "Round...

Because...

jeeva.nadarajah (8/29/2011)

---

My table has 4000 rows and a simple select * from [DeploymentTarget_Temp] takes more than 2.3 minutes. Can someone help me understand how I can improve performance?

CREATE TABLE [dbo].[DeploymentTarget_Temp](

[DeploymentTargetID]...

It's not RBAR (Row By Agonizing Row), it's just ugly.

Take this piece and run it on the foreign server, dump to a local temp with only the columns you need,...

Tom.Thomson (8/26/2011)

---

I suppose some might go for the "error" answer if they think that "define" is a reserved word that would need to be quoted when used as a table...

Francis McFaul (8/29/2011)

---

Well, 2) is definitely out of the question. They're asked me to stay beyond my 6 month committment, and I said "No, thank you" -- mainly because...

You...