Didn't get through the white paper, but did look at 3 of their sample apps. All look the same. Not sure there's anything great here.

Steve Jones

sjones@sqlservercentral.com

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

thanks for the comments. I know I needed a refresher (which got me writing).

Steve Jones

sjones@sqlservercentral.com

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

Haven't seen too many that work well. There was one called My Little SQL or something like that, but I didn't try it.

Here's one for MySQL:http://anse.de/mysqlfront/

Another for MySQL, Postgres, Oracle:

...

It must rollback a transaction, so it may have been stuck. I'd bet that it would have eventually killed the process, but I have seen things hang and a reboot...

There are extended stored procedures that link SQL Server to mail (the xp_startmail, xp_sendmail, etc.).

Some of these include the ability to read mail and you can process the items...

Try restoring with no log. I'm surprised it wants so much temp space, but it may be a check of x times the size as a just in case.

Steve Jones

sjones@sqlservercentral.com

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

sp_dropserver

sp_Addserver <new name>,local

will rename the server

Steve Jones

sjones@sqlservercentral.com

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

I usually do two things.

1. Measure the time (use select getdate() around the queries) on the server or client.

2. Check the subtree cost. The percentage cost will always be 1...

Roll with fulls every hour (or every 30 minutes) and then logs every minute or two.

Be sure you get these off the local server in case the server itself fails.

Steve...

Sorry, I see what you mean.

In the code, the first replace is a single quote, followed by 2 single quotes, then another single quote. Why 4?

1 - open string

2...

I roll with logs every hour and once a day backups. We may shrink this down. However, it's a question of restore time. How quickly do you want to be...

Tough to say. Are teh servers the same hardware? Could be that. Could be fragmented. Might want to check with dbcc showcontig and rebuild clustered indexes.

Steve Jones

sjones@sqlservercentral.com

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

Thanks .

I need to modify this, but the main point still stands. Make someone write some code and use questions that show someone understands SQL, NOT that...

Each single quote must be doubled for SQL to work a ' repeated as '' is not the same as ". They are two difference characters.

If you replace(@string, '''', '''''')...

You are welcome and glad to help.

BTW, I usually use a Domain account so I can get to mail, remote backups, etc. Local Admin, not Domain admin.

Steve Jones

sjones@sqlservercentral.com

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