Alan.B (9/24/2015)

---

What's good about this solution is (when you have perm tables) you can highlight the query inside the CTE to see what you are going to delete. This makes...

Assuming that the network connection might be slowing this, do you have...

Assuming that your string date is in 'yyyymmdd' format then you could do:

SELECTTestDate,

ISDATE(TestDate) AS [IsDate?],

CASE WHEN TestDate LIKE '[12][0-9][0-9][0-9][01][0-9][0-3][0-9]'

THEN 'RegExOK'...

robinwilson (9/23/2015)

---

Heaps

However it would see that more "bloat" comes from having heaps on tables due to the way data is paged and left after...

I only know some specifics about log shipping based on our in-house usage, better someone who understands it thoroughly gives you some advice 🙂

Are local tables involved too? Is so may need to update statistics after migration before query plans will be optimal.

GilaMonster (9/23/2015)

---

Functions in the select execute once per row, and they have an overhead. Data-accessing scalar functions in the select are essentially a hidden cursor inside a select and they...

Thanks Gail, that was what was in my mind .. but not what I typed.

erichansen1836 (9/23/2015)

---

I do not allow concurrent conflicting batch updates to the MS-Jet database which attempt to STEP ON each other's changes. Batch operations only occur SERVER side when end-users...

patrickmcginnis59 10839 (9/23/2015)

---

The classroom solution is one user adding stock arrivals, which increase the Quantity on Hand, and the other user doing Sales Order Processing which decrease the Quantity on...

randyetheridge (9/23/2015)

---

not sure I am technical enough to explain it correctly, but as it was explained to me, the ISNULL answer takes on the attributes of the original field. ...

That seems surprisingly small - or perhaps the Log Backups are at very frequent, i.e. short, intervals?

Or almost no data changing in the...

I drafted this hours ago, got interrupted with something else, apologies if it now overlaps other posts.

robinwilson (9/23/2015)

---

Please can I ask if anyone knows the answers to these questions:

Primary Key...

I think a programmer, from XYZ Vendor, visiting our client might take a look at our...

I would like to properly understand...