Gary Varga (9/26/2016) ... he believed that the contractor wouldn't provide any form of hand over if he was leaving as he refused to document what he was doing when...

mike.jones 60369 (9/23/2016)

---

Hi I am new to this application and my question I believe is rather basic, so forgive me.

I have two tables A and B below and I wish...

neophilius (9/21/2016)

---

I have a query that delivers me a list of employeeIDs. For each EmployeeID I want to run a stored procedure and print its output. So the SP has...

You don't need IIS for native only, but you do with SharePoint configured for SSRS as Shareportint requires it.

What error messages are you seeing?

logs can be found at

%ProgramFiles%\Microsoft SQL...

Not technically an answer, but this article from one of the regular posters here covers the thinking behind the question you're asking well

http://sqlinthewild.co.za/index.php/2016/09/13/what-is-a-sargable-predicate/

there are also other related articles to help...

You're actually quite close, you just need to put your query into a derived table and filter on the ranked column

SELECT

VisitID, InstanceID, ValueInfo

FROM

(

SELECT

VisitID, InstanceID, ValueInfo,

Row_Number() OVER(PARTITION BY VisitID ORDER...

While obviously not expecting you to...

GilaMonster (9/7/2016)

---

If you've analysed and tested, and have confirmed through careful testing and consideration of alternatives, that the hint is the best way to solve the specific problem you have...

^^^ Exactly This!

If you have scores of servers and hundreds of systems, manually repointing them all in the event of a datacentre, or even host - loss, for a number...

SQLAssAS (9/6/2016)

---

I am currently setting up an AG, 2 node in the primary data center with synchronous commit and a third node in the secondary data center with asynchronous commit.

All...

Hi, yes, see exactly what you're saying. Most of the time (although not always by any means) the box is actually pretty quiet - CPU low and our WhoIsActive...

Hi Gail,

both the same - here's an example, immediately before and after PLE being squashed

RunTimeCounter_Name ...

I don't know Gail - I'll add that to the PLE collection and get back.

thanks

Thanks for that. It was actually set to the correct locale, so instead I decided to stop being a f***wit and used the correct (datetime) datatype.

<sigh>

Thanks for your help

Very briefly:

Full -

allows you to restore to a point in time - say 4 seconds past 5 this afternoon when someone accidentally truncated the...