Viewing 15 posts - 14,041 through 14,055 (of 49,552 total)
To be honest, that table looks like it needs normalising, looks like 3, maybe more tables in one.
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
March 5, 2013 at 1:39 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
March 5, 2013 at 12:32 am
One or both of the sales order tables has a computed column defined in it. That's your compute scalar.
If you just select salesorderID and salesOrderDetailID you shouldn't see that...
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
March 5, 2013 at 12:31 am
Willem Tilstra-440027 (3/4/2013)
Gail Shaw mentioned in another forum question while I was researching this, that 'Replication does not in any way use the Subscriber's log file'.
Whoever said that should be...
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
March 4, 2013 at 5:53 pm
dembones79 (3/4/2013)
GilaMonster (3/4/2013)
So 'keep the keys for a unique index to the columns that need to be enforced unique' is a 'rigid overly-simplistic rule'?
Bear in mind that this is for...
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
March 4, 2013 at 5:46 pm
ScottPletcher (3/4/2013)
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
March 4, 2013 at 5:35 pm
ScottPletcher (3/4/2013)
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
March 4, 2013 at 4:57 pm
ScottPletcher (3/4/2013)
GilaMonster (3/4/2013)
dembones79 (3/4/2013)
Should the region and district columns be included in the unique clustered index of the view?
Bear in mind that a clustered index implicitly includes all 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
March 4, 2013 at 4:16 pm
qur7 (3/4/2013)
I am in a bind here and hoping someone will be able to help me out in this regard.
There is a database in our environment that is using...
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
March 4, 2013 at 3:45 pm
dembones79 (3/4/2013)
Should the region and district columns be included in the unique clustered index of the view?
Bear in mind that a clustered index implicitly includes all the columns 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
March 4, 2013 at 3:38 pm
ScottPletcher (3/4/2013)
The ALTER command to try to change an existing file to a smaller size gives you an error on SQL 2005.
That's when you're trying to reduce the initial size,...
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
March 4, 2013 at 3:36 pm
ScottPletcher (3/4/2013)
GilaMonster (2/28/2013)
stehoban (2/27/2013)
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
March 4, 2013 at 10:10 am
sqldba_newbie (3/4/2013)
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
March 4, 2013 at 9:24 am
You've got no transactions in there, so every single statement is running in auto-commit, commit on completion. There's no 'uncommit' without explicit transactions.
What are you trying to do here?
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
March 4, 2013 at 6:37 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
As for the costs, they are estimates and are dependent on statistics and heuristics, they can be very far...
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
March 4, 2013 at 5:52 am
Viewing 15 posts - 14,041 through 14,055 (of 49,552 total)