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...
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.
February 14, 2013 at 2:21 am
Mac1986 (2/14/2013)
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?
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...
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
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...
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...
February 13, 2013 at 1:21 pm
Why would you see a tempDB allocation when something's not spilling to TempDB?
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....
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...
February 13, 2013 at 9:53 am
Use both DTA and missing indexes as guidelines, nothing more.
February 13, 2013 at 9:27 am
Constraints can't have includes or filters, that's pk or unique constraints.
February 13, 2013 at 9:25 am
Viewing 15 posts - 14,281 through 14,295 (of 49,552 total)