SQL Server 2005 General DBA QuestionsPlease post SQL Server 2005 general DBA questions here.Compatibility level of a database- September 10, 2008 Normal 0 false false false MicrosoftInternetExplorer4 Style Definitions table.MsoNormalTable mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New...http://sql-server-performance.com/Community/forums/thread/151022.aspx Need a better understanding of SQL WMI options available- September 10, 2008 I created a WMI alert for deadlocks recently, but would like more information on the types of alerts I can create that are based on WMI. Do you have any links to articles describing all of the WMI options available to SQL Server Thanks, Davehttp://sql-server-performance.com/Community/forums/thread/151009.aspx Multi server Administration -Maintenance plan job configuration- September 8, 2008 Hi, I have a master SQL2005 server and i have added target servers to my master server. The problem is this.I configured backup jobs(in form of maintenance plans) in the Target server for the databases. In the Master server I created new backup job calling on the SSIS package from the target servers maintenance plan and also specified the target machine in the traget step. I removed the regularly good running backup job in the target machine as i dont want 2 backups to be retained in my...http://sql-server-performance.com/Community/forums/thread/150936.aspx Help please- September 8, 2008 Hi, I hope someone can be of some assistance. I am trying to get query to return records that have a match of 3 or more out of 7 parameters. The table has 6 colums and if I provide 7 parameters ie: 2,5,9,17,32,35,44 I would like to see row 2,8,10 and 15 returned. 5 7 10 18 24 35 5 9 ...http://sql-server-performance.com/Community/forums/thread/150905.aspx |