Viewing 15 posts - 38,956 through 38,970 (of 49,552 total)
Why are you applying an update lock on the count? An update lock is usually used to indicate that the data selected will shortly be updated.
What are you trying 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
May 22, 2009 at 3:32 am
With that form of query, indexes are not going to help much. That particular query form performs badly, pretty much no matter what.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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 22, 2009 at 3:31 am
As far as I know, the hidden snapshots that CheckDB uses work on every version of SQL right down to express.
Are there any errors in the error log?
If you run...
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 22, 2009 at 3:28 am
dlozi (5/22/2009)
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 22, 2009 at 3:24 am
TheSQLGuru (5/21/2009)
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 22, 2009 at 3:14 am
Not using Toad. As I mentioned already in the thread, I was using the web interface that Oracle Express has.
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 22, 2009 at 3:12 am
You don't need to find and kill deadlocks. SQL has a built-in deadlock detector which will automatically find deadlocks and kill one of the processes involved.
http://sqlinthewild.co.za/index.php/2008/07/08/what-is-a-deadlock/
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 22, 2009 at 3:07 am
Jan Van der Eecken (5/22/2009)
I meant the one who calls himself the Guru, signs with MVP, but doesn't disclose his name, which I find a little bit odd.
He is an...
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 22, 2009 at 3:07 am
Lynn Pettis (5/21/2009)
Paul White (5/21/2009)
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 22, 2009 at 3:04 am
If you still need help (not quite sure if the problem's fixed or not), please post table definitions, sample data and expected results. See the article I referenced earlier 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
May 22, 2009 at 3:02 am
SQL will never release memory. Once it's allocated it will only release if the OS signals that the entire system is short of memory.
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 22, 2009 at 2:57 am
Can you post table definitions (as create table statements) and some sample data (as insert statements)?
Read this to see the best way to post this. http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 21, 2009 at 9:12 am
Try using LEFT OUTER JOIN rather than INNER JOIN. Inner join only return rows where there is a match. Left outer join returns all the rows from the table on...
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 21, 2009 at 9:04 am
Lynn Pettis (5/21/2009)
Are we talking about our window washer friend here?
No. It's someone who answers questions, not asks. (no one here, obviously)
Steve: Apologies in advance if this results...
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 21, 2009 at 8:58 am
Florian Reischl (5/21/2009)
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 21, 2009 at 8:58 am
Viewing 15 posts - 38,956 through 38,970 (of 49,552 total)