Viewing 15 posts - 9,046 through 9,060 (of 49,552 total)
Please note: year old solved thread.
He did run that exact command, the results are in the third post in this very thread. If you insist on bumping every single corruption-related...
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 15, 2014 at 4:18 am
Please note: 6 year old thread (and last post fairly irrelevant anyway)
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 15, 2014 at 4:01 am
Option with a unique index. This assumes you're OK adding an extra column to the table. It's computed, so no storage, but you can't insert into it or update it.
CREATE...
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 15, 2014 at 3:39 am
Eirikur Eiriksson (5/15/2014)
Sorry about the misunderstanding, the first post was pre industrial strength tanker sized load of espresso:-POne solution is to use a trigger
You need an update trigger as well...
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 15, 2014 at 3:14 am
Have a read through this:
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 15, 2014 at 1:55 am
There's workarounds, they're sometimes a pain
Are there any column(s) that are guaranteed unique in that table? Can you add an identity column?
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 14, 2014 at 11:44 pm
To be honest, rather don't.
What you can do is insert your logging records into a table variable and then insert the contents of the table variable into the permanent logging...
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 14, 2014 at 11:37 pm
Annoyingly hard in SQL 2005, trivial in SQL 2008. 2005 doesn't have filtered indexes
Is the ID column unique? The pk?
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 14, 2014 at 11:31 pm
isuckatsql (5/14/2014)
http://www.statisticsparser.com/Is this good enough?
Be careful with that. In the stats time output, some times are reported twice. The site adds them all up without deduping.
I know, because I used...
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 14, 2014 at 5:27 pm
ScottPletcher (5/14/2014)
Hmm, so we are supposed to go to the trouble and coordination effort of making two completely separate procs, but the second we add another parameter we undo it?
Well...
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 14, 2014 at 2:10 pm
skaggs.andrew (5/14/2014)
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 14, 2014 at 2:04 pm
You can partition an existing table. Not by adding partitions to it, but by rebuilding the clustered index onto a partition scheme. This will take as long as rebuilding 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 14, 2014 at 1:12 pm
ScottPletcher (5/14/2014)
Besides, for two params do I then have 4 separate procs, for 3 parameters I have 8 separate procs, ...?
No, that would be silly. Dynamic SQL works excellently when...
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 14, 2014 at 1:03 pm
I prefer splitting it into two procedures. Gives stable execution plans, doesn't need the extra CPU of recompiling on every execution.
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
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 14, 2014 at 9:33 am
Make sure that your Management Studio is patched to the same level as the server 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
May 14, 2014 at 7:03 am
Viewing 15 posts - 9,046 through 9,060 (of 49,552 total)