Hi, I am trying to tune a query on SQL Server 2005 (SP1), and I was taking note of results of STATISTICS IO and STATISTICS TIME. Here are the...
Hello everyone,<br /><br />I have the query 1 running on SQL Server 2005 instance, and it has different execution plan from that of query 2. The good...
Hello All- I have this query and it times out thro' application on the first time run. But, 2nd and 3rd runs go fine and quick. I need your expert...
Hi there,<br /><br />I have a query<br /><br />SELECT <br /> BPE.[EmpLastNm]+'...
Hello everybody,<br /><br />I have a query which updates the target table from a staging area. <br /><br />Query:<br />UPDATE...
Hello experts,<br /><br />I have a query as below<br />UPDATE [Edge].[dbo].[tblCustomerFile] SET <br /> BillingCurrCd=Stg.EdgeCd<br />...
I have query written to extract data and takes more than 40 minutes...and its getting really frustrated. <br /><br />Query:<br />SELECT <br...
Hello everybody, I have a situation where I need your thoughts on how to recover the database. I have a dts process which would insert, update on...
Hello everybody, We are trying to consolidate our servers, (already posted few questions in this forum) and as a requirement from the management we...
Hello All I have be assigned of moving a database from one production to other production box. I need to follow new conventions laid per the Mgmt...
I had an argument with my coworker on granting privileges to a developer on a production box, to build a DTS package. Well, my question was that...
Hi All- I have a situation here; I need to give permission to one of the developers to run a DTS package in production. I am trying to simulate in...
I have been working on gathering statistics of database growth for past few months. I started of with taking the database size, free available space...
Hi All I have a backup job running every night for every 1 hour between 10 pm & 6 am ET. I had to make some changes to backup script and change of...
Hi<br /><br />I have a tight situation here in my shop. I have a database which sits on an old server in production environment. Of late, the...
In my shop I have a DTS package scheduled at early hours of the day. It failed today with a deadlock error and I had to re run the job and it failed...
Hi, In my shop I have a Sql server 7, with latest patches installed. customers of the application are for intranet. The Sql server had been quite and...
I have a query and am a bit perplexed with few facts. In our shop we have a database of 40+ gigs & has weekly optimisation jobs (DBCC DBREINDEX),...
I have a database of 30 GB and the free avail. space is around 15 GB in MDF file. The system is running short of data drive space, and I believe I...
Can anybody help me in writing a script to detect suspect database, as I don't have any monitoring tools in my shop for monitoring. ? Thanks in...
Separate names with a comma.
