Hi,

The sp2 for sqlserver 2008 RTM (IA64\x64\x86) was released on 9/29/2010.

Version no will be 10.0.4000

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17

Cheers!

Hi,

I ran this code in already opened SSMS windows and got 0,1 which is a wrong answer but later on I got 1,1...

Can't seem to understand why I got...

Thank you very much:) I tried earlier in dynamic sql but the only mistake I made was that I didn't execute my select statment i.e the second stmt after ALTER...

hi,

I agree with the 50 instances for Enterprise and 16 for standard based on the following link that I read on MSDN>

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Can somebody tell me...

I used your suggested way but it still took 20 minutes on a server with minimal activity. It completed in 10 seconds when I used #temptable which was created based...

I used your suggested way but it still took 20 minutes on a server with minimal activity. It completed in 10 seconds when I do it with #temptable

The execution plan is pasted below. I tried formatting it to be more presentable but the editor did not allow. So I have attached the showplan_text file.

The table with...

Hi Randy,

Thanks for the article. We also had similar issues joining two three tables with over 200 Million rows with WHERE condition, the O/P was dying if we used...

Hi Jack,

Thanks for the reply. Do you have any sample code or step by step procedures for this?

Regards,

Razi

http://www.questivity.com

What I have noticed is that even though the browser service is turned off we can still see the green on the registered servers but only if the version is...

Hi,

I think I have seen similar issues if you register SQL Server 2000 server on SSMS(2005).

Try to use Network Protocol in the connection properties of Server Registration properties....

Hi There,

If you have for example this value in your row 1,2,3,4,5 or 'Ab','cd','efg' I suppose the column will be a varchar or char in this case...

Hi,

Thanks for the reply, I checked the link and it is for SQL server 7 which im not sure will hold good for 2005.

I noticed onething on the...

Hi,

FYI, The statement Reconfig with over_ride for Max Memory setting doesn't require a restart.

Thanks- I didnt get you. I know that when you fire a full backup the active portion of the log is also backed up. But my question was is the...