Viewing 15 posts - 13,111 through 13,125 (of 49,552 total)
If you have different plans then either:
* The queries are not logically equivalent
* The different form resulted in the optimiser searching a different area of the plan space and finding...
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 19, 2013 at 9:54 am
Please note: 4 year old thread. Also backup/restore is not an option for moving some objects from one filegroup to another.
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 19, 2013 at 8:45 am
And the definition of the trigger (which is the prime suspect for the update failing)?
As for why the selects fail when explicitly converted, probably because there's non-numeric values in 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 19, 2013 at 8:28 am
Please note: 3 year old thread
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 19, 2013 at 8:24 am
Completely irrelevant. Order that you specify the joins is not the order they are executed in, unless you're forcing join order.
Check that the queries are logically equivalent.
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 19, 2013 at 3:16 am
Please post the definition of the table and check for triggers.
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 19, 2013 at 3:14 am
Why not use identity insert and use the identity values from the other database? You did make sure they can't overlap when you brought the live server back up (via...
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 18, 2013 at 12:40 pm
Your problem is that DataCompare is picking the wrong order for syncing the tables. Solution, rather than comparing and syncing the entire database, do it a table at a time.
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 18, 2013 at 11:08 am
Sync table by 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
May 18, 2013 at 9:30 am
Something like Red Gate's SQL Data Compare would work well here. Otherwise you're going to be writing comparison and insert/update queries for quite some time.
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 18, 2013 at 7:36 am
GilaMonster (5/16/2013)
Will need to see the exec plan to advise any further.
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 18, 2013 at 7:32 am
Can you post the last few lines of the CheckDB output please. Or the entire output when run WITH NO_INFOMSGS?
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 17, 2013 at 2:06 pm
jasona.work (5/17/2013)
Lynn Pettis (5/17/2013)
Lynn Pettis (5/17/2013)
After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 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
May 17, 2013 at 12:01 pm
If you don't see it, then there's something in sp_whoisactive that's filtering out those locks. Probably it's only showing sessions that are running, not ones that are sleeping and holding...
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 17, 2013 at 11:57 am
Grant Fritchey (5/17/2013)
GilaMonster (5/17/2013)
"I know the drawbacks of nolock, in our case it cannot be avoided"Hmm...
And we have a really good reason to not run backups, to have the database...
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 17, 2013 at 11:51 am
Viewing 15 posts - 13,111 through 13,125 (of 49,552 total)