I faced a similar issue and your solution worked...thanks!!!!

Got a temporary workaround:

http://support.microsoft.com/default.aspx?scid=kb;en-us;823177

Thanks.

Thanks a lot... it works for us!! 🙂

Yeah, that should give the desired result.

You can use Row_number function:

select a.sid, a.gpa, a.date_of_Update from

(select sid, gpa, date_of_Update, ROW_NUMBER() over (partition by sid order by date_of_update desc) as Rno

from table)a

where a.Rno = 1

I was facing the similar issue. In my case, I was creating the SQL query on run time using script task, storing it in a variable. The default value that...

Sanjay Rohra (4/23/2010)

---

If you run all the jobs that are going to insert data into Table A in parallel, there will definitely be blocking and it might also lead to...

If you run all the jobs that are going to insert data into Table A in parallel, there will definitely be blocking and it might also lead to deadlock causing...

This worked for me...thanks.

I believe we can use the procs sp_spaceused and sp_statistics for temporary tables by changing the context to "tempdb" database. But that can be done only in the session in...

I have not faced any issues with sp_statistics as far as comparing the results with SELECT COUNT(*) as I do keep on comparing both the results (for my curiosity).

Use sp_statistics and refer to cardinality column for rou count.

Hi,

I am sql 2000 certified DBA, currently working as a SQL 2K5 DBA. I am planning to upgrade my certification credentials. What should I go for, SQL 2005 or SQL...

I had a similar requirement. was running out of disk space, hence had to compress the log files. After taking the backup of the log files and truncating them, I...

kumar99ms (11/3/2008)

---

Hi Team,

currently i am taking backup to my remote servers using ftp but now that backup size to long how can i take my backup could you please some...