Wednesday, October 9, 2013

[MS SQL Server] Query taking over 50 mins; Stuff with XML Path

[MS SQL Server] Query taking over 50 mins; Stuff with XML Path

Query taking over 50 mins; Stuff with XML Path

Posted: 09 Oct 2013 12:15 AM PDT

Hi I am using Stuff with XML Path for concatenating the data in multiple columns like city, town etc by Zip code. ie., unique column is Zip and all the cities will be concatenated to one cell, similarly town and so on. The query runs over 1 million data, table has 180 columns. I tried - Adding indexes to the table, it took 50 minutes to run the query. Added a temporary table to get only required 20 columns and added indexes to the temporary table and it helped reduce about 3 minutes.Checked the execution plan the issue was with the table scan. There are no filters required to generate this report.Can you please suggest what else could be done to improve.ThanksEsha

Number of files for database MDF

Posted: 09 Oct 2013 01:43 AM PDT

Hi,I have a system with 1 Quad core CPU and 32GB of RAM.The database files, the MDF only, are on a RAID 10 system (the LDF is on a RAID1 and tempdb on a SSD disk).The database is for an ERP application that's quite write and read intensive.Is it advisable to create an "extra" FILEGROUP and add another file (NDF) to the database and move some tables to that FILEGROUP?Some queries use UNIONs between two large tables. If on table was on PRIMARY FILEGROUP and the other table on my extra FILEGROUP would there be any advantage?Thanks,Pedro

SQL Server Top Third Party Monitoring tolls

Posted: 09 Oct 2013 02:58 AM PDT

Can you please any one give me the SQL Server top 4 or 5 montoring tools names and details like.. features,License details for each tool.if you give any tool report comparing with other tools would be Appreciate.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog