Last night at our PASS Chapter user group we had a gentleman that has moved many of his servers to 2014 and he did a great talk on the troubles...

Since your seeks and scans are low , then maybe you don't have the right order when you create the index.

Granted this is only one idea.

[ROI_STAGE], [QC_DATETIME_STARTED], [INVOICE_STATUS_CODE]

Maybe it should...

create table #t1( col int not null);

insert #t1(col) values(1),(1),(2),(3),(3)

select col from #t1

union

select col from #t1

union all

select col from #t1

select col from #t1

union all

select col from #t1

union

select col from #t1

select col...

Great videos.

The third one is exactly what I needed.

Thank you

Ron,

I missed it because ,

query 4

although inserts a record from the second insert statement,

the first insert statement fails, I guess rendering that query failed,even though something has been...

Well,

I have done it again managed to make a bonehead mistake.:hehe:

Connection Manager, I believe when I first started created the package I had trouble with the name of the connection,...

Dan,

To run the job from ssms this is the way I started it, it starts successfully, I know this because in my ssis package, I have a couple of execute...

Yep found out the reason,

I needed to use the WITH LOG after my RAISEERROR function call. Severity 16.

All severities under 19 are not automatically written to the error log.

Nice...

The reason I chose 3 and 4 , was because of ambiguity.

It would seem to me that since you have two employeeIDs , since you are joining them.

SELECT a.EmployeeID FROM...

Not my intention.

Sorry, but the exams are frustrating, that is why they are exams. 😎

I am here to learn.

I get the same message when I try to create my non-clustered huge index.

I don't know but I think the exam is wrong!

Cool, I will do that.

Weird thing is the column name is lastName as an nvarchar(max).

So I could just assume the lastname will never be 2gb long, but it could possibly...

I had a great experience at the New York City SQL Saturday last winter.

Everything was well organized and the speakers did a great job.

I just wish there were more SQLSaturdays...

I think your connection needs to be on that specific Database , so use the USE AdventureWorksDW and then execute your select statement.

When I go back and forth in the...

So, an informal SQL User Group meeting at the East Greenbush Library , at 6pm August 15.

Anyone is welcome.