Viewing 15 posts - 24,001 through 24,015 (of 49,552 total)
SQL Express 2008 R2 has a 10GB limit. If your DB is larger than that you'll need to buy a licensed version of a higher edition.
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 23, 2011 at 2:55 am
So the rest of the columns should be taken from the row with the max end date?
p.s. You either haven't read that article or are ignoring it... I can't test...
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 22, 2011 at 2:25 pm
btw, if that were my DB, I'd be trying to get it onto alternate storage first, before something worse corrupts.
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 22, 2011 at 2:23 pm
KB - 2000 (8/22/2011)
Anything specific that we should be checking on the I/O subsystem?
Everything.
It could be anything in the IO stack, from anti-virus right down to the disks.
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 22, 2011 at 1:35 pm
GilaMonster (8/22/2011)
To shrink TempDB properly you need to completely quiesce the server
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 22, 2011 at 1:30 pm
Shrinking TempDB while it is use is not recommended and can cause problems. To shrink TempDB properly you need to completely quiesce the server
http://support.microsoft.com/kb/307487
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 22, 2011 at 1:24 pm
If the log is 10GB from regular database activity then it needs to be 10GB and you need to ensure you have that much space.
Maybe reducing the interval between 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 22, 2011 at 1:23 pm
MyDoggieJessie (8/22/2011)
Is there a general rule of thumb for this?
If the column is in the where or join (or order, group) then it needs to be in the key. Otherwise...
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 22, 2011 at 1:20 pm
It depends on the cost of the key lookup, the gain from covering the query and the increase in DB size (maintenance time, backup size) and impact on data modifications.
Can'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
August 22, 2011 at 1:19 pm
Lowell (8/22/2011)
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 22, 2011 at 12:58 pm
Typically the more frequent the log backup the smaller the log file can be. But that requires no long-running transactions, no replication. If you're doing index rebuilds in full recovery,...
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 22, 2011 at 12:51 pm
EjSQLme (8/22/2011)
So, is it normal for a t-log to be over 10GB even though you are doing a t-log backup?
I used to work with a DB that had a...
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 22, 2011 at 12:13 pm
Have you looked through this? http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 22, 2011 at 11:37 am
Can't be a trigger. Error specifically lists the proc in question.
Errors from login triggers don't go to the messages (because the login fails as a result)
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 22, 2011 at 11:23 am
No. It won't (there's no backup_log option on Backup Log)
Please go and read my article and stop shrinking your 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 22, 2011 at 11:20 am
Viewing 15 posts - 24,001 through 24,015 (of 49,552 total)