ISDATE() is reliable for what it claims to...

Then you've got a second issue that needs addressed! 🙂

Increase the size of tempdb until you have "slack" except...

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

That's not necessarily always true. You might persist a column if its...

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

That's not necessarily always true. You might persist a column if its requires significant...

You can use CASE w/i a GROUP BY.

You can also use CASE w/i a SUM to control which values get aggregated. For example:

SELECT

a, b,

...

HowardW (1/24/2013)

---

SQL* (1/23/2013)

---

Hi All,

While reading about Computed column if found that if we mentioned PERSISTED Key word while creating/altering table then we can create index. But i'm able to create...

IF and only if ABC.COLUMN2 is a (very) large column, and ABC.COLUMN1 is used by itself a lot, it might be worthwhile to keep both indexes.

You should also review sys.dm_db_index_usage_stats...

You need to get rid of the massive GROUP BY; you should be able to do the SUM() in a subquery rather than the main query, but I can't be...

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