Viewing 15 posts - 25,576 through 25,590 (of 49,552 total)
Ok, let me try...
There's little point in an index with a text column in the index key if all queries that filter on the column filter using LIKE with leading...
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
June 10, 2011 at 10:51 am
Table definitions and index definitions please.
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
June 10, 2011 at 10:47 am
Looks fine to me.
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
June 10, 2011 at 9:55 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 10, 2011 at 9:54 am
Means one of your joins is not restrictive enough. If one table has 2 rows for a value, one table has 3 for a value and you join them 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
June 10, 2011 at 8:32 am
SanDroid (6/10/2011)
i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:
This is MCM level material. Planning 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
June 10, 2011 at 8:25 am
What's spare time?
Comp Sci Master's thesis, read, computer games, aikido. Trying to get back to archery.
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
June 10, 2011 at 7:10 am
calvo (6/10/2011)
I'd like to know if anyone here utilizes this feature of splitting physical CPUs for the purpose of creating soft-NUMA nodes for multiple lazy writer threads.
You get a lazy...
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
June 10, 2011 at 7:00 am
Add the column to the group by.
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
June 10, 2011 at 6:53 am
Brandie Tarvin (6/10/2011)
tarun.him (6/10/2011)
Thanks Randheer;These questions for sql developer are really helpfull
Be careful about depending on this blog as a resource. Even just looking at today's blog post makes me...
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
June 10, 2011 at 6:44 am
What do you want to do with that field?
Do you want the count per name and collection time, or do you want some function of the co0llection time for 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
June 10, 2011 at 6:42 am
Drop all nonclustered indexes first. Other than that there is little you do, creating a clustered index requires recreating the entire table. It will be slow on large tables.
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
June 10, 2011 at 4:24 am
ertemen (6/10/2011)
I am not sure whether the granularity will be lost as you removed a quite bit from group by.
I haven't changed the logic of the query. Just grouping before...
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
June 10, 2011 at 4:23 am
Creating a clustered index recreates the entire table, and rebuild all nonclustered indexes. If creating a cluster ensure that all nonclustered indexes are dropped first.
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
June 10, 2011 at 3:57 am
That's exactly the message you'd get if someone's run a page restore and not completed the operation.
Ask your colleagues, see if any are playing around.
What version and edition are 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
June 10, 2011 at 3:53 am
Viewing 15 posts - 25,576 through 25,590 (of 49,552 total)