patricklambin (2/27/2015)

---

Hi Steve ,

You are right in your editorial but I am feeling that I have to report some points that it is possible you forgot ( coming from my...

Wow, it doesn't seem like it's...

A touch more fantasy, but Hicks series on aliens that are similar to humans: http://www.amazon.com/gp/product/B005S0WJ7Y/ref=kinw_myk_ro_title

Also the Doom Star series by Heppner, an evolution of humans http://www.amazon.com/Star-Soldier-Doom-1-ebook/dp/B003SNJVH4/ref=sr_1_1?s=digital-text&ie=UTF8&qid=1424880277&sr=1-1&keywords=heppner+doom+star

You are welcome. Glad it makes sense.

If you have more questions, feel free to ask.

Note that for the most part, I agree with you. All of the SSC systems here...

Jeff Moden (2/24/2015)

---

Thanks folks. Has anyone any particular pleasantries that have occurred from Dev to Stage to Prod with RedGate Compare?

@Lynn...

Are you saying that you had to make some...

The script I referenced does this. You need a RESTORE HEADERONLY on each file to find the latest.

Please read through the script to see how it works.

Indexing certainly adds load to inserts/updates/deletes. The index, as well as the data, must be touched.

Thanks

Double up on the quotes.

declare @sql varchar(1000)

select @sql = 'INSERT dbo.mytest SELECT 'insert sales select ''test'' '

Also, watch your spaces. You are missing a few.

This was a 2003 question

Hany Helmy (2/23/2015)

---

In the daily newsletter email I recieved, the answer for that question was: "You can use certificates, asymmetric keys, or passwords" while the answer on the website is:...

mar.ko (2/24/2015)

---

re: "GUIDs give you a large space of possibilities."

I understand, but I would never use an Autonumber/Sequence as a key reference to a product or client, etc.

Instead, I would...

http://www.sqlservercentral.com/articles/Build+List/71065/

You might read this to ensure you understand: http://www.sqlservercentral.com/articles/Administration/64582/

There are a few:

http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=asap_bc?ie=UTF8

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=asap_bc?ie=UTF8

http://www.amazon.com/Microsoft-High-Performance-Functions-Developer-Reference/dp/0735658366