Jeff Moden (3/20/2012)

---

Oliiii (3/20/2012)

---

Eugene (B),

Try with INSERT xxx WITH (TABLOCK) ... SELECT.

If your destination table is a heap then it should always be minimally logged (on SQL 2008 and +)...

Eugene (B),

Try with INSERT xxx WITH (TABLOCK) ... SELECT.

If your destination table is a heap then it should always be minimally logged (on SQL 2008 and +) and you should...

You should open a new topic and not hijack a one year old one 🙂

Any .net application can read/write to varbinary(max) field so you have a lot of choices on...

Satya(SQLMaster) (9/2/2011)

---

I prefer Method 2 and as referred above the performance is big aspect here, depending upon the application type how the data is extracted and how frequently you should...

I wonder if all the pathologists request reports to a single user of your company, then this user generate the reports and send it back to the pathologists, you would...

You don't need to define the dataset in advance in a .net application (you can if you want though).

You can pretty much send any query to any databases and output...

That's what i meant by application owner, it doesn't have to be a single person but it's usually a team.

My example was already complicated enough, i didn't want to make...

I guess that's another 'it depend' answer.

In this case i depend on the size of the company.

If you have a small company with few devs, then they can own code...

You can't encrypt the structure in a way that would keep it from the DBA.

It's a bad way to protect something and the best way to annoy your DBA.

For the...

And triggers can be disabled by a DBA.

In SQL Server there is not way to restrict a motivated sa from seeing anything he wants to see unless it's encrypted outside...

How would a DBA debug problem without having access to the structure?

If you want to keep your structure secret, make your application works over the internet and host the servers...

Here is my take on this.

In here we have 3k+ SQL DBs over 110 servers, we are 5 DBA to handle SQL and Sybase.

Usually 3-4 DBAs are busy trying to...

I don't see any reason to use automatic update.

It has been invented for people who don't know anything about computer to be able to keep up to date.

Even if you...

Seeing that kind of problem is not easy, first of all because you would need a baseline to compare it to and you would need a load that can be...

We've had the same question here a few month ago.

A provider asked us how they could hide all their design from us (dba), the short answer is they can't.

A...