Viewing 15 posts - 26,236 through 26,250 (of 49,552 total)
Dave Morrison (5/9/2011)
Take a gander at the post, its a count(). What you've said is obviously correct but wasnt the question that was asked 🙂
No, but he wasn't 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 9, 2011 at 11:53 am
MyDoggieJessie (5/9/2011)
Shouldn't SELECT COUNT(1) be the preffered method here over (*)? In larger tables I've noticed drastic performance improvements by choosing only 1 column...
No. The * in count(*) does...
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 9, 2011 at 11:26 am
Ninja's_RGR'us (5/9/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
May 9, 2011 at 9:35 am
Ninja's_RGR'us (5/9/2011)
Ok, so I gather by your complete lack of answer about the FF that I should ignore that option completely even if all the guids are indexes?
No, but 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
May 9, 2011 at 9:07 am
Ninja's_RGR'us (5/9/2011)
That's not what I'm seeing at the moment. PK = GUID = Clustered
Yeah, but PK = clustered index is only by default, not required.
This is how I...
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 9, 2011 at 9:01 am
There's little wrong with a GUID for a primary key, providing the clustered index is somewhere else.
Can you make the pk nonclustered and put the cluster somewhere more suitable?
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 9, 2011 at 8:49 am
http://www.google.com/search?q=issues+"database+mirroring"
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 9, 2011 at 7:43 am
Have you tried google? Should be lots of stuff there.
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 9, 2011 at 7:25 am
forsqlserver (5/9/2011)
May I know what other internals tasks of query optimizer...
There have been books written on that. Literally.
Might be a little too advanced at this point. I'd suggest focus 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 9, 2011 at 7:08 am
That's a SQL 2000 instance, not SQL 2005 (run Select @@version to prove it).
AdventureWorks is a 2005 or 2008 database and can only be attached to those versions. Downgrade...
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 9, 2011 at 7:01 am
Plus table and index definitions.
How many rows does that return?
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 9, 2011 at 6:15 am
There isn't a single recovery point.
What that LSN is, is the point that you would want the log restore to stop at, based on what you would know about...
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 9, 2011 at 6:02 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1105295-1633-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
May 9, 2011 at 4:17 am
mohammed moinudheen (5/9/2011)
in select *, will it be possible that some rows are excluded due to NULL values etc.
Absolutely not. If there's no where clause on the query, select *...
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 9, 2011 at 4:14 am
Count(*) counts all the rows in the result set. Select * returns all columns for the rows in the resultset.
If the count is changing it's probably there are inserts and...
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 9, 2011 at 3:54 am
Viewing 15 posts - 26,236 through 26,250 (of 49,552 total)