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...

Using the contents of the query plan cache, you can also parse the JOIN conditions of SELECT statement, to infer foreign key relationships. That would compensate for situations where foreign...

The SQL Server DBA should consider letting the application developers use Cassandra or MongoDB for their object persistence storage. Keep it local on the application server and let the application...

Used to be that most database records were manually entered into a terminal by employees who were paid by the hour. Today, the proliferation of the web, applications, devices, and...