Hi All, The following is a part of my storedProc: UPDATE #TMP SET ItmRecvdYR1 = ISNULL (( SELECT SUM ( Quantity ) FROM dbo . GetAllReorderScannedItemsByDate () WHERE VendorID = t . VendorID AND locationno = t . LOC and DATEPART ( YEAR , requisitiondate ) = DATEPART ( YEAR , t . DateYR1 )), 0 ), FROM...

The set-up is Dell PowerEdge 2950 with two dual-core Xeon CPU, 4GB RAM and plenty of SAS RAID-5 disk storage. The system is running ESX Server v3.5 (for disaster recovery). A single virtual operating system is installed running Windows 2003 R2 standard 64 bit with the latest service packs. The core software...

Hi, I have a SP that would consume a xml as an input parameter and insert the data into tables. I am using the nodes() method to query the data in the xml doc. , but I am not sure about its performance. Especially, I need to use 'join' to filter the data. I want to know if I dump the xml doc...

Hi Folks, Actually am running some batch of sql statements in a loop. Initially it Runs good but then ina middle am getting an exception "Could not allocate space for object 'dbo.Large Object Storage System object: 443201315799040' in database 'tempdb' because the 'PRIMARY'...

Hi There I created the test below as a quick check of the servers committed write capability. This scripts runs acceptably fast on my laptop, (which is about 3 year old 7200rpm hard disk, 2.something GHZ pentium processor. 2gb memory. Windows XP 32 bit.) By comparision we have a 64 bit server that is...

Hi, To give you a better understanding, I am just trying to create a replica of my situation, so kindly ignore any syntax errors: In the following temporary table, i have inserted 1000 employee ids, based on some previous different selections: XML columns are null at the moment create table #tmpEmpXML...