Ninja's_RGR'us (12/20/2011)

---

salary.com might give you those answers.

My answer is whatever someone's willing to pay you after the interview, and more importantly on ongoing basis after they get to know you...

I would test you can copy files to the remote location before deciding on log shipping since all you mentioned was port 1433.

Another option could be mirroring with database snapshots...

I'll give you the two tables and the proc to get them out.

All the information you need is in the two tables. I've got a script that does this...

The most efficient way to do mass deletions is to introduce a sliding window partitioned table setup.

This would allow you to switch out whole days of data with...

Depends on the contract.

Its likely they are worried about the intelectual property in for the form stored procedure code and not the data which belongs to you.

There's no reason why...

Try taking out the quotes.

Or read this and search for ampersand. http://technet.microsoft.com/en-us/library/ee176949.aspx

Koen Verbeeck (12/19/2011)

---

Ahem. You all are older than me.

I'm a child...

Not a good idea as this is piracy. Reported to admins.

You cant make a recommendation without the correct research. Asking on the a SQL Server forum how you can justify recommending Oracle to your business possibly isnt the way...

Management studio never (as far as I know) scripts out secure information such as passwords.

The Snapshot agent requires a login and these are scripted out as null and therefore need...

This is what you would do and it would be transparent to any coding youve done.

exec sp_rename 'old_tablename', 'new_tablename'

GO

CREATE VIEW dbo.old_tablename AS

SELECT column1, column2, column6 /* moved column */, column3,...

Why not rename the table and create a view of the same name with the columns in the required order?

The previous comment is correct. Dropping the article and readding it is the way to do this.

-sp_dropsubscription

-sp_droparticle

-sp_addarticle

-sp_addsubscription

If you arent sure on the syntax for the above, script out the...

I've added a few extra lines.

<#

.SYNOPSIS

Function to script all SQL jobs

.DESCRIPTION

...

I use this.

<#

.SYNOPSIS

Function to script all SQL jobs

.DESCRIPTION

Writes...