You can't turn that part off.

The only thing you can do is run the two delete statements inside a single transaction. Then, the data gets deleted, effectively, together and at the same time. But the...

Deployment Manager is focused currently on .NET code & databases.

I've never seen anything yet that can do SSIS, SSAS, and SSRS on top of everything else. I helped build a...

Just remember that the user defined muti-statement table valued function works off the construct of the table variable. the table variables one defining characteristic is it's lack of statistics. So,...

The individual logins under the server folder are all about access to the server itself. Then, under the database are the individual database users. These can be mapped back to...

GilaMonster (2/4/2013)

---

I could live without the GUI, the enhanced windowing...

I'm with Gail, look the stuff over and see what you think about it. If I'm interviewing you, I don't want to hear my opinion, I want yours. And if...

I'm not familiar with that particular part of Sharepoint. Sorry. It does sound like you're largely on the right track.

Clustered indexes is slightly more important than primary keys, but yeah, I'd want both. You're right there.

But, you said this was a Sharepoint database? You can't really modify the structure...

Honestly, the best advice I can give you on running the tuning advisor is: Don't.

But, it sounds like you're capturing the load, but that you're not restoring the database to...

Basically, a hash builds a table with a key and then uses a probe function to join together two streams of data. Then, if the key in that table is...

I think SqlVogel has primarily nailed the technical part of the answer. I'd add one more reason for using a primary key over just using unique constraints. Clarity. By defining...

And backup is an operation that lets you see what percentage complete it is if you look at the running process in sys.dm_exec_requests.

SQLSACT (1/31/2013)

---

Thanks

I understand the workspace memory area (Well, I hope I do). A query will request required memory and once the query has been granted that, if it needs to,...

If you have a query that is taking a long time, the first thing I'd suggest is taking a look at the execution plan to understand what it's doing on...