Duplicate post.

Replies here please : http://www.sqlservercentral.com/Forums/FindPost1188266.aspx

Simple question, thanks for the reminder.

I don't think that a batch script is the right tool for this kind of things.

I would rather look into PowerShell or, at least, VBScript.

Batch scripting has a very limited...

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1188287.aspx

Example:

EXEC msdb.dbo.sp_update_jobstep @job_id='job_id from sysjobs',

@step_id=2 ,

@on_success_action=4,

@on_success_step_id=8 -- set next step

Full documentation here: http://msdn.microsoft.com/it-it/library/ms189827.aspx

Jayanth_Kurup (10/11/2011)

---

I think; before looking at the speed you need to understand the impact it has on the actual table definition.

Collations and datatypes etc will come into play when the...

You mean this one[/url]?

It's undocumented, but Paul Randal says it's safe...

+1

For small datasets, I'd go with SSMS ToolsPack.

The tool comes with lots of useful features and it's free.

See here for details: How to transfer logins and passwords between instances of SQL Server

SELECT ... INTO can be minimally logged, while INSERT INTO is fully logged.

From a performance standpoint, it makes some difference.

I say...

You're welcome.

Glad I could help

It depends! (You should have seen that coming :-P)

For production code I tend to avoid the use of undocumented commands/features. For my own scripting I make a fair large use...

You're not supposed to endorse anything you don't find worth the money.

If you think that a commercial...

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1187799.aspx

Grant Fritchey (10/7/2011)

---

Gianluca Sartori (10/7/2011)

---

Grant Fritchey (10/6/2011)

---

For additional methods of dealing with parameter sniffing, check out Chapter 38 of the SQL Server MVP Deep Dives II[/url] book. It covers things...