In terms of guidance, the detailed answer is to get my 2012 book on query tuning. The more general answer is to capture the wait statistics before and after you...

Without seeing the code, the structure, the error messages, something other than vague descriptions, I'm hard pressed to suggest something meaningful. The nature of the problem, works fine with one...

If you're talking about Central Management Server, you can register the 2000 machines from the central machine, but you can't join the CMS from the 2000 machines.

You can restore through the GUI or through T-SQL commands, but you'll have to get everything set correctly. If there are 10 data files that define this database, you need...

yeah, the hardest part about row level security is that all access must go through a common path in order for it to work. As soon as you open up...

Yes, you can break down the process, and probably should. But telling you how based on nothing other than "the process is big" is pretty hard.

You sure can. Microsoft has good documentation on it here and here.

SQL Injection

It's not a good thing. You are absolutely making it possible with that code. Please stop and tell all your friends.

I'd say the current setup is OK. If anything, I wouldn't go with lots of full backups because you do pay for that with load on the system. Plus, as...

No way in the world, at all, to avoid the log, so best practice is to find ways to deal with it. No other choice there. If you don't need...

If I don't have the before and after I don't know if I tuned it, let alone telling my boss that I just shaved X amount of time or resources...

jshahan (2/20/2014)

---

We developed a test that required applicants to write queries against our proprietary database that would answer a list of specific questions we provided along with which tables to...

rchantler (2/18/2014)

---

"If an object in the query does not exist, the validation fails and no estimated plan is created"

Is something executed in this case, i.e. is there an actual execution...

Happy to help.

Test it:

CREATE TABLE dbo.LetsRecompile

(

ID INT IDENTITY(1, 1),

MyVal VARCHAR(50)

);

GO

CREATE INDEX WhatHappens ON dbo.LetsRecompile...