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, 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, 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...
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 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, why SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')) to know the licence information is coming disabled???? Server is installed with SQL...
Hi, I would like to know the thing i'am trying is possible or not, in my server named DevServer i had an installation of SQL SERVER 2000 as default...
Hi, I tried restoring a database backup file to an existing fresh DB in SQL2005 Server, it gives a error saying no space , i'am pasting the error...
Can anyone explain me the following questions. 1.After creation of a stored procedure in the server , will the sql server will use the same...
Hi, I'am facing a situation where i'am really confused, there is a table named oOrder which has 1 million records in it, as this table is used in...
Hi, Is there any function which in SQL which returns the integer in a given format as we use to do in a front end application for eg.format(2,"000")...
Hi, I got information how to make work of Database diagrams in SQL Server2005, But i have a requirement that the DB diagram which i was using in...
Hi, Can any one provide me information on creating rules and defaults in SQL Server2005, when i tried right clicking rules or defaults in...
hi all, i'am engaged in migrating the database of one application which is developed in VB6.0 and SQL Server2000 to SQL server2005. Here the...
Hi i would like a suggestion from all the experts in this forum as i'am involved in design of a software package which is going to be VB6.0 as front...
hi, I'am doing a test case where i want to know in a numeric column as eg. below Table x Column Col1 40 88 NULL NULL to apply any aggregate function...
Separate names with a comma.
