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

The main difference between those two queries is that the first (#1) uses a Stream Aggregation Operator to sum the values while the second (#2) uses an Arithmetic Addition and...

Can you post the DDL for the AdeccoView table and some sample data as an insert statement, makes answering the question much easier.

😎

mburbea (3/19/2016)

---

I installed a copy of 2016 RC1 on my laptop. This is a fresh copy and this laptop has never had sql installed on it before. Specs are as...

Tempdb is always in simple recovery so backup is futile, find out what is filling the log or even better, add the new file and see if what ever operation...

Temporarily add a file...

Quick suggestions: don't use table variables for any kind of serious testing and include covering indices to eliminate sorts and key lookups.

😎

IF OBJECT_ID(N'dbo.OrderDetails') IS NOT NULL DROP TABLE dbo.OrderDetails;

CREATE TABLE...

mburbea (3/18/2016)

---

Yeah, I just ran it sorry I lied this box is running sql server 2014 developer edition but the compatibility mode is set to 2012 to match my production...