Grant Fritchey (9/26/2016)

---

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid...

Another thing to consider when you're benchmarking for CPU would be the comparative performance of the CPU. If you're on something like E5-2640 v3 CPU's you may be getting...

netmikem (9/28/2016)

---

I am quite sure I came across a blog or some article in the last six months mentioning that SQL Server 2014 Developer Edition is now free.

I can't seem...

For the benefit of any future unwary victims.

The Audit_DDL_Events table is one that is used by DDL triggers for tracking changes, and presumably is only set up when you create...

It's an option for the version 11 and 13 ODBC driver

Via the wizard 10 seconds, but it would more likely be...

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...