I'm sorry, this post infuriates me.

Integer division was taught within the first three weeks of my first programming class in my first semester of school.

The data is bad.

There are probably records with an empty string. Without knowing what the code is trying to do, that is a guess.

Can you post the...

What is the structure of the view?

That may be where the issue is coming from.

It's probably doing something like this:

DECLARE @s-2 varchar(100) = '12345'

SELECT LEFT(@s, CHARINDEX('x', @s-2)...

Tknapik (6/16/2016)

---

My company is planning to upgrade from SQL Server 2008 R2 to SQL Server 2014. We currently allow clients to create reports with Report Builder 1.0. I would...

Are you stuck with the maintenance plans?

"IndexOptimize" is a procedure from Ola Hallengren. https://ola.hallengren.com/

It appears that you, or someone, has implemented this or part of it.

The main problems...

This type of situation can be difficult to correct. There is no good answer. You are likely going to meet some serious resistance regardless of what plan you...

After the job sets the recovery model, does it call sp_start_job?

If so, that's your problem.

If a job step starts another job using sp_start_job, it will immediately move on...

Why?

SilverBack (6/9/2016)

---

IKm looking for two columns to in SSRS as Parameters.

So @StartD needs to be a column A in a Table and @EndD needs to be Column B in the...

This is a slippery slope. What is the reasoning behind each department wanting their own server?

If they feel that performance would be better, then cost must not...

Again, to reiterate what Lynn is saying, please explain what you are trying to do without providing code.

The syntax you provided makes no sense. We cannot understand...

I am. My environment consists of everything from SQL 2005 to SQL 2014.

It works just fine.

Also, this script is not from Brent Ozar, it's from Ola Hallengren.

https://ola.hallengren.com/

Sounds like quite a few folks on this thread need to submit sessions for the Wanna be a DBA track at the Pittsburgh SQL Saturday.

I already volunteered Ed.

And, Ray,...

Ray K (6/6/2016)

---

Michael L John (6/6/2016)

---

For the Pittsburgh SQL Saturday, one of the most popular tracks is the "So you wanna be a DBA"?

We geared this toward students(we host it...