Thank you Brian, based on my experiences with SQL Server Kerberos setup for Windows OS, I agree with your comment as well.  We have also done this with MongoDB setup...

Thanks guy, it turn out that there was an expensive order by in the query. It was doing something like this

row_number() over (

order by "column_name")

We found a...

Paul,

How do I find out more about this feature? I don't seem to be able to find this in Book online on the July 2008 version. Googling this...

Steve & Andras,

Thank you very much for you help. I really appreciate it, the information you gave was very helpful. I will download Log Rescue tool to try out...

Steve,

Thanks for that quick response, that is what I told my boss initially too. But, he really want to incorporate a feature where he can offer a way...

I tried select * from ::fn_dblog(null, null) and the result are pretty much the same as dbcc log. What I am trying to do is be able to see...

Hi Andras,

Thank you for the information. This is very helpfull 🙂 I did a simple test using this query

update test set col1 = 'hello again2'

Then I ran...

Brain,

Thank you.

Thanks Greg,

I believe I found out our problem it was some DNS naming issue.  My setup and  your setup work.  The default on everything does work without using domain using...

Brain,

So as long as the server and client are on the same domain and the services is start from local service account.  Then I am using Kerberos authentication?  I did...

Greg,

I tried creating SPN for SQL Server 2005 and startup the database using the domain adminstartor account for the service.  I am still connecting using NTLM not Kerberos?  I think...

Thanks Greg,  I started my SQL Server 2005 using local service account.  So, I don't have to do the SETSPN according to Book on line.  Both the Machine and the...

http://www.guardium.com  

They are really good and SOX complain.