Viewing 15 posts - 1 through 15 (of 195 total)
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.
November 7, 2011 at 8:14 am
April 18, 2011 at 11:57 am
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...
April 18, 2011 at 8:33 am
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...
February 1, 2011 at 7:14 am
I'll take it!
December 2, 2010 at 7:39 am
Are you using typed or untyped XML?
November 18, 2010 at 3:01 pm
RichB (10/1/2010)Helpful indeed.However, wouldn't it be even more helpful if there was an equivalent of sp_helptext for indexes and tables...
However, wouldn't it be even more helpful if there was an equivalent of sp_helptext for indexes and tables...
This sounds a bit off topic from what the discussion was...
October 4, 2010 at 7:29 am
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?...
September 30, 2010 at 7:23 am
First try deleting all rows in the table in question at the...
August 27, 2010 at 10:51 am
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...
August 27, 2010 at 10:28 am
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...
August 27, 2010 at 10:22 am
Kendal Van Dyke (8/27/2010)Just a normal human being who is constantly honing his skills and taking his share of lumps along the way.
Kendal Van Dyke (8/27/2010)
Normal human being? Well, sort of, although...
August 27, 2010 at 10:01 am
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...
August 27, 2010 at 9:52 am
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.
July 7, 2010 at 8:44 pm
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)
July 7, 2010 at 8:20 am