Viewing 15 posts - 20,191 through 20,205 (of 49,552 total)
paul.knibbs (2/21/2012)
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
February 21, 2012 at 4:33 am
sengeet86 (2/21/2012)
you will definitely get the answer from this blog.http://www.sql-server-performance.com/2007/temp-tables-vs-variables/
That article is wrong in several places, better not to depend on it.
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/
and
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
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
February 21, 2012 at 4:31 am
The quote is correct, but not complete. If it had said "Only the Full model is capable of supporting a point in time restore regardless of operations performed", then 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
February 21, 2012 at 4:26 am
Please explain the logic that produces those results. What exactly defines what the count is? Or is it just a random number?
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
February 21, 2012 at 4:02 am
You need to create the temp table outside of the dynamic query, meaning you need to know or be able to work out the columns beforehand.
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
February 21, 2012 at 3:48 am
Please explain the logic that produces those results. Which columns are part of which table (it's not clear), why is there no 105 in the output? Why are some numbers...
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
February 21, 2012 at 3:46 am
The explanation is not true. It says "Only the Full model is capable of supporting a point in time restore.", however bulk-logged recovery is fully capable of supporting point in...
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
February 21, 2012 at 3:20 am
Do note that this will cause slow application performance at the start of the day, until SQL has repopulated the data and plan caches. Restarting on a regular basis is...
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
February 21, 2012 at 1:52 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/Topic1255006-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
February 21, 2012 at 1:50 am
Without knowing the queries that you are running, absolutely no way to say what should be indexed. Indexes are based on the queries that run against the tables. Just seeing...
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
February 21, 2012 at 1:49 am
So large amount of CPU and time shrinking the data file and fragmenting the indexes followed by another large amount of CPU and time spend rebuilding those indexes and regrowing...
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
February 20, 2012 at 3:47 pm
I would strongly suggest that you consider removing that shrink from the maint plan. There's just about no good reason to have one running on a regular basis.
Also, you may...
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
February 20, 2012 at 3:03 pm
SQLKnowItAll (2/20/2012)
I think Gail and others would recommend SQL 🙂
XML generation and parsing is one area I would actually recommend C# if at all possible. Probably not appropriate in...
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
February 20, 2012 at 2:28 pm
I recommend looking at it bit by bit and working out if it's doing what you want or not.
I haven't got the vaguest clue what that is supposed 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
February 20, 2012 at 2:24 pm
Then there is something seriously wrong with the XML generation code (which piece I can't tell), it's generated a piece of XML over 2GB in size. I think you might...
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
February 20, 2012 at 2:12 pm
Viewing 15 posts - 20,191 through 20,205 (of 49,552 total)