Sounds like a classic case of parameter sniffing. Do a search on that term. There are multiple ways to fix the issue.

SELECT INTO with a linked server and that much data is going to cause you a lot of headaches. Linked servers move the data being processed from the linked server...

I have yet to put this into production, but in the dev & test servers where I've been using compression there are many positives regarding reads. The writes don't seem...

bhavesh_183 (7/30/2009)

---

Hello Friends,

I have fairly huge table having 1 million records. The table has a binary tree structure.

I want to write a procedure for getting all the children records for...

Since the query is currently running, you may need to use sys.dm_exec_requests. This will provide you with a current statement start & end offset so that you can see which...

It depends on what you want to do. You can use sqlcmd to run command line scripts to move data from 2008 to 2000 & vice versa. SSIS will work...

To answer the question, it's going to be approximately a wash. Replace acts as a drop & recreate.

But, I'd suggest pursuing what happened as well. What do the consistency checks...

Glad to hear it's fixed. I don't think you did what I was going to suggest, clean out the registry & then try the reinstall. I had to do that...

To my knowledge, they'll see some of the other databases available in the server, but they'll only be able to connect to and perform actions on the db's that you...

But you test their results, right? Those things are notorious for suggesting poor choices on indexes. You need to exercise...

bhuvnesh.dogra (7/30/2009)

---

Thanks

While browsing to HKEY_LOCAL_MACHINE>>software>>microsoft>>microsoft sql server

in the instance folder "REPORT_DEV"

REPORT_DEV>>MSSQLSERVER>>SuperSocketNetlib folder

therer should be one more folder "Tcp"

can u please tell me how can i generate...

gochaithu (7/29/2009)

---

Hi friends,This is Chaithanya.

I have some doubt's in preparation of Online Exam database.My first doubt is...

Too true, but I always like to...

I've never run into that one before. It sounds like a bug or possibly a coding error.

I'm recreating databases pretty regularly in 2008 and I haven't seen this. Just a...

Not really, no.

But you know, I was just thinking... If I had RAQ Report, I think it would solve...