Viewing 15 posts - 27,061 through 27,075 (of 49,552 total)
Did you try? Is there a performance issue?
SQL is capable of retrieving data from far more than three small tables without difficulty.
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 27, 2011 at 7:35 am
Query wait is not a query timeout. SQL Server does not time queries out, the connecting application (in this case query analyser) does.
Query wait is how long an executing...
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 27, 2011 at 3:48 am
Anna, it may be better to stick to one thread on a problem at a time, otherwise you're likely to get conflicting advice if people haven't read the whole story....
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 27, 2011 at 3:41 am
Read through this as well: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/. sunitabeck's solution does not perform well on larger resultsets.
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 27, 2011 at 3:24 am
An index rebuild is a single transaction. In full recovery, you will need log space at least 1.2* the index size to rebuild the index. Either increase the size of...
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 27, 2011 at 3:22 am
alan.berger (3/26/2011)
Awesome. Please let me know when the blog is posted. I'd appreciate a link sent to alanb.dba@gmail.com
Feel free to subscribe to my blog. I haven't even finished...
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 26, 2011 at 12:29 pm
alan.berger (3/26/2011)
I take it by the plural at the end that for n colums connected with the or, there should be at least n indexes.
Yup.
Shameless plug - am busy writing...
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 26, 2011 at 12:18 pm
Jeff Moden (3/26/2011)
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 26, 2011 at 11:27 am
djguana (3/25/2011)
no this is the only bakcup FULL that is performed, the one from the maintenance plan.
Not asking about full backups. Full backups don't break log shipping.
Can you check 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 25, 2011 at 1:57 pm
Steve Jones - SSC Editor (3/25/2011)
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 25, 2011 at 1:56 pm
http://sqlinthewild.co.za/index.php/2009/08/24/stats-blob-corruptions/
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 25, 2011 at 9:59 am
GSquared (3/25/2011)
GilaMonster (3/25/2011)
GSquared (3/25/2011)
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 25, 2011 at 9:23 am
Brandie Tarvin (3/25/2011)
At risk of turning this into a technical discussion again. Aren't bulk insert operations minimally logged? Haven't they been since at least SQL 2000?
In bulk-logged and simple recovery...
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 25, 2011 at 9:05 am
GSquared (3/25/2011)
I'm a DM. Have been since the mid-70s when D&D first came out. I'm essentially infinitely evil. 🙂 Have to be, for the entertainment value.
RBDM!
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 25, 2011 at 8:50 am
That's already as optimal as it will get.
Since the table has 2 columns only, that clustered index scan is returning the minimum amount of information possible to execute this query....
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 25, 2011 at 8:48 am
Viewing 15 posts - 27,061 through 27,075 (of 49,552 total)