if statement or dynamic query

Question

if statement or dynamic query

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

gan-685682 Ten Centuries Points: 1216 More actions · Answer 1

GSquared (5/13/2008)
GilaMonster (5/13/2008)
I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the complexity of federating this.
What kind of reporting are you trying to do on this? Just from Reporting services, or from other apps too?
The reason I mention federating is because it was mentioned that this used to be 7 tables on 7 servers, if I'm reading it correctly.

I am welcome for any suggestion, maybe it's not useful this time, but might helpful in the future 😀

Anyways, thxs for any reply!

gan-685682 Ten Centuries Points: 1216 More actions · Answer 2

GilaMonster (5/13/2008)
I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the complexity of federating this.
What kind of reporting are you trying to do on this? Just from Reporting services, or from other apps too?

By the way, most of the sites is using MSSQL 2000, any idea? I found this at TechNet , but I would say this is a workaround only.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

GSquared (5/13/2008)
The reason I mention federating is because it was mentioned that this used to be 7 tables on 7 servers, if I'm reading it correctly.

Missed that. Thanks

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

gan (5/13/2008)
By the way, most of the sites is using MSSQL 2000, any idea?

Other than suggesting that SQL 2000 questions should go in the SQL 2000 forums?

Dunno. I'm still not clear on what reporting you're trying to do and what problems you're encountering. Can you be a bit more specific please?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

gan-685682 Ten Centuries Points: 1216 More actions · Answer 5

GilaMonster (5/14/2008)
gan (5/13/2008)
By the way, most of the sites is using MSSQL 2000, any idea?
Other than suggesting that SQL 2000 questions should go in the SQL 2000 forums?
Dunno. I'm still not clear on what reporting you're trying to do and what problems you're encountering. Can you be a bit more specific please?

I will post there if needed, thxs. Regarding the SSRS issue, I am not quite sure since I am from diff team. GilaMonster , Just want to check with you if detach the very old no-use secondary file(*ndf) is possible to speed up the process of the current secondary file(*ndf) if table partitioning is used?

I found only Piecemeal Restore of Only Some Filegroups .

Or do i need to do something like: ALTER DATABASE database_name REMOVE FILEGROUP filegroup_name

Will it improve performance??

Thanks in advance!