Yes and no. Some sites want to hold the copyright. We don't. Not sure about SSWUG. We do ask that you do not submit anywhere else for 90days if you...

Are you looking for a "row number" type thing?

http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

Andy Warren, Brian Knight, and Steve Jones run this site. Steve Wynkoop runs sswug. We know each other, but that's it.

sswug is an aggregator of content for the most...

Run profiler and see exactly what is happening. Also perf mon to be sure that SQL has enough memory, CPU not stacked, etc. Brian Kelley has a great performance tuning...

Use the same technique as this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=107483

More about it here:

http://www.sqlservercentral.com/columnists/sjones/batching.asp

CASE statement,

sorry

you can also use WITH NO_LOG

Why do you need this functionality? I've got a package that checks the backup path and if it doesn't exist, creates it.

select @cmd = 'exec master..xp_cmdshell ''if not exist '...

Never tried this and not sure it will work. Typically I've opened and resaved each on the new server. Or exported to flat file (.dts) and then imported.

I think this broke when we converted teh site. I'll mark it as a bug to work on. In the meantime, here are a couple links:

DTS: http://www.sqlservercentral.com/columnists/sjones/sqlserverdtsresources.asp

DMO: http://www.sqlservercentral.com/columnists/sjones/sqlserverdmoresources.asp

Licensing:...

Sorry, can't dig too deep right now, but this occurs for me. I suspect that more of these parameters are  not optional and must be included.

It shouldn't grow that big if you are committing as Antares suggested. You can always make the batch smaller, like 100, and add a small delay, like a second, between...

It sounds like the setup path you are entering is incorrect. Can you verify the UNC path from explorer?

Agree with Wes. Should work, but you need to be sure you add some horsepower, or live with the short performance hit.

In Windows, fragmentation is more of an issue. For SQL Server, I wouldn't recommend defragmenting the data files or log files unless the server is at low load, but it...