This might do it:

SELECT j.NAME

, s.next_run_time

FROM dbo.sysjobschedules s

CROSS APPLY (

SELECT datepart(YEAR, getdate()) * 10000 + datepart(MONTH, getdate()) *...

synonyms are also a nice tool, and you can avoid renames

you would need to use dynamic sql, since you can't pass a database name in a variable.

How many indexes? How are you measuring the space used? What's the fragmentation like?

vamsi.341 (11/2/2015)

---

i have tried passing this variable using a stored procedure, as it didn't work i have manually passed the variable once i declared the variable.

Either way it's not...

How are you trying to pass the values to the query?

Looking at your WHERE clause:

WHERE (ORG_Manager_Q.CompanyShortName IN (@ReportParam)) AND

((ORG_Manager_Q.ContractCountIndicator IN (@ContractsCountParam))AND

(ORG_Manager_Q.AssignmentCountIndicator IN (@AssignmentsCountParam)))

This will select rows where CompanyShortName, ContractCountIndicator and AssignmentCountIndicator equal to @ReportParam, @ContractsCountParam and @AssignmentsCountParam respectively.

Is that...

Resender (11/2/2015)

---

Ok, quick question, a 3th party is taking over all off the database and server support of our internal teams, in their zealousness they've also removed a lot of...

nicolas_johnson 52979 (11/2/2015)

---

Another approach is to use views to alternate source tables by updating the view at the end of the load procedure to point at the last updated table....

A Select query with NOLOCK could return uncommitted results. That can include rows about to be deleted or updated. If those rows include FKs e.g. pointing to tables...

Great question, Hugo! Do you have any measurements on just how much READUNCOMMITTED (I don't like the synonym NOLOCK since it is an oxymoron -- that is, schema locks...

Neither is an "expression" - those are data types. The fact that other languages allow for you to use types and expressions interchangeably is frankly a defect or sloppiness on...

Yup -- a quick update from my phone! Anyway why not add a check constraint to these columns CHECK...

Why not just use a check constraint or do you?

Luis Cazares (10/29/2015)

---

g.britton (10/29/2015)

---

SQL uses three-value logic. So anything = NULL evaluates to False and anything <> NULL also evaluates to FALSE. Also, NULL = NULL is FALSE...