Viewing 15 posts - 14,281 through 14,295 (of 49,552 total)
You have some third party tool backing up the databases as well as the native backups. My guess would be backupexec. The native and the 3rd part backups are interfering...
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
February 14, 2013 at 2:22 am
durai nagarajan (2/14/2013)
check any log truncation or shrink happened before the backup starts.
Neither of those will affect a differential backup base.
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
February 14, 2013 at 2:21 am
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
February 14, 2013 at 1:46 am
Mac1986 (2/14/2013)
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
February 14, 2013 at 1:43 am
SQLSACT (2/14/2013)
How does this process differ for Hash Joins?
Why don't you go and read the book that's been recommended several times, do the research and see for yourself?
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
February 14, 2013 at 1:40 am
Grab Kalen's book, Adam Machanic's memory grants video and go over them.
Memory grants for sorts are, oddly enough, memory. If the process can't get enough memory, then the sort spills...
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
February 13, 2013 at 11:47 pm
Probably because you have log backups scheduled that are marking the log as reusable. That way the later deletes reuse the same space as the first set
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
February 13, 2013 at 11:35 pm
prettsons (2/13/2013)
If you don't have backup then you can also try third party SQL Database Recovery Software to repair your database. First try software demo version.
Except that the database wasn't...
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
February 13, 2013 at 11:17 pm
That trigger assumes that any insert operation inserts one and only one row. An insert that inserts more than one row will result in weird behaviour. I would imagine that's...
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
February 13, 2013 at 1:21 pm
Why would you see a tempDB allocation when something's not spilling to TempDB?
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
February 13, 2013 at 12:25 pm
That particular alter, no.
Other options in alter database may require single user mode, see BoL for details.
p.s. Please post SQL 2000 questions in the SQL 2000 forums in future....
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
February 13, 2013 at 9:59 am
jwgmpi (2/13/2013)
Manually re restore the database stuck in recovery mode. The status will clear back to normal
If you mean running RESTORE DATABASE ... WITH RECOVERY, that's for databases in the...
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
February 13, 2013 at 9:53 am
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
February 13, 2013 at 9:30 am
Use both DTA and missing indexes as guidelines, nothing more.
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
February 13, 2013 at 9:27 am
Constraints can't have includes or filters, that's pk or unique constraints.
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
February 13, 2013 at 9:25 am
Viewing 15 posts - 14,281 through 14,295 (of 49,552 total)