Viewing 15 posts - 14,656 through 14,670 (of 18,923 total)
Can you post more details :
DDL of the tables
Sample data (insert dml)
the results you want from the query
your query
the results you are getting now.
August 5, 2005 at 10:36 am
What do you want to do in the loop that you can't do in a normal update/insert statement??
BTW you might be interested in reading this.
August 5, 2005 at 10:05 am
Insert into dbo.LocalTable (col1, col2) Select col1, col2 from LinkedServerName.DbName.dbo.TableName where DateDate between @Start and @End
Look up linked servers in books online.
August 5, 2005 at 10:01 am
Here's funny anecdote from the same guy. He's a very smart computer guy, almost all self thaught. I mean he could teach me stuff for 3 days straight on...
August 5, 2005 at 9:56 am
No need for an acronym finder on this one : NFW you id 10 t
.
August 5, 2005 at 9:28 am
Is there any other relevant info to copy besides that (like the history).
August 5, 2005 at 9:12 am
Well sometime changed because that fails now... What's the error?
August 5, 2005 at 9:05 am
It should... but it would take too long, so every once in a while you get a bad number in there.
August 5, 2005 at 8:49 am
You can also use the profiler to find out the slowest running queries and optimize them... and at the same time you could throw that trace in the index tuning...
August 5, 2005 at 8:42 am
Can't you just move the most active db(s) to a new server... downtime would be minimal if you move less stuff.
August 5, 2005 at 8:41 am
Don't think they need a farm for such a small site (no offense)?? I had a server once sending a few M pages/month and it was a PII 500.
August 5, 2005 at 8:34 am
Viewing 15 posts - 14,656 through 14,670 (of 18,923 total)