Viewing 15 posts - 32,266 through 32,280 (of 49,552 total)
Gianluca Sartori (6/23/2010)
It could definitely be partially used pages.Try rebuilding / reorganizing the clustered index and all nonclustered indexes.
Agreed.
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
June 23, 2010 at 4:07 am
SQL doesn't know what timeouts are (other than lock timeouts). Timeouts are a client error, the client issues a request to SQL and, if it has not had a response...
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
June 23, 2010 at 2:13 am
Spam. Reported. No replies please.
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
June 23, 2010 at 2:11 am
Could be pages partially used, could be index space.
What does sp_spaceused return for that table?
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
June 23, 2010 at 2:10 am
You want to generate the values dynamically based on what? Current date?
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
June 22, 2010 at 11:33 pm
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us#tab3
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
June 22, 2010 at 11:25 pm
Not exactly union, but you can insert the results of a proc into a table. Insert both result sets into a temp table, then query 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
June 22, 2010 at 1:07 pm
Can someone who knows their way around SQL memory have a look at this? http://www.sqlservercentral.com/Forums/Topic941169-360-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
June 22, 2010 at 1:06 pm
Oldman@ds9 (6/22/2010)
The SQL Servere used about 150MB in maximum ...
What did you use to determine 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
June 22, 2010 at 12:36 pm
yessen (6/22/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
June 22, 2010 at 12:20 pm
That's not a valid option, and it's not a valid DBCC command either.
CheckDB checks are by default online, there's nothing you need to add to ensure that. They can slow...
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
June 22, 2010 at 12:12 pm
yessen (6/22/2010)
can you elaborate on full or diff backup?
full database backup or differential database backup. Check books online if you want more details
I guess the point in time restoration allows...
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
June 22, 2010 at 12:09 pm
jcrawf02 (6/22/2010)
Grant Fritchey (6/22/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
June 22, 2010 at 10:26 am
Looks like either the log (in the backup) is damaged or you have hard drive problems. Can you try and restore on another server and see if it works.
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
June 22, 2010 at 10:23 am
SQL does not automatically assign min memory. That's only the figure that, once allocated, it will not drop below.
It is not a good idea to set min and max memory...
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
June 22, 2010 at 10:22 am
Viewing 15 posts - 32,266 through 32,280 (of 49,552 total)