Viewing 15 posts - 39,301 through 39,315 (of 49,552 total)
There's no way to downgrade database versions. A DB on SQL 2008 has a slightly different file structure and different system tables, and that's regardless of the compatibility level. SQL...
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
May 5, 2009 at 6:03 am
tobe_ha (5/5/2009)
Is there a History where I can see, what recovery models were set in the past?
It doesn't appear to be stored in the default trace (I just checked), so,...
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
May 5, 2009 at 5:59 am
Paul White (5/5/2009)
It might be that the SSIS package is running the whole thing in a transaction; however the SELECT...INTO will be bulk-logged if the database is set to Simple,...
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
May 5, 2009 at 5:53 am
Can you explain more? model.bak would be a backup file and it is in no way necessary for SQL's operation. the Model database, consisting od Model.mdf and Model.ldf are.
Does 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
May 5, 2009 at 4:03 am
Probably SSIS is running all of them in a transaction, which means that the log cannot truncate until the commit occurs. If that's the case, you won't be able to...
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
May 5, 2009 at 4:02 am
michael vessey (5/5/2009)
from experience RPC starting is required if the Command timeout occurs and the command is killed before any results (even the 1st row) is returned.
Shouldn't be. I did...
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
May 5, 2009 at 2:47 am
These might help you a bit. They're purely on indexing, not rewriting bad code.
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
May 5, 2009 at 2:39 am
I found that replacing the < and > with < and > removes the closing tags, but that's not fun to do.
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
May 5, 2009 at 1:55 am
Jeff Moden (5/4/2009)
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
May 5, 2009 at 1:42 am
Marios Philippopoulos (5/4/2009)
It's odd, this proc is taking 3 input params, I just don't see why this portion is not listed.
Not sure either. I just hauled a plan out of...
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
May 4, 2009 at 3:29 pm
Use Perfmon (Windows performance monitor). Under SQL Server:Buffer Manager there's a counter for Lazy writes/sec
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
May 4, 2009 at 3:18 pm
Don't suppose you can post the exec plan for the proc you're struggling with?
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
May 4, 2009 at 2:37 pm
Then that query had no parameters. Either it had variables or constants that weren't auto parameterised.
Those lines should be right at the bottom of the xml, just a couple lines...
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
May 4, 2009 at 2:29 pm
It's in the XML. Right at the bottom you'll find two lines like this.
<ParameterList>
<ColumnReference Column="@PageNo" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" />
<ColumnReference Column="@ForumID" ParameterCompiledValue="(8)" ParameterRuntimeValue="(8)" />
</ParameterList>
If you're looking at...
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
May 4, 2009 at 2:18 pm
zach_john (5/4/2009)
Forgot about joining up to partitions, thanks for the quick response, didn't i read you live in So Africa? has to be late there.
Yup, down in SA. Post...
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
May 4, 2009 at 2:16 pm
Viewing 15 posts - 39,301 through 39,315 (of 49,552 total)