I read the first 2 options, then decided to google it as I have no idea, no previous experience on this, found nothing useful, then went back, read the rest...

Good to now that, agree with most of you here, it`s a good question.

Eazy mozo 🙂

Like some here said, I never used spatial data types before, so definitly learnt somthing new today, thanx for the question.

TomThomson (9/19/2014)

---

Good question.

I was feeling too depressed by my nation's decision to stay under England's domination :crying: to do any research this morning, so I took a guess and got...

Good question, thanx, note that BlockSize option typically affects performance only when writing to tape devices not to disk.

I should have went with my 1st guess :angry: but then decided to try all options one by one on my testing server:

1. No query was paused, all working fine.

2....

Still not convinced it`s important to us...

+ 1

serg-52 (9/16/2014)

---

Amstrong numbers. OK, Will try to remember it. 🙂

Minor code improvement. SUBSTRING() : If start_expression is greater than the number of characters in the value expression, a zero-length expression...

Eazy mozo 🙂

So u should consider using cut/paste instead 😀

True, that`s why it was...

+1

Koen Verbeeck (9/11/2014)

---

Vimal Lohani (9/11/2014)

---

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.

this...