Viewing 15 posts - 1,726 through 1,740 (of 2,463 total)
middletree (5/4/2010)
there's no record of any loginname/password, including sa. And yes, we did try sa and blank.
then how do you login now ?
May 5, 2010 at 8:01 am
reefshark (5/4/2010)
Are CTE's usually created by the DBA or the Developer?
it has nothing to do with developer or DBA , the person whoi knows/wants to work on TSQL ,...
May 5, 2010 at 7:59 am
Oscar Janson (5/5/2010)
I've read the article linked to your topmost signaturelink, and I've come up with the following. Hope it becomes clear enough. 🙂
/* Generating and populating tables. */...
May 5, 2010 at 7:50 am
this is more or less business logic failure/misunderstanding by you ? . i would suggest break your SP( select statement ) in chunks then verify one by one.if you...
May 5, 2010 at 7:48 am
GregoryF (5/5/2010)
Bhuvnesh (5/5/2010)
May 5, 2010 at 7:25 am
Answer to your question has been given by Schadenfreude-Mei. if you are not satisfied with answer elaborate your question/requirement.
May 5, 2010 at 6:56 am
Where is exec plan for IN query ? i didnt find it
May 5, 2010 at 6:14 am
Best practice is create/transfer login to new server and then map users(should exist in particular database)there
May 5, 2010 at 6:01 am
MY BAD, i need a strong coffee.:-)
I treated (misread ) "non clus " index as "clus" and viceversa :-D. thats why i asked this foolish question
May 5, 2010 at 4:51 am
David Portas (5/4/2010)
SQLJocky (5/4/2010)
It's true that a nonclustered index always contains the cluster key columns
Here you are talking about "when the clustered index is not a unique index" ....
May 5, 2010 at 4:23 am
hbujar (5/5/2010)
I create every month automatically partitions for tables, i have a question is it possible to delete the partitions physically from the disc which that partition is empty,...
May 5, 2010 at 4:09 am
george sibbald (5/4/2010)
I think we agree david that the important point is that the non-clustered index be covering.
thats true.above of all optimizer always choose that index which cost it...
May 5, 2010 at 4:01 am
David Portas (5/4/2010)
SQLJocky (5/4/2010)
It's true that a nonclustered index always contains the cluster key columns
something new to me . Are you sure for it ?
May 5, 2010 at 3:59 am
moorthy.jy (5/5/2010)
master..xp_readerrorlog will list out the error logs.
but wont show the error log location/path .
May 5, 2010 at 3:32 am
thanks a ton to all guys , i will keep ur thought and work acc to them while working in it , thanks
May 4, 2010 at 8:29 am
Viewing 15 posts - 1,726 through 1,740 (of 2,463 total)