+1

isuckatsql (4/1/2014)

---

I have a simple id, name table with six million records, that i converted to a "memory optimized' table.

It now runs six times slower with a 'select count(*)' or...

Thank you

Too bad. That lowers the chance that I’ll find time for it. But I think I’ll ask them.

But I stay skeptical. I have read similar about McAfees Security Suite.....

To my knowledge and experience you can run a

BEGIN DISTRIBUTED TRANSACTION

very well.

I have not heard of that one. Maybe, if you can provide a link to a Trial, I could check it out.

But frankly I have not had a convincing experience...

The picture is in fact a bit more than "just speed".

You have too also look at the code and the workload that you are running.

Code:

the more complex computation and logic,...

Maybe you want to check BOL

http://technet.microsoft.com/en-us/library/ms180015%28v=sql.105%29.aspx

I think Patrick noted it. It's set to an empty string if not specified during install. If I remember the install...

Well

as you can see, your user is member of the Windows Group "Domain\SHR_Dev"

and thereby member of the db_datareader database role inside this database

But you said that at the same time...

what do the following DMVs return?

select * from sys.user_token

select * from sys.login_token

use impersonation, so you can copy the result

->

execute as login = 'XYZ'

When You impersonate that user and tun SELECT USER_NAME(), what do you get?

Next: what does sys.fn_mypermissions return?

it's not possible to NOT "install" sa. The only diofference is, whether sa is actually enabled - which he said he did manually - and whether the password is known

Let's...

Thanks for jumping in with a code-sample

I would like...

I'll have to pass on that one

I am not a .Net developer.

All that SQL Server needs is the binary representation.

But what exact code you need in order to do that,...

How about you just return data with the SQL Server datatype [var]binary(n)?

This you can easily be displayed in Reporting Services reports.

Would this work for you?