Haven't we all. 😉 It's a good place to start, nothing more. I...

abhishek.khanna (7/29/2008)

---

Perhaps i need to learn how business is conducted in this forum but some people surely aint supportive n helpful. Problem is, there is always a wannabe daddy trying...

It is advisable to create nonclustered indexes on foreign keys, though whether the index should be just on the foreign key column, on other columns as well and whether it...

Oooh, you have a lot of work ahead of you. Some suggestions:

Uninstall the client tools from all of the servers. Servers don't need management studio and books online on them.

Change...

If you read all of my last post you would have seen a request for more information on exactly what was wrong with it. Had...

Why is management studio even installed on the servers? Workstation utilities should not be installed on servers.

Second, why do your users have enough privileges to log on to a production...

I think you'll have to find the source of these to get any clarity on why the locks are IX.

Look up the sp_trace stored procedures in books online. That should give you a good overview of how they work. You can create a trace in profiler, then export the...

If you didn't have some form of tracing enabled, there's no way to tell who changed the proc.

As for profiling a prod server, via the GUI is a fairly bad...

GO is not a T-SQL command. It's a client tool statement that signals the end of a batch. You don't need it here.

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

No replies to this thread please. Direct replies to :

http://www.sqlservercentral.com/Forums/Topic542367-9-1.aspx

Thing is, CheckDB does use a lot of tempDB space. There's no way to get it to use less. I would not suggest unrestricted growth, disk out of space errors...

Temp tables are dropped automatically as soon as the table goes out of scope or the connection that created it closes. Unless you're creating explicit tables in tempDB, there's no...

As far as I can tell from the deadlock graph, both parts of the deadlock are selects that are taking IX or SIX locks. If I've misinterpreted the deadlock graph,...

I was just wondering. It's not usual to see exactly the same problem from two different people.

There's an ongoing discussion over this elsewhere, I'll let you know if anything useful...