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, 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...

Hi, I'm trying to build a stored procedure in order to import data from an excel file to a temporary table. I'm using the following code: set @strSql = 'SELECT * INTO #TempTable FROM OPENROWSET( "Microsoft.Jet.OLEDB.4.0", "Excel 12.0;Database=C:\FileName.xls ","SELECT...

Thanks Preethi For the reply How would I re-write the query to remove the OR to make the query more efficient? Also I am interested in the permanent table, this is not something I have though about Can you please give me an example of how to write different scenarios and write different SQL statements...

Hi, take a help of SSUA tool which will give you good information on where you need to change the code, here is the reference for t-sql code http://blogs.msdn.com/steven_bates/archive/2006/02/11/TSQL-Enhancements-in-SQL-2005.aspx

I have noticed that inserting from XML is faster when using openxml and slower when using nodes(). Here is a script you can run to see the difference. The difference in performance is even more pronounced when the table is wider. Also, the execution plan for the openxml case is far simpler than for the...

Hi, Another workout is to create a Distribution List -> add users to who you want to send emails-> send mail to this DL

I inherited a SQL 2005 server. Initial installation has the sytem DBs on the O/S partition. So were all the user DBs. I was able to move all the user DBs to another partition and want to do this with the system DBs but have been running into problems. I have read everywhere that talks about using SQL...