I prefer to think of it as "long running queries". You can either use SQL Profiler with a duration filter, or you can use DMV's with TSQL. If you go...

Everything has a particular context that is already known, and adding entity prefixes to columns is redundant and nonflexible with the possible exception of Identity/GUID/Surrogate key columns.

Consider the scenario...

Try installing SQL Server cumulative service pack 3. You may be suffering from a different, or additional problem. then what 931593 specifically fixes.

Excellent - and kudos to you for "standing up" to the developers Felicitywie. This is a good precedent to set in your new position. There is a delacate balance between...

It sounds like the poor performance has a very weak correlation to the switching on and off for the setting. I have used read committed snapshot and toggled off/on with...

Itzik Ben-Gan Inside Microsoft SQL Server 2008 Series.

There may not be anything you can do about it, but it sounds like a bad requirement. It puts the responsibility on you for other people's code. The test and...

P Jones (9/15/2010)

---

Let them have SQLAgentOperatorRole on the development server but not on test or live. DBA does transfer of job to test and then to live once they've set...

The execution plan will show you what indexes are in play and which ones are missing. If you are on SSMS 2008/2008R2 it will show you which indexes are missing...

I would not allow them to modify their jobs without the approval process of a DBA. The method you would use for allowing them to modify thier jobs would be...

These wait types look like the T-SQL is running in parallel and result sets are being combined. However, I am curious what you are looking at that is showing that...

This goes back to the role playing that I mentioned.

Dimensions can play different roles in a fact table depending on the context. For example, the Date dimension can be...

It sounds to me like you are using SSAS (Analysis Services). I always try to start out using the base objects as they are in the DSV, and if I...

I see. I guess if that's what you were dealing with you could have just as easily generated the script with

SELECT 'DENY SELECT ON [' + s.name + '].['...

GRANT SELECT ON [Schema Name].[Table Name] to [Principal Name]

I guess you tried this but the user has access to objects through other groups/roles. What you are trying to do cannot...