hi all, Iam having a performance issue in one of our new server which is HP X3800 which have 16GB RAM loaded. Database size is 25GB and iam using AWE...
hi, actually the casting is automatically generated by a code generator in the application, its true that if we dont cast it its running fine,...
Datatype of WorkGroupHDRID is uniqueidentifier , so the issue is casting this datatype in SQL2000 is not having any problem but in SQL2005 its not...
Hi, I'am facing a weired kind of problem with by Sql2005 , when iam using a SQL statement like the following in SQL2005 its running infinitely and...
Hi All, After the migration of SQL2005 from SQL2000 am experiencing a issue that most of the reports which uses stored procedures are running very...
Hi, This was one amoung the best thread which helped me to solve the issue as i followed all the steps including the microsoft patch,now my WIN2003...
Hi, I'am very new to Datawarehousing concepts of SQL2005, my current doubt is how to present the data to the end user from the cube i generated in...
yes i agree that but the problem is as its a finished product we are having 2500 to 3000 reports to change that will be a huge man effort,also we...
Hi,I’ am facing a typical issue in SQL2005 after inserting "0" value into a decimal (18, 5) field, when I’ am running a select query the output...
Hi, We were in the process of migrating our application from sql 2000 to sql 2005. It is noticed that a particular method is giving us Timeout...
hi thanks for the valuable information provided..its showing good improvement... Regards Mat
hi to all gurus, why is that sql server management studio takes more time to load on a 4GB Raid1 IBM server than on a 1 GB Desktop PC, i have been...
Hi Gurus, I'am back again where i got solution for most of my doubts and issues, this time i'am after a compilation issue of SP's in sql server 2005....
Hi, I saw a following message in the error log of our server appearing many times, Database size is 7104 MB, transaction log size is currently 32 MB...
Hi thanks for the replies actually i'am very new to DBA profile , my current question is related with poor performance of one server i'am working...
Hi, why SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')) to know the licence information is coming disabled???? Server is installed with SQL...
i tried dropping the existing DB but still that space error is coming telling it can't restore the transaction log. one thing i noticed is after that...
No its not like that backup is from SQL2005 only with same edition.. Mat
Here application is not the main problem coz using any named instance we can point to any DB's but in this case just i need to make sql2005 as the...
Here it is.. TanjungMaria D:Program FilesMicrosoft SQL ServerMSSQLDataTanjungMaria.mdf D PRIMARY 2693070848 35184372080640 1 0 0...
Separate names with a comma.
