Viewing 15 posts - 14,311 through 14,325 (of 49,552 total)
Again, partitioning is not about performance. You define the ranges based on your business requirements for loading and removing data, that will guide your partition scheme and function. There's no...
February 12, 2013 at 2:20 am
Benki Chendu (2/12/2013)
February 12, 2013 at 1:35 am
Let me guess, tiny table, 2 or 4 pages in size.
February 12, 2013 at 1:21 am
My previous advice stands. If no work is being done (and since you didn't post the recovery messages I can't tell), restart SQL. Otherwise wait. Or open a case with...
February 12, 2013 at 1:20 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Is the distinct really necessary?
February 12, 2013 at 12:49 am
Hollyz (2/11/2013)
One would think when you would do a regular insert into a table, the rows would come in the order of the identity field.
Table are unordered sets of rows....
February 12, 2013 at 12:43 am
Partitioning is not about performance. It's mostly about data management, fast loads, fast removal of data, compression of different partitions, index rebuilds at the partition level.
February 12, 2013 at 12:39 am
MyDoggieJessie (2/11/2013)
Regardless, there's little good reason to have that as part of a maintenance plan. If the maint plan rebuilds indexes or updates stats, it'll invalidate the plans that depend...
February 12, 2013 at 12:28 am
DVSQL (2/11/2013)
GilaMonster (2/11/2013)
February 12, 2013 at 12:22 am
They're all data anomalies as far as I know, and the 3 that define the ANSI standards for isolation levels have specific names and meanings, the isolation levels are defined...
February 12, 2013 at 12:21 am
The plan cache is part of the allocated SQL memory, with 26 GB of allocated memory it'll probably max out at somewhere around 5-6GB, I forget the exact formula.
Regardless, there's...
February 11, 2013 at 3:28 pm
Marius.D (2/11/2013)
So that means if column C is sorted in the wrong order, it won't be used by that one query?
No, the sort order is mostly important when you're indexing...
February 11, 2013 at 10:37 am
Well, I do hope some future employer doesn't run across this thread.
February 11, 2013 at 8:44 am
Vedran Kesegic (2/11/2013)
February 11, 2013 at 8:39 am
Viewing 15 posts - 14,311 through 14,325 (of 49,552 total)