Viewing 15 posts - 13,606 through 13,620 (of 49,552 total)
jasona.work (4/3/2013)
1. After-hours, switch all DBs from Full Recovery to Simple, sacrificing...
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
April 3, 2013 at 10:10 am
rob.phillips 38602 (4/3/2013)
Can you elaborate a bit on how you "manually" grow the database file?
The way you mentioned in your initial post.
Does that suggest the file is contiguous?
Not necessarily....
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
April 3, 2013 at 8:00 am
Abu Dina (4/3/2013)
GilaMonster (4/3/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
April 3, 2013 at 7:48 am
rob.phillips 38602 (4/3/2013)
Also, what's the difference between chaging the Initial (MB) file size versus allowing autogrowth to happen?
One is done manually by you, one is done automatically by SQL. 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
April 3, 2013 at 7:46 am
Rather grow the file manually, not because of file fragmentation (which may or may not be of any concern depending on the IO subsystem and a bunch or other factors)...
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
April 3, 2013 at 7:44 am
Check Database integrity task runs CheckDB on the selected database. Functionally, it's the same as running CheckDB on that database from a custom job (reporting aside)
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
April 3, 2013 at 5:50 am
The data file is the one that ran out of space, not the log, so looking at log reuse is a bit of a waste of time. Instead, you need...
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
April 3, 2013 at 5:37 am
rollercoaster43 (4/3/2013)
Can you check the recovery model that is set and the result of the below query for your temp db select name,log_reuse_wait,log_reuse_wait_desc from sys.databases where name like 'tempdb' ??
Why...
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
April 3, 2013 at 5:37 am
DuncEduardo (4/3/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
April 3, 2013 at 5:23 am
For future reference:
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
April 3, 2013 at 1:37 am
The third party inserted it into your database and you don't have rights to run updates?
In this case, defensive programming = slow queries. If your users are happy to have...
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
April 2, 2013 at 3:30 pm
Why do you have data with leading spaces in the tables? Why have you not cleaned that data and removed the leading spaces? (and yes, you will need an LTRIM...
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
April 2, 2013 at 3:26 pm
kk1173 (4/2/2013)
Is it not better to have the following instead? It will bring in those values that have trailing and leading spaces also.
So you have dirty data and would rather...
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
April 2, 2013 at 3:08 pm
To remove spaces on the left or right of a string.
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
April 2, 2013 at 2:24 pm
Error 5 is permission denied. The account SQL is running under does not have full control to the folder or file in question.
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
April 2, 2013 at 2:23 pm
Viewing 15 posts - 13,606 through 13,620 (of 49,552 total)