Site sponsored by:
The gold standard of SQL Server performance monitoring & diagnostics
Home
Articles
Forums
FAQ's
Tips
Quiz
Blogs
Software
Books
About Us
RSS Feeds
Sign in
|
Join
count(*)
(RSS)
Browse by Tags
application role
central
constraint
count(1)
crosstab query
cursor
data insertion
database
distributed
dts
ms sql server
NULL
performance
services
sql server
sql server performance
sql server security
turining rows into column
A tricky question and i do not how can I resolve in joins please help me
TABLE A BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001 NULL NULL 10005899 en-US 1561001 NULL NULL 10005899 nl-NL 1561001 35023080 NULL 10005899 en-US 1561001 35023080 35023080 10005899 en-US TABLE B BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001...
Posted to
General Developer Questions
(Forum)
by
pkarunit
on 06-10-2008
Re: Difference between count(*) and count(1)
Both will be same in terms of performance, as the execution is to retrieve information from the table. Article in this regard. BTW n the real terms how big is the table and are you getting any performance issues?
Posted to
General Developer Questions
(Forum)
by
satya
on 08-01-2007
Page 1 of 1 (2 items)
Is your SQL application secure? Audit for SQL injection, XSS and other web attacks with Acunetix Web Vulnerability Scanner.
AJAX Tutorials and More
Derivatives One : Online Financial Derivatives Calculator
<script language='javascript1.1' src="http://jventures.com/advertising/a2.aspx?ZoneID=1&Task=Get&Browser=NETSCAPE4&NoCache=True&PageID=38628&SiteID=1"></script> <noscript><a href="http://jventures.com/advertising/a2.aspx?ZoneID=1&Task=Click&Mode=HTML&SiteID=1&PageID=38628" target="_blank"> <img src="http://jventures.com/advertising/a.aspx?ZoneID=1&Task=Get&Mode=HTML&SiteID=1&PageID=38628" width="728" height="90" border="0" alt=""></a> </noscript>
© 2000 - 2007 vDerivatives Limited All Rights Reserved.