Also, if you can provide us DDLs, Sample Data, proc script and Execution Plan (actual), we can attempt to tune your query.

Is it initial setup? Or it was working fine with parttioning and you are facing issues with partition switching only.

I tried to reproduce the issue on my end & I...

Based on what you explained, all of them should work. Can you please provide us DDL & consumable data to explore your issue? I am sure it’s data driven issue.

I am happy you were able to resolve the issue but you achieved with manually editing / deleting registry entries only. Manual Registry Cleanup can crash your system (worst scenarios)...

It might be permission issue. It’s a DEV environment & I don’t believe much restrictions are required, try giving them appropriate permissions so they can query on system tables /...

Easy answer (at least in my case), I have 3 customers (3 databases) & different time zones. We already knew the database workload distribution so we identified different times for...

Nice Avatar Adam! 🙂

@nick-2: I assume you didn’t explain the business case for partitioning but it might be just because you are new to DBA job (as you mentioned below). No worries. Please...

Posted Tuesday, July 11, 2006 6:40 PM

Also, a potential SPAM! (Didn’t report it yet, looking for more opinions)

Two posts... Almost same content... But two different posters so can’t mark it duplicate.

For your help, providing cross references. It will help you both.

http://www.sqlservercentral.com/Forums/Topic1236185-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic1236167-391-1.aspx

Two posts... Almost same content... But two different posters so can’t mark it duplicate.

For your help, providing cross references. It will help you both.

http://www.sqlservercentral.com/Forums/Topic1236185-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic1236167-391-1.aspx

If you know only Access then actually you don't have options right now. So for your current issue, please find solution in Access only.

There are few, still prefer Access and...

Will you please explain what do you mean by ‘what about encapsulation’?

It’s known behaviour of SQL Server (Installer). To avoid this, I install SQL Server first then Visual Studio (if required). Few of my colleagues try to install it other way...

If you spend some time reading following article, you would be able to find the answers to your questions yourself. Ultimately you should understand the concepts before you implement Partitioning.

Partitioned...