Thanks John & Gail. I would be very thankful if you could provide any reference doc which can describe this part. Seems like I've got a thing to clear up...

So the full backup doesnot impact the chain of t-logs ?

Nice question Steve. 🙂

TGIF... Cheers... :satisfied:

Junglee_George (10/10/2013)

---

from

local_MaterialsItems MI

LEFT JOIN local_MaterialsItemsHazards MH

ON (MH.materialItemIncId = MI.materialItemIncId AND MH.materialItemHazardSqlId = MI.materialItemSqlId AND MH.isDeleted=0x0)

LEFT JOIN local_Hazards H

ON (H.hazardIncId = MH.hazardIncId AND H.hazardSqlId = MH.hazardSqlId AND...

Grant Fritchey (10/4/2013)

---

Jeff Atherton (10/4/2013)

---

Haven't heard of this one before and all I can find is...

Could you send the complete query ? Are you updating or inserting data in a table ?

Hippey... As I am into learning phase in SSIS, so happy to get it right. Very good question. 🙂

Pretty simple actually.

Distinct column1 will give the distinct values within the column1

Distinct * will give the distinct rows within the table.

Say this is the content of table1

Column1 ...

Nice and easy question. Thanks. 🙂

Mark Cooper-1068662 (10/8/2013)

---

I have run this in all versions of SQL Server from 2000 to 2008 R2 and get the same answer - 10 '*'s.

select STR('8E10') -- returns '**********'

select len(STR('8E10'))...

Jeff Moden (10/5/2013)

---

I believe you meant "competent" rather than "complacent" in the following...

They're expert beginners, and since they can accomplish the things they're asked to do at their jobs, they...

Here is the URL showing data type conversion chart:

http://technet.microsoft.com/en-us/library/ms191530.aspx

Mike & Kupy, that was done to make it little tricky (and thats why the last option was there). Though it seems many got it correct so most of them...

Steve Jones - SSC Editor (10/7/2013)

---

simon.crick (10/7/2013)

---

Cadavre (10/7/2013)

---

simon.crick (10/7/2013)

---

I will probably get shot down again for saying this, but I believe people should stick to core technology and basic tecnhiques...

Great question. I usually use sp_addrolemember for permissioning purpose but because of this question had to dig and got the following link:

http://technet.microsoft.com/en-us/library/ms187750.aspx

it clearly mentions that this feature will be removed...