Hi all, We are in the process of migrating our databases from SQL 2000 to SQL 2005, As a part of this, we figured out that there is some code which...
Hi all, We are in a process of migrating our databases from SQL server 200 to SQL server 2005. Unfortunately some of our SPs and UDFs and written in...
Hi all, We have a UDF which is returning the result in 2 seconds. When i copy the code(just two select stmts) in the UDF and hardcode the values,...
Greetings All, I am having a SQL Server 2000 running on Windows 2000 Server(Live Production Server), now my company procured a better hardware, so I...
Hi all, I was monitoring the performance of our SQL SERVER using perfmonitor. The data for several counters was collected for a period of 24 hours....
Hi all, I was trying to capture 24 hours of performance monitor data for our SQL server in a log, Later on I intend to display the values of these...
We have a merge replication taking place for every 5 min in which the subscriber is populating the tables with 10 transactions/sec. We have 2...
We are trying to change the domain of our development server (2 in number) and a production server (1 in number). Previously our logins are created...
Hi all, Our SQL server from yesterday is taking a lot of time to run daily jobs. I am running the profiler and the performance monitor , its not...
Hi, We have a peculiar problem with our SQL server. I got a call from some of our developers that they were not able to access the server, when i...
Our database has a scheduled loding process from evening 6 to 6 next morning. the database is huge and I have to decide on the backup and recovery...
Hi, My company has a single large (400 G) database to which data feeds are comming from few oracle databases. There are some DTS packages which...
Separate names with a comma.
