My shop wants to look into using Sql Server 2005 replication. I checked MSDN and found very little. Does anyone have any resouce links they can...
I'm considering moving all my Sql Servers off of port 1433. I see from other posts the practice is encouraged and used a fair amount. The actual...
Perfmon and Sql Diagnostic Manager are showing me big swings (3500> to <300) in my page life expectancy. The server has 5 GB RAM so I doubt total...
Last night we rebooted a server to undo the /3gb switch. The shutdown time in the Sql Server log errorlog.2 is: 2005-06-12 21:55:26.48 server...
Starting in early 2004 our activeactive SQL Server cluster started experiencing intermittent slow downs, mini-dumps, and error messages in the client...
Is there a way to read an extended database property in "database A" if my current database context is "database B"? I'm trying write a procedure to...
My server has 10 gig of physical RAM. Sql Server is using 8 gig via AWE. Do I still need the /3gb switch in my boot.ini? I'm thinking that using...
Does anyone know how to schedule Performance monitor on a regular and ongoing basis? The schedule tab is fine for starting it one time but doesn't...
Separate names with a comma.