Viewing 15 posts - 9,166 through 9,180 (of 49,552 total)
This might stimulate some ideas:
https://www.google.com/?q=publicly+available+data
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
April 30, 2014 at 10:57 am
Users will complain, that's the steady-state of the universe.
Identify the actual cause of the performance problem and work on fixing that. Then the users might stop complaining for a nanosecond...
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
April 30, 2014 at 7:40 am
You might be working under a misconception around shrink.
It's not compression or anything similar. It's not something that has a persistent state. It's not something where you can say '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
April 30, 2014 at 7:40 am
Recovery model has nothing to do with performance. It's about recoverability.
If you need to be able to restore a DB to point-in-time, you need to be able to restore 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
April 30, 2014 at 7:21 am
Please don't start multiple threads for a problem people are already helping you with.
No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1566066-2799-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
April 30, 2014 at 4:58 am
Please don't start multiple new threads for single problem.
No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1566066-2799-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
April 30, 2014 at 4:58 am
Table definitions, index definitions, the query itself and the actual execution plan (not estimated)
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
April 30, 2014 at 1:13 am
Ignore the CX packet and tune the query. Look for waits that the query incurs other than CX packet.
If you want specific help, please post the query, table and index...
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
April 30, 2014 at 12:43 am
Shameless self-promotion: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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
April 29, 2014 at 2:46 pm
SQL_Surfer (4/29/2014)
Can we have blank value in Primary key field?
Yes. It's a value like any other.
Does sql server still order the records based on these keys? (Clustered index)....
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
April 29, 2014 at 2:46 pm
Assuming it's a regular problem and not suddenly today it's slow when it's usually fine...
I'd run a server-side trace and do the analysis that was described in the article you...
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
April 29, 2014 at 2:42 pm
Maybe start with google, there's a huge amount of information available, and if you have specific questions ask?
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
April 29, 2014 at 2:39 pm
Once the statement completes and any triggers on the table have fired and have completed.
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
April 29, 2014 at 2:38 pm
New Born DBA (4/29/2014)
And I also mentioned that we are shrinking the DB every week
Why on earth would you do that?
There's nothing in what you show to go on. 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
April 29, 2014 at 2:26 pm
Nothing to do with a procedure.
Locks taken by data modifications are released when the transaction finishes (commit/rollback). If you aren't using an explicit transaction, that means the locks are released...
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
April 29, 2014 at 2:25 pm
Viewing 15 posts - 9,166 through 9,180 (of 49,552 total)