Viewing 15 posts - 42,976 through 42,990 (of 49,552 total)
It's not a new concept. It existed on SQL 2000 as well. Probably 7 too, though I don't have any docs.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
Significant quotes:
Tail of transaction log
The transactions that have been committed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:26 am
Lynn Pettis (11/25/2008)
(P.S. Glad to have you back on the site. Hope you enjoyed your time here in Seattle!)
Loved every minute of it. I just got back to SA...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:19 am
Looks OK. I can't see a logic problem.
The count is not necessary and it's expensive, doubly so since you're doing a count of the column, not count(*)
Try changing the count...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:15 am
Can you please fix the wrapping?
What's the proc supposed to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:13 am
You can query the sys.dm_exec_requests for requests with a blocked_by that's not 0 and a wait_time exceeding your threshold.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:10 am
Can someone give me a hand with this one? The earliest I'm going to have a change to sit down and work out some code is tomorrow afternoon when I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:09 am
It's doable. However, unless you can actually give us an example of the data (not a description, not the file extention) then it's not going to be possible to offer...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 10:05 am
llokshin (11/23/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 9:29 am
I didn't ask for the entire proc. I said, if you want us to do all of the work for you, give us table definitions (as create table statements), sample...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 9:27 am
The login name is not a valid identifier. Put square brackets around it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 9:26 am
Index rebuilds are logged operations and hence will cause tran log growth. There's nothing wrong.
You can switch to bulk-logged for the duration of the rebuild to reduce the impact on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 9:23 am
Try to run a backup from the query window - backup log...
If it doesn't work, what is the error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 9:14 am
mfaisal (11/25/2008)
Dear......i am found of SQL study. you help me what can i do it?
Please post unrelated questions in a new thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 9:13 am
In simple recovery the logs auto-truncate on a regular basis and hence cannot be backed up. There's no point, it wouldn't be possible to use such backups to restore because...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2008 at 9:51 am
vkundar (11/23/2008)
Just woundering am I dealing with a BUG ! while trying to restore a very large database (.sls extension) using litespeed restore command Xp_restore_database.
I've backed up and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2008 at 9:49 am
Viewing 15 posts - 42,976 through 42,990 (of 49,552 total)