Look up Transparent Database Encryption (TDE). The whole point of TDE is that a backup cannot be restored to a server unless that server has the correct certificate. Same with...

Your clustered index has acct_id as the leading column and the query is filtering on acct_id. Hence there will be a clustered index seek. Why would you be expecting a...

What you're currently doing is the best way. Locking records while users type stuff in is a very bad idea. Leads to massive locking and very poor performance.

If a user...

That's never going to perform well. The conversion on the columns will force index scans or table scans.

I strongly recommend that you push for changing the data types to DateTime....

Know and understand. That means seeing what the currently executing SQL is, what the currently executing stored proc is...

No replies to this thread please. Direct replies to the original question at http://www.sqlservercentral.com/Forums/Topic845923-146-1.aspx

Can you rather edit your previous thread and add the images saved as .png please? Or reply to your post inthe previous thread with the images

Having two threads each with...

My blog (see link below post), or the usergroup's website. http://www.sqlusergroup.co.za/

For some reason it doesn't display in firefox, I'm assured that it is being worked on. Jan meeting's not announced...

Transactions held open over multiple screens are usually a bad idea. What happens if the user gets to the comment screen then goes for lunch, leaving the rows locked, and...

The reason you need to is because...

However that is deprecated syntax. The newer syntax is

DROP INDEX <index name> ON <Table Name>

There are only two PASS Chapters in Africa. The one I run in JHB and one up in Senegal (North West Africa)

Henrico Bekker (1/11/2010)

---

I know this is a bit off topic, but somehow relates..

Except for Gail's workshops every now and then, are there any other and more regular events in South...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic845875-150-1.aspx

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

DBCC TRACEON(1222,-1)