Thanks Koen. As a production DBA, I prefer the methods that don't involve BIDS/SSDT, since I don't want to be opening packages in the design tools just to deploy...

Smells like a homework question to me. Have you looked at sqlcmd? If so, what have you tried? By the way, a folder contains subfolders and/or files....

jon.wilson (9/23/2015)

---

I'm trying to figure out how to do the following:

Number of People receiving their second speeding ticket during this time frame

4 Jun 06 -3 Jun 07

4 Jun 07 -3...

Why do a delete followed by an insert, instead of just doing an update? What is the nature of your random performance issues? Only use READ UNCOMMITTED if...

Another option is to drop indexes instead of disabling. Drop the non-clustered index, then drop the clustered index. Do your load, then recreate the clustered indexes followed by...

OK, paste that into your favourite search engine - you should get quite a few suggestions.

John

What is in the SQLAgent.OUT file? You can find the location by right-clicking on SQL Server Agent and choosing Properties.

John

Or, given that (I think) you only have five columns, you could bubble sort:

WITH MyTable (col1, col2, col3, col4, col5) AS (

SELECT 222, 444, 555, 111, 333

)

, FirstSort (col1, col2,...

Not if you're already on service pack 3, no. Are you sure it's not referring to a Windows service pack? Do you have any other instances on the...

Thiago

What happens if you try to use the GUI to drop the table?

John

Phil

I think it would be simpler. With Execute Process, you can use sqlcmd to execute the script from wherever it is. With another Execute SQL, you'd need somehow...

Have you tried using Powershell? Build the command with an expression, then use an Execute Process task to run it.

John

Don't use recursive CTEs to generate number sequences. You can only have a maximum of 32,767 numbers, and it's less efficient than the CROSS JOIN method. The recursive...

Use an Execute SQL task to get the list of reports, then loop through the list and use an Execute Process task to run each script.

John

Are you familiar with SSIS (Integration Services)? If so, it might be worth creating a package to do this. If not, it's fairly simple to loop through your...