Hi hogpen, and welcome to the forum 😀

Good thing would be also to drop non clustered indexes on your claimdetail table before ETL and recreates them after.

Hope it helps....

There are times in production environments when your database is unresponsive because of the size of your transaction log, disk is full, backup of your log doesn't work (true story)...

Not related, but with sql server 2012 you have now Extended events, pretty similar to SQL Server profiler but with better performances and scalability. Check it out ! 😀

Thanks GilaMonster, my post is of course applicable only during extreme emergencies. 😀

Ok. Never did it. But found this :

http://ermahblerg.com/2012/11/08/cluster-ssrs-in-2008/[/url]

Hope it helps. 😎

Hi asranantha, 😀

I would use COALESCE AND CASE, because it's SQL standard.

SELECT CASE COALESCE(your_column,'NA') WHEN '' THEN 'NA' ELSE your_column END

Hope it helps. 😎

Hi Benki, 😀

I think SSRS is not cluster aware.

Check this post :

http://technet.microsoft.com/en-us/library/bb630402.aspx

Hope it helps.

Hi ben, 😀

select your msdb.dbo.backupset table to see what are your available backup sets.

Hi cdl_9009, welcome to the forum 😀

I don't know if i did understand your question but you can create templates within sql server profiler this way :

Click File >...

Hi Steve, this is called a RAID 5E right ?

Why not RAID 0 for the transaction log ?

Hi amitsdba, and welcome to the forum. 😀

If you run out of space and sql server becomes unresponsive, switch the database’s recovery model to simple . This empties out...

If you are trying to insert data from sql server 2000 into an earlier version of SQL Server, you can use linked servers.

insert into schema.table select * from linkOldSql2000.old_db.schema.table

insert...

Found this post :

http://community.dynamics.com/gp/b/ifks/archive/2011/07/20/sql-script-for-generating-insert-statements-from-table-data.aspx%5B/url%5D

Might help you.

Use the distinct clause :

SELECT distinct *

FROM USER_PRFL up

INNER JOIN BSP_LOB_Grp_Lookup bl ON bl.BSP_LOB_GRP = up.User_Group

INNER JOIN IMPACTED_LOB il ON il.BSP_LOB_CD = bl.BSP_LOB_CD

WHERE(up.User_Id= USER_ID AND @ReportingViews = 0)

OR(BSP_LOB_GRP...

Are column1 and column2 of your select clause included in the index ? If not, this is not a covering index.

Hope it helps.