Viewing 15 posts - 31,141 through 31,155 (of 49,552 total)
Is this a maintenance plan? If so, what's the retention period of the backups?
Appending or overwriting?
How much space is free on the drive?
What's the frequency of your full and diff...
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
August 20, 2010 at 8:19 am
Maybe try running a trace, see what's happening.
Is autoclose enabled?
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
August 20, 2010 at 8:11 am
I suggest you have a long read through file and filegroup backups and restores in Books Online.
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
August 20, 2010 at 6:34 am
As long as the databases are on the same instance, there's no performance difference between joining tables in 2 databases and joining 2 tables in the same database.
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
August 20, 2010 at 6:28 am
Error 112 is "not enough space on the disk"
As a wild guess, I'd say there isn't enough free space to write the backup.
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
August 20, 2010 at 6:23 am
Shouldn't
Dropping the index will remove that index from the DMV, but shouldn't clear it. Taking the DB offline, closing it, detaching it, restoring it will all reset that DMV.
Did they...
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
August 20, 2010 at 6:22 am
You cannot move filegroups from one database to another. A filegroup can only be restored to the database it was backed up from, or a restore of the database 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
August 20, 2010 at 6:20 am
shailashree (8/20/2010)
Yes SQL is also 64 bit. Will there be any problem by enabling AWE on the machine?
AWE is ignored on 64 bit SQL. It is ONLY needed for...
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
August 20, 2010 at 4:08 am
kladibeeto (8/20/2010)
Later I saw that process is returning rowcnt collumn from sysindexes to zero for all indexes on Fact table.
sysindexes is deprecated and should no longer be used. 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
August 20, 2010 at 3:29 am
Ramji29 (8/20/2010)
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
August 20, 2010 at 2:49 am
Bhuvnesh (8/20/2010)
Stefan_G (8/20/2010)
I have made some tests and for some of my large tables creating a second identical index is 3 times faster than creating the original index.
i will...
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
August 20, 2010 at 2:04 am
Is SQL also 64 bit? If so, there's no need for AWE.
I'd drop the max memory down to 6GB. Letting SQL take just over 7 GB (the 7 is 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
August 20, 2010 at 2:01 am
pankushmehta (8/19/2010)
1. During transaction log backup, is it the inactive portion of the log (LSN< MINLSN) that is actually archived?
This is correct.
The active portions of the log are...
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
August 20, 2010 at 1:59 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic972266-391-1.aspx
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
August 20, 2010 at 1:58 am
geramkumar (8/19/2010)
like to know in which scenario a page will be corrupted? how sql server understands that...
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
August 20, 2010 at 1:57 am
Viewing 15 posts - 31,141 through 31,155 (of 49,552 total)