Jeff Moden (8/19/2015)

---

Jacob Wilkins (8/19/2015)

---

I prefer to avoid all that silliness and set DBs offline with rollback immediate prior to restoring on top of them. I'm quite confident no one...

EricHansen,

What you're proposing is edgy, and perhaps you're earnestly advocating this use of MS Jet database, because that's the database and set of API you're most familiar with. However, it...

There are 3rd party applications that can read SQL Server backups, so the file format must be published in public domain. It may not contain all the data necessary to...

Careful, when the servers finally do come back online, hopefully the database team won't be slumped face down on their desks snoozing. Or...

If you're looking for distinct members in one that don't exist in the other, or possibly members that exist between the two, then consider the EXCEPT and INTERSECT operations.

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

-- selects...

Are you using distributed queries, that is a select statement that joins between the local and remote server using four part naming convention?

Or are you using pass-through queries, that is...

SQL Server "Dynamic Data Masking" is a perfect example of an IT vendor re-inventing the wheel and branding it, sort of like "Meta Data Services", "Always On Clustering", or "In-Memory...

Your English compiles, but it's schizophrenic nonsense. Are you trying to sell of something here?

As a side note, it appears that SQL Server does take at least some measures to respect the intent of stored procedure compiled using the "with encryption" option, by blocking...

Regarding the Why of all this; if you are an ISV, and you don't want the business logic of the stored procedures to be in clear text, and the method...

Matt Miller (#4) (9/23/2015)

---

Maxer (9/23/2015)

---

Eric M Russell (9/23/2015)

---

Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is...

AER (9/22/2015)

---

Hi Lowell,

I'm a DBA who administer all the Company databases. By 'intellectual property' I meant the scripts that are written in the databases. The problem is that our Client...

Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is a single transaction, and splitting up a...

For Heap tables, wasted page space (ie: ghost records) resulting from deletes and updates is not reclaimed, so that's one consideration. Also for Heap tables the file number, page number,...

xsevensinzx (9/23/2015)

---

The last 3 companies I've talked to who are using the Microsoft stack for their applications have told me they are strongly considering NoSQL as an option. While they...