Jeff Moden (12/4/2009)

---

Grant Fritchey (12/4/2009)

---

Great primer Barry. It covers the basics of what's needed very well. Since so many questions come through on the board around the concept of "How...

GSquared (12/4/2009)

---

I found out late yesterday that the CEO, the President, the Chairman, and the CFO, of the company I work for, all resigned late Wednesday, without prior notice, and...

GilaMonster (12/4/2009)

---

Depends what the key is. If...

Nope. Sorry. Stupid statement. It tracks errors & objects created/deleted, that sort of thing.

Great primer Barry. It covers the basics of what's needed very well. Since so many questions come through on the board around the concept of "How do I get started...

GilaMonster (12/4/2009)

---

sashikanta.mishra (12/3/2009)

---

I agree that all the column should not be part of index column. So i only choose the column to be indexed and rest columns are in INCLUDE...

Manie Verster (12/3/2009)

---

By security policy I mean:

Per example

Password expiry period = 3 months

Password lock out = 3 failures

Strong password required = true

Now I know that by default SQL Server uses...

I generally prefer several smaller tools that do jobs really well. Take for example type ahead. It's built into SSMS, but it stinks. Get a copy of Red Gate SQL...

So you've got identical execution plans on identical databases on the same server, but one is running slow and the other is not?

Contention is the first thing that comes to...

You've effectively written two different queries, and yeah, each query needs a different execution plan. Recompile is probably your best option.

fminns-1058143 (12/3/2009)

---

Hi Grant

But who/what is using up the other connection?

The reason I want single user mode is because I want to try testing a restore of the master database which...

fminns-1058143 (12/3/2009)

---

I have tried everything.

No matter what I do, and no matter how many other processes I kill off I still always get the same message telling me that only...

I'm with Lynn here, spend $50 on the Developer's edition of SQL Server. If you're trying to invest in your future... $50, please.

Next, I'd recommend reading Brad McGehee's book, "How...

And what happens when database A or B become terribly problematic due to size, contention, number of users, what have, and you need to move them to another server? Linked...

If restarting the service doesn't clear the trace, then you've got something running within SQLAgent or as a startup script that refires it. If SQL Server is shut down, so...