That depends on number of rows that belong to an invoice. If they have few lines, most chances are that I'll have only the unique index. On the...

you can use the function datediff to calculate the difference between 2 points of time.

Adi

I think that you can deny an insert from a dbo. The dbo can change the permissions so he'll be able to use the insert statement but as long...

You can use the profiler to show that. Another option is to use the extended events. You can see the amount of pages that the query read with...

Can you be a bit more specific and give details about the errors?

Adi

Thom A (12/6/2016)

---

Further Question, why ARE they a member of the db_datareader and db_datawriter roles when they are a member of db_owner role? These roles serve no purpose, as db_owner...

Check if he is an administrator of the whole server. Anyone that is authenticated as an administrator, can not be limited at all.

Adi

I don't think that this behavior is because of the top clause. I think that this is just the way that SQL Server works with variables. When...

declare @Primary_Summary table (Med_Rec_Nbr int)

insert into @Primary_Summary (Med_Rec_Nbr) VALUES (1234567),(123456),(12345),(2345678)

SELECT RIGHT(CONCAT('0000000',Med_Rec_Nbr),7)

FROM @Primary_Summary

where LEN(Med_Rec_Nbr) < 7

Adi

Nothing will be effected. TDE was designed to protect your data if someone get a hold on your database's files or backup files. TDE encrypts only the data...

As this feature's name implies it is completely transparent to the clients, so no code would have to be rewritten. The things that you do have to be aware...

Removing a user that owns an object from a database is impossible, so if you want to remove this user from the database, you'll have to change the schema's owner...

User defined functions have some limitations. One of the limitations is that you can't use dynamic SQL in a user defined function, so unfortunately you won't be able to...

Since you didn't explain much about the results that you need, I also guessed what you want to get. If my guess was not good (and there is a...

I read it as BR and have to modify it to B, but this is something that the original poster can modify. I also think that there is a...