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...
Yes, dinesh the service packs are same, the hardware configuration is same, sql instances are also configured with same set of options. I am totally...
Hi there,<br /><br />I have a query<br /><br />SELECT <br /> BPE.[EmpLastNm]+'...
Thanks for the quick look thro' Frank. I tried with the option you have given, and still its running for nearly half hour. I suspect a Hash Join in...
Hello everybody,<br /><br />I have a query which updates the target table from a staging area. <br /><br />Query:<br />UPDATE...
Adriaan and others, I got it working as a charm. I used EXISTS and the update runs within 6 mins. Great! I got my work done for the day. Thanks to...
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...
Twan Thanks for the reply!. Yes you Got it! I need a 3 node cluster with 2 active and 1 passive. Now, my question out here is that don't we require...
Hello everybody, We are trying to consolidate our servers, (already posted few questions in this forum) and as a requirement from the management we...
Thanks to all who have given a quick solution for me! But what will happen to the single 100 gig data file, after sql server spreads the data in...
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...
Yes Satya, I am comparing the results.. and was curious to know why is it showing that large difference between the two values. Would you advise to...
Chakry, The database I am talking about has maxsize limited to 2048 Megs per file. I need to size the database and want to be expanded on time. Let...
May be I should rephrase my question. If I need to add a datafile then, do I use the method of checking avl. free space in database or in datafiles ?...
Separate names with a comma.
