AFAIK there's no any accurate way to do that.

I guess IF every caller used a different login or sql user, you could tell from that, but overall I think that's...

First, I assume you've all met all the oodles of restrictions for an indexed view; you might want to verify that using Books Online "CREATE INDEX", "Remarks", "Indexed Views" as...

declare @search_pattern_should_be varchar(100)

set @search_pattern_should_be = '%[[][[][%] SQL Server [%]]]%'

--example

select case when @string like '%[[][[][%] SQL Server [%]]]%'

then'Matched' else 'No...

I think EXISTS would be the clearest indication that you just want to know if a matching row exists, not retrieve data from that row. For example:

SELECT

...

You should also consider specifying "SORT_IN_TEMPDB = ON" on the creation. That usually saves a little space in the db, and, perhaps more importantly, often makes the final table...

DBA_Dom (1/23/2013)

---

You could also have the last step in the job add a message in a queue for the service broker to pick up and execute the next job.

Or what...

Yes: which specific entry for "Job A" does one check in sysjobhistory?

The last one? What if...

Btw, I suggest using the clear datepart name, not the obscure abbreviations -- it can help you/others later, and avoid having to use Books Online just to lookup the &#^)@...

That's trickier than it sounds, because of the way SQL Server updates the sysjob* tables, and because you don't want to have to hardcode job schedules into the code.

Instead of...

Don't know full details, but the usual outline for such queries is shown below.

SELECT

DATEADD(MONTH, DATEDIFF(MONTH, 0, tp.trc_startdate), 0) AS start_month,

SUM(tp.??) AS active_units

FROM...

I think what's arrogant is for a developer to assume that they have the professional skills of another a DA/DBA job when they've never done. Not sure why everyone...

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

Sean Lange (1/22/2013)

---

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a...

Sean Lange (1/22/2013)

---

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying....

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying. The first 2 groups have...

You need to do something like that in the WHERE clause:

select

col1

,CAST(col2 AS datetime) as col2test

from #DateTest

where isdate(col2) = 1