Be careful with using Robocopy on large files - it uses buffered IO functions in the Windows API which can lead to massive paging and negatively impact SQL Server performance.

These...

vreten (4/18/2011)

---

This is what I came up with, it converts the start time from UTC to whatever the local time is running on the sql server it is dynamic and...

One downside of datetimeoffset is that it's not easy to switch to different timezones without understanding the nuances of Daylight Saving Time (though to be fair it's not easy with...

The article states that SQL 2008 is a prerequisite but mirroring has been around since SQL 2005 SP1.

Also, the witness can be Express or Workgroup edition.

Finally, I want to emphasize...

I'll take it!

Are you using typed or untyped XML?

This sounds a bit off topic from what the discussion was...

Zach,

Interesting approach but is there a way to script the commands out as CREATE INDEX...WITH (DROP_EXISTING=ON) ON [FILEGROUP] instead of dropping the indexes first and then creating the new ones?...

john_jakob (8/29/2008)

---

I ran into this problem several times with SQL 2000 replication -- 2005 might be similar.

First try deleting all rows in the table in question at the...

I wrote an article published in the June 2010 SQL Server Magazine which includes how to do this. Here's an excerpt:

SQL Server can be configured to raise alerts when specific...

Whenever you have a central subscriber topology I recommend changing the default behavior for what to do if the table articles already exist at the subscriber. To do this open...

paul.knibbs (8/27/2010)

---

Normal human being? Well, sort of, although...

I like the Dark Knight - a wealthy, stand-up guy who gets to play with cool technology. Knows when to bend the rules and just how far to bend them...

These procedures pull from the distribution database and it's populated by all the various agents the same way regardless of if the publisher and distributor are the same instance.

Have you...

DMVs\DMFs don't tell you anything about latency. Three ways I suggest:

1. Replication monitor. Pretty sure most everyone who works with replication knows this one.

2. Tracer Tokens (See BOL here: http://msdn.microsoft.com/en-us/library/ms188024(SQL.100).aspx)

3....