Viewing 5 posts - 1 through 5 (of 5 total)
Found..ITs a bug in MSSQL 2005.
October 31, 2011 at 5:44 pm
top 5th Salary of every department
SELECT * FROM (
SELECT EMP_ID, DEPT_ID, SALARY, NAME
,RANK() OVER (PARTITION BY DEPT_ID ORDER BY SALARY DESC) AS RANKID
FROM EMP) A WHERE RANKID = 5
August 17, 2009 at 11:49 pm
This is quite a contrary queston..The max size of the database is a capacity planning chapter. If your Physical server can support, you can have a DB size in TB's....
November 29, 2006 at 2:48 am
This is indeed amazing, However, there is a possiblity that sometimes the sysobjects table may go correct and so the Database engine does not finds the table.
Possible reason ??
November 29, 2006 at 2:42 am
The duplicate records delete query solved my issues.. thanks to the community..
July 27, 2004 at 6:27 am
Viewing 5 posts - 1 through 5 (of 5 total)