Ed Wagner (1/19/2016)

---

Eric M Russell (1/18/2016)

---

Ed Wagner (1/18/2016)

---

One thing to consider if you're going to run SQL Server locally is memory. SQL Server loves memory. Whatever you give...

Jacob Wilkins (1/18/2016)

---

Yup, that's what my proposed solution does. Just have to account for the fact that the bitwise operator is...

Why not use the T-SQL bitwise operators?

https://msdn.microsoft.com/en-us/library/ms174965.aspx

For example:

3 & 0 = 0

3 & 1 = 1

3 & 2 = 2

3 & 4 = 0

123456 & 1 = 0

123456 & 2...

Ed Wagner (1/18/2016)

---

Eric M Russell (1/18/2016)

---

Another scenario that can cause page splits is when users are updating columns contained in the table's clustered key, and this applies not only to...

Ed Wagner (1/18/2016)

---

One thing to consider if you're going to run SQL Server locally is memory. SQL Server loves memory. Whatever you give it, it will happily use...

If you have the Micrsoft developer stack installed on your PC at work, and you're essentially wanting to experiment and learn from comfort of home after hours, then consider using...

Is it page splits that you're seeing?

It's understandable that key columns or date/time stamps, like OrderStatusID or InventoryDate, are updated as part of an entity's normal lifecycle, but these type...

Gary Varga (1/15/2016)

---

Eric M Russell (1/14/2016)

---

Gary Varga (1/14/2016)

---

Jeff Moden (1/14/2016)

---

Insurance companies are already doing this although I don't know if they actually track geo-location but it seems logical they would...

Steve, what is this curious attachment at the bottom of your Security Convenience article; a PostScript file?

As a sysadmin, I create a login:

CREATE LOGIN BobSmith WITH PASSWORD = 'mypassword'

I now am in the Sales database and execute this:

CREATE USER BobSmith

What happens?

Considering that a...

If you want to INSERT rows for new ZipCodes and UPDATE columns for existing ZipCodes, then that's what's called an "UPSERT" or "Type 1 Change". You can implement this using...

Like what it says: "Cannot insert duplicate key in object 'dbo.Postal'."

Perhaps you're attempting to insert a row that already exists in the target table.

Gary Varga (1/14/2016)

---

Jeff Moden (1/14/2016)

---

Insurance companies are already doing this although I don't know if they actually track geo-location but it seems logical they would because they can. They...

Jeff Moden (1/14/2016)

---

...

Same goes for cell phones so far as locating the phone and you if you're carrying it with you (and who wouldn't?).

...

Heh... and people are (pun intended) bugged...

The economic argument in favor of Buy is stronger if the product has robust and simply features for customization and scripting.