EddieN1 (9/27/2013)

---

If I set up a separate schema, wouldn't the SysAdmin have access to it? Couldn't he put himself in the group the schema is restricted to?

Also, the "remote"...

That's up to you, how you configure it.

If you just want to overwrite the data,...

Yep. 100%. I've run it from Apple, Linux and, of course, Windows. Except for the small sections of it that still require Silverlight, it works fine on any OS with...

It's possible, yes. It's just not terribly practical. You could have the data files there, not the tables, and you could attach and detach the database. But, it's going to...

GilaMonster (9/26/2013)

---

Think? First thing you need to do is time the steps and see for absolute certain...

I currently work for Red Gate, but, prior to my employment here, I worked with the Red Gate tool belt for 10 years as a DBA. My love for the...

The options are, query the dynamic management objects (DMO) such as sys.dm_exec_requests while the query is running in order to see which locks are taking a long time during execution....

You might want to take a look at SQL Server Integration Services, SSIS. That's the standard Extract, Transform, Load (ETL) tool for SQL Server.

hisakimatama (9/26/2013)

---

SQLRNNR (9/26/2013)

---

hisakimatama (9/26/2013)

---

Aaaaaaargh... And now, I need to fume :-P.

Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to...

This is really down to opinion, but my feelings on it are, you should add comments for clarity.

If you're doing something really complex in T-SQL, tell us what it is....

Talib123 (9/25/2013)

---

Grant Fritchey (9/25/2013)

---

Full backups and the log backups are disconnected. You can go back to BackupA and then run all the transaction logs. Full backups and log backups are...

Take a...

Full backups and the log backups are disconnected. You can go back to BackupA and then run all the transaction logs. Full backups and log backups are not linked like...

The backup process is a page by page copy of the database. So the restore process is the same. For any object to simply be missing means that it was...

sunny.tjk (9/24/2013)

---

Grant Fritchey (9/14/2013)

---

I would not recommend disabling parallelism. It's a good thing. I would suggest that you bump up the default value for the cost threshold for parallelism. The...