Mattie,

You create a unique index when you set a PK. Setting the PK is the equivalent, but it does help you pass along information to others and even yourself about...

First, forget about Access. SQL Server is a server, like a mail server (Exchange) and so there isn't "a user" or a default.

It doesn't matter if SQL is on the...

I'd send over an ANSI guide to the students, get them to change. You can take some of their examples, explain how you change their queries to a more standard...

I'm not sure there is. However if you (or someone else) wants to write an article to explain it, let me know!

Not I unless you count volumes of family pictures.

I do know a few IT folks, programmers, that are into photography.

I'm sure there's something, though in any scheme you might not have every tape. How many days do you keep before you reuse.

I think we used to keep the most...

Some very interesting comments and thanks for sharing.

Those of you with no time, I completely understand and definitely enjoy the rest of your life first. Writing about SQL, especially when...

Scott,

On the trace tab, second one with the events, click "Show all columns" (lower right), then when you click the button for column filters Database will be there.

select CloseReason

, Count(*) as CRCount

, TotalCount as sum(CRcount)

, percent as (SUM(CRCount)/sum(TotalCRCount))

from tblOpportunities t

...

I'm a single instance fan, and then using security to manage the rights between the applications. You get better hardware use.

However, you share tempdb (limited resource) and you also can...

There's no way for us to guess this. You can search for database sizing estimates, but take a guess. Disk space is cheap, so set up something and go from...

http://www.gizmodo.com.au/2008/05/sonys_xel1_oled_lasts_half_as_long_as_you_expect_says_study-2.html

I'm sure this will get a lot better, but OLEDs have a ways to go.

1. DO NOT SHRINK - causes fragmentation. Set the sizes you need and do not use the shrink except for one offs if something grows crazily.

2. Not sure, but it...

Apologies, stupid administrator (me) :(, misconfigured the send.

Do you have it open? Or does the autosys have permissions to open the file?