..so can we ignore this kind of blocking?

Is there any script to continuously run as a SQL Agent job and capture the blocking and send an email when it finds...

CirquedeSQLeil (7/12/2010)

---

The servers will continue to show up despite disabling SQL Browser. SQL Browser does not control the default instance and thus an osql -L scan will still find...

The CXPacket block is caused by parallel processing. One thread in the process is waiting for another to complete, typically reads. What are the DISK performance counters like?

Some DBAs...

MIJ (7/12/2010)

---

But w/ respect to changing the fixed port number to somethign "nice and high" (rather than the default, presumably) isn't that sort of "security by obscurity"? I mean...

This is actually a really important and serious question, and here is some more for you to consider.

Disabled the SQL Browser also adds a layer of security. The browser does...

As a general rule I wouldn't put user functions into the master database. As soon as you upgrade you need to recreate everything. A more reliable and consistent option is...

I've recently had to support a 4 node cluster (all active) that was built and still is being built using your plan of adding nodes over time. In general administration...

This appears to be a fairly standard and simple update. A few questions I have is: Are any of the columns in the WHERE clause indexed? Particularly the first columns....

You may find this article handy

http://www.sqlservercentral.com/blogs/sqldbauk/archive/2010/06/25/lock-pages-in-memory.aspx

Leo

Ian Godfrey (7/9/2010)

---

If the AD account is deleted later the login is 'orphaned'. Then the SQL agent jobs stop working, and there are problems creating new tables etc...

Actually I remember going over this rercently and then when I replied to the post my brain search algorithim crashed and all it could find was the bit about log...

Jeffrey Williams-493691 (7/6/2010)

---

Leo, I believe you don't have to use a different filegroup to add a file on a different LUN. You can have multiple files per database -...

Switching to SIMPLE mode may not resolve your issues. SIMPLE mode only means the log space is made available for reuse after a transaction is committed. If you are reindexing...

To cycle the log you need to create a SQL Job that runs daily (like just after midnight) and runs the sp_cycle_errorlog stored proc.

To set the number of files to...

SQL doesn't have any way of directly addressing the SAN.

You would need to create multiple file groups, at least 2 so you have one on each LUN. And you would...