Viewing 15 posts - 391 through 405 (of 488 total)
MIJ (7/12/2010)
July 12, 2010 at 5:34 pm
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...
July 12, 2010 at 3:55 pm
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...
July 12, 2010 at 3:28 pm
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...
July 12, 2010 at 3:12 pm
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....
July 11, 2010 at 7:06 pm
You may find this article handy
http://www.sqlservercentral.com/blogs/sqldbauk/archive/2010/06/25/lock-pages-in-memory.aspx
Leo
July 9, 2010 at 5:18 am
Ian Godfrey (7/9/2010)
July 9, 2010 at 5:11 am
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...
July 7, 2010 at 4:46 pm
Jeffrey Williams-493691 (7/6/2010)
July 6, 2010 at 7:54 pm
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...
July 6, 2010 at 7:39 pm
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...
July 6, 2010 at 5:42 pm
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...
July 6, 2010 at 5:15 pm
Are these AMD chips by any chance?
I know there is some technology that messes with the way SQL 2005 tracks time. This is typically AMDs Quite 'n Cool technology. I've...
July 5, 2010 at 3:10 pm
After starting the select or delete have you done an sp_who2 from another MS conection to see if there is any blocking?
This is the most likely cause.
Leo
July 5, 2010 at 3:03 pm
zeeaay (7/1/2010)
Thank you very much for replying so quickly to help me out. Reply to your assumptions. I am not doing anything. If you read my message carefully I...
July 1, 2010 at 10:40 pm
Viewing 15 posts - 391 through 405 (of 488 total)