That's one way to do it. After restoring consider changing the AUTO_CLOSE property on your database(s) to False.

You can execute a vb.net app from a network location. If you were to post the vb.net app on a file server where all people who needed it could reach...

32-bit?

Do you use the Spatial Types in your database code?

N11689 (8/14/2012)

---

We have a new app that needs to automatically create a pdf and email it.

We will be writing a new Crystal Report that will call a sql stored procedure...

N11689 (8/14/2012)

---

From what I have 'googled', I don't think we want to use xp_cmdshell.

What about SQL CLR? Can you call a vb.net exe (not dll) using an...

Schedules are attached to jobs so the best you can do is figure which job or jobs are using that schedule:

USE msdb;

SELECT j.name

FROM dbo.sysschedules s

...

From my perspective you should be looking at turning this process inside-out and using PowerShell to execute whatever you're doing with xp_cmdshell, bcp.exe to load your file and sqlcmd or...

Know that the number of triggers is not the determining factor for performance. Instead consider the complexity of the trigger and the volume and frequency of transactions against these tables....

It should be noted that xp_cmdshell is disableb by default in SQL Server (since 2005) and for good reason. Consider carefully before enabling it the security implications. Do you want...

Another advantage of INT declared as IDENTITY for surrogate keys is the increased potential of keeping fragmentation down over time. Are patent ids ever-increasing in value over time as they...

martin.david (8/12/2012)

---

Peter Brinkhaus (8/12/2012)

---

Assuming that the TradeID column is unique (primary key?), why not use a UNION ALL instead of UNION. This avoids a (expensive) distinct sort to filter out...

dcdanoland (8/13/2012)

---

Thank you so much for your detailed comments. They have been most helpful. I hadn't thought of dividing the task up into file watching and file processing, but that...

dcdanoland (8/13/2012)

---

Thanks for referencing the discussion on the WMI article. It was most helpful. Your description of the standard batch processing and ETL design matches my experience.

What sort of load...

Suburbanites

dcdanoland (8/13/2012)

---

You make very good points regarding Microsoft testing and the WMI Event Watcher Task. I guess my qualm is that it seems to be an afterthough by Microsoft. All...