I'm not sure there's an easy way. I saw someone say if a productID wasn't entered, it's MSDN, but I think that's changed.

Ultimately, I'm not sure it matters. The licensing...

I'd listen to Hanshi.

The definition of insanity is doing the same thing over and over, but expecting something different.

Why shrink the space if you need it again soon? You don't...

Pedro's method would be the only thing. The script itself needs to be parsed in order to generate a plan, and it can't do it if the columns don't exist....

Vedran Kesegic (9/4/2013)

---

I got the mail starting with "Congratulations!". Passing the lab exam from the first attempt and receiving so wanted MCM certificate makes me very happy! I will celebrate,...

In practice, a restore typically has .bak, .trn., and .dif files. The attach usually has .mdf, .ldf, and .ndf files.

I understood you, but probably didn't explain myself well.

I think that you can install SS2K as an instance on a machine with SS2K8 already as a default or named instance....

Read Gail's article and then set up log backups to manage your recovery. you can shrink the log file if you need to recover the space, but if you...

You are welcome, but the important thing to note is this is an ongoing, evolutionary process. It's not a set it and forget it, or a single session.

Go slow, change...

GilaMonster (9/3/2013)

---

I don't.

I have about 8 years experience designing, developing and tuning SQL Server....

Yet. It can't be cheated yet....

GilaMonster (9/2/2013)

---

SQLRNNR (9/2/2013)

---

Koen Verbeeck (9/1/2013)

---

GilaMonster (8/31/2013)

---

Just ....

Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1,...

It looks like you have issues on your H: drive. SQL Server is just reporting issues from the OS when it tries to access the file, just as you'd receive...

Grant Fritchey (9/3/2013)

---

You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or...

Yes, but you need a union query. Each FTS query is single language. Use two with the LCID for each, joined by a UNION.

There isn't a "everything run faster" set of changes.

When you adjust indexes, you potentially adjust execution plans as well. This means some queries may run faster, some may not, choosing...