The Litespeed console is very similar to the standard GUI utilities in SSMS. When you get to the option for the files, you can modify the file locations.

In the...

There is a known issue with SSIS OLEDB Source - where using a table/view directly performs very badly.

In addition to changing the batch size and commit size on the OLEDB...

Please be aware that starting SQL Server using local system...

What worked?

Just thinking out loud...

Have you restarted SQL Server since granting permissions on the UNC path you are attempting to back up to? Could it be that the current session...

Are you running both SQL Server and SQL Server Agent with the same domain account? If not, grant access to the account running SQL Server.

Backups run in the context...

It is going to depend on how you installed SQL Server 2008 or 2008 R2.

To explain - we look back at how 2005 managed access to SQL Server for the...

Tom McDonald-318966 (6/5/2012)

---

This is my first post, hope this is close to the correct place for this topic. We are switching our SAN from IBM SVC using Flashcopy...

Splitting the data file into multiple files *might* help - but it really depends on your IO subsystem and how you have the HBA's configured and the SAN configuration (cache,...

The hashed password from sp_help_revlogin is valid - and can be used to create the login on another server with the same password.

If you are migrating to a new system,...

GilaMonster (5/28/2012)

---

Correct. All an index (clustered or otherwise) guarantees it the logical order of the rows and pages.

If a clustered index did guarantee the physical order then there would never...

Without backups there really isn't much you are going to...

pdanes (5/28/2012)

---

I suspect that I'm going to get the standard "It depends" to this, but I'll try anyway:

If I have a Select statement that does several joins, is it better...

There are many scripts available that will build your restore scripts for you from MSDB. I took one of those, tweaked it for my process and use that process.

For...

Another option is to not allow them to write their own queries. Give them access to only execute stored procedures that you have vetted.

If they need something else, then...