Try out Grant Fritchey's free ebook on execution plans: https://www.simple-talk.com/books/sql-books/sql-server-execution-plans,-second-edition,-by-grant-fritchey/

Bsthomas0327 (4/11/2014)

---

We have 2 SQL 2012 servers. Our application has 2 databases. We are creating an AlwaysOn cluster. Is it good to create 2 AlwaysOn clusters to...

There are umpteen things that need to be done/set to properly configure SQL Server. Same for your server itself, and the SAN and san connectivity too. There are...

koln (4/9/2014)

---

To be a bit more clear, here is what Im asking;

Principal Server A has a database named db1

Principal Server B has a database named db 2

Mirror Server C is...

With no WHERE clause and lots of data AND 2 sorts, your only hope for this from a query execution perspective that I can think of is to a) set...

nick.mcdermaid (4/7/2014)

---

From my perspective, the filtered index means you do not need to change your source code to get a performance increase. i.e. if you have a dozen bits of...

Nice one Dwain! It seems that your refactor has woken up a slice of the optimizer to the fact that it doesn't actually have to "rip through" NULL entries...

1) It could be caused by HEAP table activity where you insert and delete rows over and over or update rows to be larger than they currently are.

2) By...

ApexSQL has an auditing/compliance product. Idera may have one too. But I think anything that is INSIDE SQL Server will probably be bypassable in some way by SA...

Wow - that's a lot of stuff!! May take a while to get it deciphered.

As for generating the data, I recommend SSMS Tools Pack from Mladen Pradjic...

http://msdn.microsoft.com/en-us/library/dd172122(v=vs.100).aspx

I don't see it listed here though, just the outer joins: http://technet.microsoft.com/en-us/library/bb510662.aspx

or here (although there are some rather surprising things supposedly being REMOVED in SQL 2014 and future editions!):...

1) The older style joins are not just worse syntactically. They have been deprecated and at some point in the future will NOT WORK any longer. Some of...

sql_novice_2007 (4/2/2014)

---

I see the following select statement in one of the stored procedures on the sql server instance.

SELECT name,id FROM tflag..grades

I am thinking that the statement selects data from...

Luis Cazares (4/1/2014)

---

I would unpivot[/url] the source table, join it with the metadata table, use cross tabs[/url] to obtain the desired result and run away from that horrible design.

That destination...

Perry is spot-on as usual. You will need to pick a "master" sql instance and then script out the logins with the SID and then replace all existing instances...