On a totally unrelated note, what do you think of this person?

He's coming to Italy and my UserGroup is thinking about organising an event.

Would you pay to attend a...

julian.fletcher (1/9/2013)

---

The client's database has a nightly maintenance job to reindex.

Really, I was just wondering if there was a well known reason why

If A Or B

{Something}

might be massively slow while

If...

You can. Whether it's a good idea or not, only you can tell that.

Partitioning is something that must be tested thoroughly before implementing.

If the partitioning key is not used...

It might be a policy enforced by your system administrators. It's not in the VPN, but in the RDP settings.

I'm under the same restrictions here.

I work around it using ledelog[/url],...

ChrisM@Work (12/21/2012)

---

I thought that big scary yellow thing in the sky was the zombie apocalypse until...

Sorry Steve, I *HAD* to steal your picture and post it on Twitter.

Merry Christmas everybody if the Mayans are wrong.

Otherwise... oh, who cares? 😀

Koen Verbeeck (11/28/2012)

---

At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I...

You can read it as "DBAs group added to local administrators group".

Logical drives wouldn't help performance nor recoverability, just manageability.

Two separate drives for tempdb data and log is overkill IMHO.

See here a for a nice SQLServer installation checklist: http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/03/22/sql-server-installation-checklist.aspx

Hope this helps

Gianluca

I see no connection between "no management studio installed" and "user needs sysadmin rights".

Am I missing something?

Management studio is available in the Express flavor for the first issue.

For the second...

Jeff Moden (11/18/2012)

---

[snip]

So, without writting code on the thread 😀 and given that we must occasionally...

Grant the SQLAgentReaderRole and set the job owner to a different user.

That way, users can only see the jobs, but cannot start/stop/modify them.

Very nice article! Very informative and well written.

Would use that trick in production? Probably not, but that doesn't subtract value from a nice piece of work.

I vote Beer.

No, wait... SQL Beer!

SQLRNNR (10/18/2012)

---

Stefan Krzywicki (10/18/2012)

---

Gianluca Sartori (10/18/2012)

---

Stefan Krzywicki (10/17/2012)

---

dwain.c (10/17/2012)

---

Stefan Krzywicki (10/17/2012)

---

I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I...