I've created the following update query which joins to another table:

-- update new_ae.new_aeoffice with proper office name

update new_ae

set new_aeoffice = ado.OfficeName

from new_ae

join #AE_Domain_Office ado on new_ae.New_DomainName = ado.DomainName

The...

"If you have no indexes, that's a table scan and SQL will apply both filters as it scans the table."

Gail - Correct me if I'm wrong but if I filter...

Thanks for the feedback. In my first query please ignore the "top 10" in my select statement to keep my question more focused. Thanks for being detail oriented...

Hi Lowell I used sp_UGLYSEARCH that you posted in the previous thread. The query ran for a few hours yesterday afternoon and was still running when I left work. When...

I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat easier...

Based on my initial scan of the threads the threads don't appear to reference any official MS standards.

MS provides an automated tool named FXCop to check a .NET/C# codebase for...

@SS - Like I mentioned - I'm not referring to linked servers at all but only linked databases that reside on the same server. I wanted to get some...

What if the core datamodel is for read-only purposes? Applications could each have their own database and connect to the core database for read-only purposes.

If all the databases reside on...

bump

Thanks for your feedback Luis. I think that should give me the information I need 🙂

bump

Can you think of any DBA tasks that a db_owner would not be allowed to perform on a database?

Basically, I have 1 server with 2 production databases. The org...

saurabh.kaushik (11/13/2011)

---

Well I came across such a challenge a couple of months back. The scenario was - our organization was building an HR application which needed to have workflows that...

Jeff Moden (11/4/2011)

---

sqlguy-736318 (11/3/2011)

---

I'm in the process of creating a database restore script for my staging server.

Whenever I restore a database on my staging server I always restore a bak...

Nevermind - I just noticed that the backup UI has a "Script" button which lets...