No, that won't be a cause.

There's no memory 'assigned' to the OS. 8GB is what SQL is leaving for the OS and any other app running on that server. That's rather a high figure for...

Primary purpose of an index is to reduce the number of rows in consideration for a query as early as possible. Which reduces row count, a filter or a join?

SELECT

OfficerID,

ShiftStart,

ShiftEnd,

CrimeTotal

FROM

Officer o

CROSS APPLY (SELECT COUNT(*) AS CrimeTotal FROM Crime c WHERE CrimeDate BETWEEN o.ShiftStart AND o.ShiftEnd) c

May well perform better, though would need testing. It's essentially the same as calling...

The alternative to core-based licensing is CALs (and it's limited to a certain number of cores iirc), do you have CALs for all the clients that access sharepoint (each and...

busraker (9/26/2013)

---

Good = take for instance:

Say you have a table of salespeople with their hire dates (SalesPerson):

<snip>

How many orders did they have in the first 100 days? If you...

It works very badly most of the time because of some limitations of the optimiser. It'll usually result in multiple scans of one or both tables in the join.

Passwords should not be stored encrypted, they should be stored hashed. One-way cryptographic hash. There is no need to ever unencrypt a password. Hash whatever is entered and compare, don't...

You're really not making this easy...

For anyone else who wants to have a look, plans are attached, edited to so that they're valid XML (had hidden illegal characters in them)...

Plans in XML format please. The text format is awfully hard to read and is missing about 99% of the information.

Probably stale stats. Update stats on the tables involved with full scan. But need execution plans from both to make anything more than a wild guess.

Think? First thing you need to do is time the steps and see for absolute certain which...

Do the execution plans show any differences? What are the wait types?

http://www.sqldiablo.com/2012/08/01/alwayson-availability-groups-isolation-levels-selects-blocking-writers/

Jeff Moden (9/26/2013)

---

Is that the one where...