Since this is THE THREAD, a change was made to allow cut and paste to/from SSMS and the forums.

http://www.sqlservercentral.com/Forums/Topic749309-83-1.aspx

I await the issues.

Well I've seen them compared to prison cells, and often with less space in the cubes!

Get a book, read the items from Microsoft on which you'll be tested, go through Books Online for those topics, and practice.

It's hard work and effort that will get you...

Thanks, and I agree. Doing this stuff on camera is hard. I'm amazed at how often I make mistakes.

The issue with encryption is that many times the DBA can still get to the keys, or add themselves to the group that can access the keys for encryption/decryption.

Or they...

What you'd want to do is extract out the month and date using substring. Then you can cast this as a number, and sort appropriately.

So

Where cast( substring( field, 1,...

There's no way to do this other than logging the data. It doesn't magically exist anywhere in the server.

A server side trace, which you can template out from Profiler, will...

Your format is wrong.

select a

from tableA

inner join Table B

on a.x = b.x

WHERE a.y = 1

The joins come before the WHERE.

Also, you can use SETUSER to run this for any login, and then REVERT back to your user. Add a script around that and you can easily get all permissions.

It's going to be a huge mess in any case. The dump of permissions for objects for users is a huge amount of data, and it's impossible to read. It's...

On the log files not shrinking, there is a script on this site (Forcibly shrink[/url]) that cycles through transactions and clears the virual files, moving them to the beginning and...

First, the sp_ issue is a problem, and you could avoid it. spXXX is fine.

Many people choose a standard for procedures (usp, USP_, sp), but I rarely see tables prefixed....

Michael,

First you need to clarify 32bit v 64bit as so many systems are moving to 64. Second, I think you are correct for 32 bit. Once you go with AWE...

I thought this was great, and I learned something when this came through.

I don't know how this is related to ACID, but it's a nice little loophole for logging things....

Never satisfied, are we Hugo?

I have changed it to "B is returned. A simple change that would be better: ..."