Viewing 15 posts - 20,791 through 20,805 (of 39,834 total)
Andrew has my advice, though if you're not sure, take a guess. Don't leave it at 1MB. I might go for 10% of largest main db size as a...
February 11, 2010 at 1:26 pm
I'll give this paper as a reference: http://msdn.microsoft.com/en-us/library/ee692366.aspx
Like everything else, this has some level of tradeoff on how you do it. I like VMs since they're easier to move to...
February 11, 2010 at 1:22 pm
Some info here: http://www.sqlservercentral.com/Forums/Topic484784-146-1.aspx
February 11, 2010 at 12:13 pm
I'd agree with the above. Use the Export wizard or Import Wizard to get a base package.
February 11, 2010 at 12:01 pm
It's likely a filter change on your end. We added a DKIM flag, required by some large ISPs
February 11, 2010 at 11:59 am
This is definitely a place where the OS and SQL should align the partitions and align the cluster/page size when you create a DB as well.
February 11, 2010 at 10:55 am
I'd do what Gus has listed.
February 11, 2010 at 10:44 am
I suspected no assignment, but I had these visions of C where = means something happens.
February 11, 2010 at 10:30 am
I'm not sure that I think multi-instancing is better than VMs. First you can't balance memory easily with instances. VMs allow you to more easily move memory around. That may...
February 11, 2010 at 9:10 am
Donald Denney (2/9/2010)
Here is the information about the paper:Consolidation Using SQL Server 2008
SQL Server Technical Article
URL for the paper: http://msdn.microsoft.com/en-us/library/ee692366.aspx
February 11, 2010 at 8:58 am
Every manufacturer has a series of horror stories from a particular person. My wife got a new Dell Lattitude late last year, a friend got one as well, both...
February 11, 2010 at 8:26 am
jparker2 (2/11/2010)
This has already been resolved.If you want to work with strings greater than 8K then declare them as XML or TEXT.
In Access use a Note data type.
Text has been...
February 11, 2010 at 8:17 am
SQL Server hasn't always been 8k. When it was ported/based on Sybase, it was 2K pages that we dealt with. I believe v7 jumped to the 8k pages, which was...
February 11, 2010 at 8:14 am
Thanks for the update. A good reason to keep up on those SPs.
February 11, 2010 at 8:11 am
Viewing 15 posts - 20,791 through 20,805 (of 39,834 total)