Duh! How the hell did I manage to miss that all this time!

Thanks for pointing out the obvious! 🙂

If you've got a lot of stored procedures to update then this might of of use to you. It's certainly made it easier for me in the past! As you'll...

I'm sure but I think I understand what you mean. To clarify, are you asking if there is way to restrict users so that they can only see those databases...

TravisDBA (1/26/2011)

---

That additional memory didn't help: The only thing worse than not being able to make a good recommendation is making one that doesn't improve performance after your boss has...

Hi Ravi,

In terms of port number, there are two elements to this. The lower port numbers (like 1433 for SQL) are assigned to various things, so it's generally recommended not...

In terms of the server software, like Craig and Steve said I think I'd look primarily at Standard Edition. One other option you might want to consider would be 2008...

Since your external IP address is NAT'd, presumably to your local IP address, your SQL Server won't be aware of its existance, and shouldn't need to be. I'd check your...

Stuart Davies (5/12/2010)

---

I wouldn't consider myself a DBA. My boss couldn't of put it better about my role:- "He's in charge of the SQL servers - but that's only cos...

I'm a touch typist, though like Steve said at the beginning of the thread, not a conventional one. After many years I just "know" where the keys are, and hit...

I've seen this as well, last e-mail I received was on the 8th, and after checking yesterday I found that all of them after that point have been stopped by...

You could split that one large table into a separate filegroup, then use filegroup backups to backup the two filegroups separately, which should do what you're looking for.

LutzM (1/6/2011)

Being European, too, I have to disagree. Even the top player cannot decide to be a goalkeeper on one day and a striker on another day just because he's...

Todd Payne (1/6/2011)

To continue with the army analogy, The problem I see most often is that the soilders are forced to obey commands that no longer defeat the enemy, and...

True,...

dfalso (12/10/2010)

---

3. The downside to Simple recovery model involves backup tools that want to read the transaction log and create diffs. Ours, for instance. Since I keep everything Simple, it...