Viewing 15 posts - 18,151 through 18,165 (of 19,564 total)
jferrel-1093506 (1/14/2010)
Ahhh yes.. A well tuned database does give you some free time, Tom....
Good point - the very reason many of us are able to contribute to the SSC community...
January 14, 2010 at 10:06 am
Lynn Pettis (1/14/2010)
CirquedeSQLeil (1/14/2010)
January 14, 2010 at 9:44 am
Steve Jones - Editor (1/14/2010)
January 14, 2010 at 9:39 am
Lynn Pettis (1/14/2010)
Hmm, Impressed a lurker we did.
Yes indeed. Surprised am I not though that she was impressed by the good people here. Surprised I am that she...
January 14, 2010 at 9:29 am
Not being certain that I have the same FTI and catalog as yours, I was able to gain substantial improvement just by adding a Non-Clustered index to the currentdateout column....
January 14, 2010 at 9:27 am
Lynn Pettis (1/14/2010)
Steve Jones - Editor (1/14/2010)
Valerie Jones-467993 (1/14/2010)
January 14, 2010 at 9:14 am
Steve Jones - Editor (1/14/2010)
sjones-143898 (1/14/2010)
January 14, 2010 at 9:11 am
tina.muter (1/14/2010)
I tend not to post, I'm normally just a read, absorb and learn along the way. However I thought a round of applause was worth giving for...
January 14, 2010 at 9:08 am
Alvin Ramard (1/14/2010)
Steve Jones - Editor (1/14/2010)
January 14, 2010 at 9:05 am
mahesh.vsp (1/14/2010)
Am looking for answer for below two questions
1. How the logins got automatically mapped? How sid(s) got Mapped? Normally, we use auto_fix/update_one as parameters to sp_change_users_login.
2....
January 14, 2010 at 8:39 am
And in another it is evening.
Funny though
January 14, 2010 at 7:59 am
Shivrudra (1/14/2010)
please help on below
it is possible to create clustered index on col which does not have defined primary key ?
and
it is possible to create clustered index on col...
January 14, 2010 at 12:26 am
Thanks for the QOD. This was one where I was sure I knew the answer, but still needed to verify it online.
January 14, 2010 at 12:23 am
mahesh.vsp (1/12/2010)
Changing the database owner to sa solved the "dbo" user problemUSE database
EXEC sp_changedbowner 'sa'
GO
Do you still need answers to your questions from the original post, or did you resolve...
January 14, 2010 at 12:15 am
Viewing 15 posts - 18,151 through 18,165 (of 19,564 total)