partition Image

partition

question
Jon Crawford avatar image
Jon Crawford published Default

I have to find row count of all tables in a database based on a distinct column value in respective table.

sql t-sql sql server 2012 tables partition

0 Likes

1Answer

0 Comments

question
Rajasekar avatar image
Rajasekar asked Default

i have a table which has 5 million records partitioned by 366 day wise partition and having last 20 days of record.

fragmentation partition

0 Likes

0Answers

0 Comments

question
JohnM avatar image
JohnM answered Default

Data Partitioning

partition

0 Likes

1Answer

0 Comments

question
JohnM avatar image
JohnM edited Default

PARTITION SCHEME values are out of order

partitioning partition

0 Likes

0Answers

0 Comments

question
SQL_Mty avatar image
SQL_Mty asked Default

SSAS 2008 - Possible to define a default value other than 0 or blank?

ssas cube error-handling partition process

0 Likes

0Answers

0 Comments

question
gkganeshbe avatar image
gkganeshbe published Default

While altering the partition, does the old partition move to new file group?

partitioning partition table partition

0 Likes

0Answers

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

SQL Server 2014 Partition Function

sql server partition enterprise-edition

0 Likes

3Answers

1 Comment

question
ThomasRushton avatar image
ThomasRushton answered Default

how to select range values

select group-by partition sequence

This question has an accepted answer. Accepted

0 Likes

1Answer

5 Comments

question
helal avatar image
helal answered Default

Calculate number of groups and group size with multiple criteria

sql-server-2008-r2 partition

0 Likes

0Answers

3 Comments

question
g_yerden avatar image
g_yerden asked Default

Cool Insert Question using Partition

insert cte partition row_number

1 Like

0Answers

0 Comments

question
jdmelsa avatar image
jdmelsa asked Default

How do I remove Partition Schemes and Functions that got created by Full Text Index

sql 2012 partition

0 Likes

0Answers

0 Comments

question
Tom Staab avatar image
Tom Staab edited Default

Get unique partition number to the table partitions on the same column in a database

partitioning partition table partition

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
smayer avatar image
smayer answered Default

SQL Server 2012 Vertical Partition -- User Sees 1 Table?

partition

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
KenJ avatar image
KenJ commented Default

Partitioning using Lookup function

partitioning partition

0 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey answered Default

SQL server partition

partition

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

25 Posts
24 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.