Q
Manage Learn to apply best practices and optimize your operations.

How to manage data without partitions in SQL Server

I'm migrating my data warehouse from Oracle to SQL Server, and I don't know how to manage data without partitions. How do I delete a month of data in SQL Server as I did in Oracle (drop partition). Do I have to use a month table? Thanks.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close