i am interested in learning SQL Server but am a beginner any help

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

I have the following: 4-node, 3-instance SQL 2005 64-bit Enterprise SQL cluster on Win2K3 64-bit O/S. SQL instance install occured 8 mos. ago Instance has been patched to SP2 Replication components not installed originally Therefore if I attempt to configure distribution I get the following error: 21028...

hi every body, i have a problem with exception handling in sql server 2005 i have written a code like CREATE Procedure PaginRec ( @PageNum int, @NumOfRec int ) as begin try Begin with DIVRES as ( select Row_Number() over(order by Responsible desc) as row, Responsible , Division from Bulist) select Responsible...

SELECT f1, f2, SUM(Convert(decimal(20,2), f3) FROM t1 GROUP BY f1, f2 ORDER BY f1, f2 (all three fields are nvarchar and f3 has values like '123,345.65') I am getting an error when converting nvarchar can some one please help me to get around this... Thanks..

I have 2 identical Hardware servers. They were bot purchased and set up the same exact way. They are HP DL 580 G5, 64-bit EM64t/x64 with 16 CPU's running at 2.9GHz with 64 GB RAM. Both have SQL Server 2005 installed. SQL Server has a max memory setting of 52GB. Both servers have a database called...

When i try to save data on sql 2005 database , it shows following error No row was updated The data in row 1 was not committed Error Source: Microsoft, VisualSutio, DataTools Error Message: The updated row has changed or been deleted since data was last retrieved Correct the errors and retry or Press...

I have an issue where I have phantom jobs running ... it appears that jobs are running at their old scheduled times along with their new scheduled times. I have reviewed the entries in the msdb.sysmaintXXX and msdb.sysjobXXX tables and I do not see an entry for the previous times. I have also deleted...

what is the diffrence in DBMS and RDBMS?

Another great and accurate article. A question I have is in your article you stated to select the 'primary key' for the tables or 'cancel' if you don't know them; if you don't know them and later find them out how can you update the table to use the 'primary key'? Would...