Do you back up on a tape? Any trouble with that tape?

At this moment I do not know anything about your reporting needs and environment. I'd say that the database snapshot is suitable for you, however consider the limitations (BOL --->...

In my opinion this is rather a design problem. Try to redesign your query like this, for example:

SELECT <column_list> FROM <table> WHERE CategoryID = <category id for "hotels"> AND...

Grant Fritchey (4/23/2010)

---

dmoldovan (4/23/2010)

---

Follow Grant's good advice.

Select the events and other trace properties in the GUI, start the trace, immediately stop it and select File ---> Export. This way you'll...

Follow Grant's good advice.

Select the events and other trace properties in the GUI, start the trace, immediately stop it and select File ---> Export. This way you'll obtain the scripted...

Which events did you select for the trace you're running?

Download Tom Davidson's white paper from Microsoft (Google ---> search for sys.dm_os_wait_stats white paper).

You can find there scenarios for OLTP and warehousing environments.

Try o use the APPLY operator

http://www.sqlservercentral.com/articles/APPLY/69953/

Query the sys.service_message_types, sys.service_contracts, sys.service_queues, sys.conversation_endpoints catalog views.

For exemple, this query (taken from http://www.apress.com/book/view/1590598423) gets the contracts for the defined services:

SELECTsv.[name] AS [Service],

sc.[name] AS [Contract]

FROM sys.services sv

JOIN sys.service_contract_usages...

I'm not sure I understand this...

Convert the csv into xml and import the xml using the "nodes" method of the xml datatype.

There are also a missing index on the ImpressionTitle table.

Check for the "MissingIndexes" tag in the xml plan.

See

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10317.aspx

You can also try a PowerShell script

http://blogs.technet.com/heyscriptingguy/archive/2007/10/31/hey-scripting-guy-how-can-i-use-windows-powershell-to-delete-all-the-files-in-a-folder-older-than-90-days.aspx

If you prefer VB, search their "script repository".

You can easily schedule the script using SQL agent or Windows "scheduled tasks".

Microsoft recommends to "isolate services", see http://msdn.microsoft.com/en-us/library/ms144228(SQL.90).aspx

I have some experience in running a SQL 2005 instance on a domain controller. The MSSQLSERVER service ran on a domain account....