ananda.murugesan (8/6/2013)

---

Before total execution time was 00:00:28 seconds, after that it was just took 00:00:02 seconds after created NC index..But second time actual exex.plan was showing 72% of total...

Before you decide to go and intentionally write code that's vulnerable to SQL injection, maybe take a read through these.

http://www.computerworld.com/s/article/9241084/SQL_flaws_remain_an_Achilles_heel_for_IT_security_groups

http://www.troyhunt.com/2013/07/everything-you-wanted-to-know-about-sql.html

Susan Cooper's The Dark is Rising series.

Over Sea and Under Stone

The Dark is Rising

Greenwitch

The Grey King

Silver on the Tree

The six tokens in the form of a cross in a circle...

Maybe.

http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

However if you're working on a DR plan, a...

Yes

Yes

Mirroring copies the log records across and ALL data modifications in a database are logged.

Eric M Russell (8/6/2013)

---

Update locks are generally at page level, unless the UPDATE operation is covering a large number of pages and SQL Server escalates intent exclustive (IX) lock to...

Sarah Wagner (8/6/2013)

---

You are using the Distinct in a sub-select in the where clause using IN, why use distinct at all? Whether you have 1 record that matches or...

Is that 79% cost of the DISTINCT a problem?

High performance is asynchronous, not synchronous. If you run mirroring in async then you must accept the possibility of data loss.

And no, that's not how you do a manual failover....

Brandie Tarvin (8/6/2013)

---

Lately, I've gotten a lot of connection requests from people just trying to bump up their counts (who I don't know from boo), so I've gotten a...

If the principal fails and you have unsent log then it doesn't matter whether you go for automatic or manual failover, failing over manually won't magically make the unsent log...

An expression ('abc' + @z) is not permitted as a parameter to a procedure. Parameter has to be variable (or another parameter) or a constant

The only advice I can offer on that is don't do it. Find another solution. SOAP requests from SQL are not recommended, the OLE automation are fraught with problems and...

You don't need that much page file. SQL shouldn't be using the page file at all and all that's needed with crash dumps, except in rare circumstances are kernel or...

The redo queue is the queue of log records on the mirror, log records that have already been hardened on the principal and mirror and only need to be redone...