Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Sep
24
awarded  Autobiographer
Jun
15
comment Recursive CTE performance
My understanding from a talk I went to at SQL Bits by Ramesh Meyypappan recursive CTEs always run serially. The speaker demonstrates a method by which you build your own recursion by inserting in to a temporary table using a while loop. Done like this the queries are able to scale to parallel execution where possible. He also highlights that cardinality estimates tend to be off when using recursive CTEs. The talk can be found sqlbits.com/Sessions/Event7/…, the example is within the first 5-10mins.
May
30
comment Query to find optimal filegroups for objects
PS The question from programmers is here if you are interested programmers.stackexchange.com/questions/149097/…
May
30
comment Query to find optimal filegroups for objects
Hi Mark, don't worry too much. I asked the question on programmers too but more from the algorithm angle. I got quite a good idea of how to approach it. I think it may be one of the few times to use a cursor. In the end though I have pushed for the arrays to be rebuilt with more spindles and therefore there will only two filegroups and as such it has been easier to do manually. Thanks for your efforts
May
17
comment Query to find optimal filegroups for objects
Thanks for you time and input. Volumes are RAID 10 with 4 spindles. I am aware that the spindle count is quite low too.
May
17
awarded  Editor
May
17
revised Query to find optimal filegroups for objects
added more detail to logic rules
May
17
comment SQL Server: filegroup for system tables only?
Wouldn't I be right in thinking that if the system objects are only in the primary filegroup should you need to in future you will be able to do the following. Create x additional files in another filegroup. Proportionally fill these files by migrating your data from your your existing data file?
May
16
awarded  Student
May
16
asked Query to find optimal filegroups for objects
May
2
comment Clarify - Need to add Multiple foreign key constraints
In theory yes another position could be added to this table. But unless you provide a method to do so in the application end users will not be able to. Could still be edited direct in the database, but what can't.
Nov
18
awarded  Teacher
Nov
18
answered Creating a view on a non-existing view
Nov
17
awarded  Supporter