Viewing 15 posts - 46 through 60 (of 1,157 total)
Merge replication supports dynamic filters so in theory you can create a filter using DATEADD to calculate the rows at the subscriber.
Providing you clean up the subscriber rows manually you...
March 14, 2014 at 3:57 am
SQL Guy 1 (3/12/2014)
About performance: all your partitions placed in the same filegroup. If you have 1-1 between FG and files, you can't...
March 13, 2014 at 4:07 am
Can you create a duplicate table and trickle feed a back fill into the duplicate table? I would do this into an alternative filegroup.
March 12, 2014 at 7:24 am
Based on the information above, there's no performance benefit.
The only time I've seen performance benefit by re-ordering the tables is in previous roles where I've had to override the query...
March 12, 2014 at 6:50 am
Adam Bean (3/12/2014)
Thanks for the suggestions Jeremy,But, rebuilding indexes isn't going to move heaps/blobs though will it?
Correct, it wont redistribute the blob pages to the new files. You have...
March 12, 2014 at 6:43 am
You could use SSIS or even Merge replication by switching the roles.
Have the destination server as the publisher with an empty table, then insert the data into the...
March 12, 2014 at 6:41 am
trinityr (2/25/2014) Is there a way to 'flip' databases? Meaning we use SnapshotDB1 for data reporting until SnapshotDB2 is fully populated then use SnapshotDB2.
You can do this by "queuing"...
March 12, 2014 at 6:37 am
Splitting a partition will not change the compression level.
Easy enough to check. Look at the data_compression_desc column for each partition and index_id.
SELECT *
FROM sys.partitions AS p
WHERE object_id = OBJECT_ID('dbo.tablename')
March 12, 2014 at 3:47 am
What are you upgrading? SQL Server or the database schema/data?
In the case of schema/data changes I would take database snapshot if you're using Enterprise edition.
March 7, 2014 at 6:40 am
ramyours2003 (3/6/2014)
March 7, 2014 at 4:35 am
TomThomson (3/6/2014)
Your "It depends" is something I agree with, but I disagree with the rest. It doesn't match my experience, not at all.
I would say your experience is not...
March 7, 2014 at 1:34 am
March 6, 2014 at 7:04 am
Ed Wagner (3/6/2014)If you've ever driven in the Great Smokey Mountains or especially the Rocky Mountains, it is absolutely beautiful, but it is anything but straight and the Rockies includes...
March 6, 2014 at 6:37 am
Grant Fritchey (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in the...
March 6, 2014 at 4:44 am
Koen Verbeeck (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in the world, you could...
March 6, 2014 at 4:21 am
Viewing 15 posts - 46 through 60 (of 1,157 total)