Hi Gail (et al) - Just one last thing...

The system we chose to go with needed to have the Filegroups redone (because we had 2 test systems, and the directories...

Gail - you are a genius! Thank you again!

Reference:

http://technet.microsoft.com/en-us/magazine/gg452698.aspx

GilaMonster (4/27/2012)

No, that will leave your database offline and unusable.

Inserting into tables doesn't require the file names, but if you take the DB offline, rename the files and bring it...

And Gail - also and lastly - if my previous question turns out to be a yes, can I then reconstruct a partition scheme without having to drop a table...

Awesome...So I should just be able to take the database offline, deattach it, change my Filegroup Directory names, and Filegroup File names, bring it back up online, and be good...

We definitely have...It looks like it is going to work out nicely, but it took some debate on getting the partition key in with the previous lone column that made...

Thanks for all the encouragement gang...I believe the ultimate decision to go with MySQL over staying with MS SQL was due to the main listener interface here at the company....

When it comes to networks, and network speeds, there are so many factors involved that it's just not as easy as saying that something should be 10/100/1000 speeds.

Here's an example...LAN:

...

sniff, sniff, sniff. . .:crying:

I'm very very sad. Yeah fine - Linux RedHat, Mongo NoSQL, and no more Microsoft.

I never:

- Got to meet Gail

- Got to go...

The datetime column is used in one query in particular with the DeviceID, but moreover - it is supposed to be the Partition Key column in the second database (but...

Perhaps this will help me out a bit in my search for ideas...

The 2 tables in question in my first test db look like this...

/****** Object: Table [dbo].[TESTTBL1] ...

I know this script and thread are a few years old, but this is a very helpful dependency finder for PROCS, so I wanted to share a slight change that...

My fault - I should have been more clear when I said "system ldf's" that TEMPDB's log was in there.

The TEMPDB.ldf was in that directory, so I figured it would free up space by restarting the service. TEMPDB is on a partition all his own. One for...

I wound up retrieving about 7gb of space back with the service restart. It had more to do with not wanting the db to run out and crash at...