Quick suggestion based on the fact that Zero date is Monday 1900-01-01.

😎

SELECT

CONVERT(

...

Luis Cazares (3/21/2016)

---

The major difference from the 2 runs seems to be the physical reads from a table. When it's slow, it's reading 12-13 thousand pages from disk. When it's...

drew.allen (3/21/2016)

---

Eirikur Eiriksson (3/21/2016)

---

kuopaz (3/21/2016)

---

I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases...

scott clemons (3/21/2016)

---

First time posting this type of info. Wasn't sure if I should provide the computer, domain or user specific info, so I replaced with <#####>. Hope...

Here is an alternative[/url]

😎

kuopaz (3/21/2016)

---

I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases (not this example),...

scott clemons (3/20/2016)

---

I have read countless articles on the internet about fixing this error, but nothing works. Sorry, if there is an easy answer, but I can't figure it...

Simple suggestion

😎

DECLARE

@cols AS NVARCHAR(MAX),

@selcols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX),

@startdate datetime,

...

mburbea (3/20/2016)

---

This was run with default settings on the box. So probably 5 for the cost and whatever the default is on dop.

I decided to try to change the number...

Once had a DBA that every one liked, he was busy taking care of all the users and in general highly regarded. After a little while I started to notice...

What a mess!

😎

Hope this guy has a recent updated version of his CV.

Quick questions:

1. What is the disk setup on the server (Volumes,Sizes etc.)?

2. What are the recovery models on the...

If I understand the requirements correctly you want all the instances with blank Phone where the same FirstName,LastName,BranchFk exists with a non-blank phone.

😎

Quick suggestion

USE tempdb;

SET NOCOUNT ON;

GO

CREATE TABLE

#Employee

(

EmployeePk INT,

FirstName...

Not sure how I got tempdb mixed up in this, guess I just blame my bad eyesight reading off the mobile:-)

Did...

Thanks for this, now just one more thing, do you have some sample data as an insert statement for the two tables, safes me having to speculate what could/should be...