Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??

You could do a simple split of the string based on a "-", if needed, then use ISDATE() on one/both entries. That would tell you if SQL recognized it...

Yikes, how many possible "status"es are there??

Sean Lange (5/7/2015)

---

nick.latocha (5/7/2015)

---

This was my prototype:

create table #items (itemID varchar(10), statusID int)

create table #statuses (statusName varchar(50), statusID int)

insert into #items values ('Item 1',1|2|8)

insert into #items values ('Item 2',1|4)

select *...

You can use bigint, doubling the bits from an int ;-).

SQL does sort of track modification counts (for indexes, not heaps), but the data is cumulative and does necessarily persist. Look at view:

sys.dm_db_index_operational_stats

However, while an index is...

Don't get overly focused on having a primary key per se. Some tables require them, some don't. Data integrity is vital, but a primary key doesn't guarantee it...

GG_BI_GG (5/8/2015)

---

I get some error on the alias columns;

OUTER APPLY (

SELECT

...

The table design is probably less than ideal/perfect.

However, the query can still be improved, hopefully dramatically. Keep in mind that I don't have sample data to test it ahead...

...

and routine_name not like '%B_%')

TomThomson (5/4/2015)

---

Sergiy (5/1/2015)

---

It only seems simple for someone who never had to deal with real calling systems.

5 developers for almost...

What is the total table size? If the whole table is 20M rows, you're probably better off breaking replication, doing the delete, and then taking a new snapshot to...

I would think SQL would also need a schema stability lock on the table, to make sure the structure doesn't change while it is being read.

If you use "SELECT ......

WhiteLotus (4/28/2015)

---

Hi All,

I have some questions :

1.Is it OK to shrink Master, model ? the transaction log for those databases are full .

2.Is it OK to set the Recovery...

You should have no problem changing the logical names, except maybe for some scripted restores that have a MOVE clause using the logical name.