Sorry, but there are no more tags available to filter with.
-
By now, we are partitioning data based on 01/01/2008 as range right. Now lets assume that it is already 2009, and you want to add another partition. The good news is that, anytime you feel like it, you can add or remove partition. To create another partition for 2009, first you have to create a new filegroup...
-
After you have successfully configured table partitioning, how do you then verify that it is actually working? Well you can use either of these two queries to do that: SELECT * FROM sys.Partitions WHERE [object_id] = OBJECT_ID('[you partitioned table]') OR SELECT *, $Partition.[partitionfunction...
-
One of the ways to optimize the read performance of your database is to partition your data horizontally. This means that, one table, might be partitioned to several files that are stored on several disks. More disk = more IO performance BUT you have to remember that it is only true if the total number...
-
Hello Ethiraj, Yes what you have read is correct. Regarding instanciating 100+ database in a single instance of SQL server, this will definitely have its effect on performance not only when it comes to the threads but also to cpu, memory and io utilization. What I would recommend is you use system monitor...
Page 1 of 1 (4 items)