I know I'm splitting hairs but there are quite some differences between the different methods of producing inline tally or number sequences. The method DesNorton posted is quite efficient but...

Deadline

Good job!!

😎

Sean Lange (9/30/2016)

---

Eirikur Eiriksson (9/29/2016)

---

As Sean rightly mentioned, there are many ways of parsing and extracting values from an XML. Many of those methods are similar in syntax but may...

My take on this would be to separate the current status and the status history as those are two different things and should not be combined in a model entity.

😎

Current...

As Sean rightly mentioned, there are many ways of parsing and extracting values from an XML. Many of those methods are similar in syntax but may vary hugely in performance....

BLOB_EATER (9/29/2016)

---

so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

You are very welcome Rodney!

😎

rodjkidd (9/28/2016)

---

Many thanks.

Let me know if you want the 13 person one uploaded. As the additional extras are all over the place in that one! But going to take a...

Hi Thomas,

from what I can see at the first glance is that the First_Value function does not have a POC (Partition, Order, Covering) index to work on and the cardinality...

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#LookUp') IS NOT NULL DROP TABLE #LookUp;

CREATE TABLE #LookUp (Loc int, EmpID int)

INSERT INTO #LookUp

VALUES (1,123)

,(1,222)

...

You are very welcome Mike and thanks for the feedback.

😎

Hi Rodney,

this should be easy to fix, will have a look later today

😎

If you open the job and select Steps on the left, what is the Type of the job step? It should be "Operating System (CmdExec).

😎

Mike Scalise (9/27/2016)

---

Hi,

Has anyone run the latest Ola Hallengren's IndexOptimize script (September 25)?

I'm not sure why but when I run the job, I get the error "Executed as user: NT...