Viewing 15 posts - 39,781 through 39,795 (of 49,571 total)
ChandaMAMA (4/14/2009)
Its...
April 14, 2009 at 4:54 am
Did you read those articles?
If, in your example, you have an index on FName and a second index on LName, then your query may be able to use one of...
April 14, 2009 at 3:31 am
It can, providing that the query doesn't return too many rows.
Have a read through these, they're not beginner-level articles, but they may be of use.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
April 14, 2009 at 2:22 am
grngarlapati (4/14/2009)
like
select ID,(exec Proc ID) as Name from Table
I dont...
April 14, 2009 at 2:09 am
Sorry, I'm not following you. Could you maybe show the procedure and explain a bit more what it currently returns and what you want it to return?
April 14, 2009 at 1:25 am
Delete them
.mdmp file are memory dumps, from when SQL has access violations or other similar errors. If you're getting them currently, call MS's customer support. If they're old and the...
April 14, 2009 at 1:22 am
A certification alone without any experience is unlikely to get you anything than a very junior job, if that. The certs are designed for people who have some experience (a...
April 13, 2009 at 3:26 pm
There's a lot more to consider than performance.
Truncate deletes all the data in the table. Delete can have a where clause allowing conditional deletes.
Truncate does not fire triggers, delete does.
Truncate...
April 13, 2009 at 1:35 pm
sreddy (4/13/2009)
selectuser.userid,
user.name,
count(news.userid)
from user
inner join news on user.userid = news.userid
group by user.userid,
user.name
Why count(userid)?
j1a4l0: What do you want returned for a user that has no news items?
April 13, 2009 at 12:54 pm
April 13, 2009 at 12:48 pm
jcrawf02 (4/13/2009)
April 13, 2009 at 9:04 am
Vijaya Kadiyala (4/13/2009)
These are great articles but i am not able to add any comments 🙁
I can't help you with that. Mail or PM the Simple Talk people (Tony Davis)....
April 13, 2009 at 8:46 am
Please post the table design, index definitions and the estimated execution plan (saved as a .sqlplan file, zipped and attached)
If there query blocked by some other connection?
Is that SELECT *...
April 13, 2009 at 8:35 am
Bob Hovious (4/12/2009)
April 13, 2009 at 7:36 am
There's no upgrade exam from 431 to 432. The upgrade is from the 2005 ITP certs to the 2008 ITP certs.
If you've studied for the 2005 exam, write the 2005...
April 13, 2009 at 7:30 am
Viewing 15 posts - 39,781 through 39,795 (of 49,571 total)