Have a look at BOL (books on line, the help file that is installed with the server or client tools and can also be found on the net) on the...

Charles Kincaid (9/30/2009)

---

Then too look at the other articles elsewhere on COPY_ONLY. You will see the stories of people who do full backup on the weekend and Log backups...

I think that it depends. There are some validation that can be done in both places (Application and DB), but other should be done (at least in my opinion)...

Vliet is correct. If you are using log backups in a restore operation, you can use a full backup that was taken with all the log backups that were...

Why do you think that fragmentation causes the dead lock? If you want I can give you a script that causes deadlock on 2 tables that each one of...

You can find this information in the second table in the section that is called “Detecting Fragmentation”. Also notice that this was taken from that same article:

“These values provide...

According to BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/a28c684a-c4e9-4b24-a7ae-e248808b31e9.htm)if avg_fragmentation_in_percent value is less then 5%, it is recommended that you won’t reorganize nor rebuild the table. If the avg_fragmentation_in_percent value is between 5% and...

You can’t use a parameter in the command line and add it to the path of the file that should be created.

Adi

I don’t think that you should disable the SQL Browser. As far as I know the browser helps when you have named instance on your machine, so if you...

This is taken from a Microsoft article about SQL Server 2000 http://support.microsoft.com/kb/195565. I couldn’t find an official article about SQL Server 2005.

Sch-M-UPD-STATS: Schema Modification Lock

-----------------------------------------

...

You can modify my code to show more then one year. Here is an example:

declare @StopDate datetime

set @StopDate = '20110101'

;with Months as (

select DATEADD(mm,datediff(mm,'19000101',getdate()),'19000101') as MyDate

union all

select DATEADD(mm,1,MyDate) from...

I’m not sure that the schema locks cause blocking. As far as I know schema locks won’t let you modify the table’s structure but it doesn’t block DML statements...

You can create a view that has all the logic and in the bcp use “SELECT * FROM MyVIEW”.

Adi

Web server has nothing to do with the maintenance jobs. Since rebooting the web server “releases” the maintenance jobs, I suspect that you have a blocking chain that...

Like others I didn’t know what to answer. I know that FROM clause can be used in an update statement, but I also noticed that the way that the...