The amount of space in the MDF file has zero to do with the performance of the disks. If you have high I/O, then you either don't have enough spindles,...

What command did you run? I don't like shrinkdb because you can't control it well. I prefer shrinkfile if I need to get back space and clear things up.

However, do...

You cannot backup and restore partitions. You can do filegroups, and if that contains just your partition, I believe you can restore that filegroup, then switch in the partition.

The other...

Excellent, and I'll try to edit it in a timely manner :hehe:

The logging can be just inserting rows in a table somewhere. Something easy in your control flow that just adds a step before/after each loop through a file.

It might help in upgrades, but I don't think the risk of the feature being used elsewhere is worth implementing it.

drowlfs (3/10/2011)

---

I kind of agree with that in production. But problems happen on production where a DBA (or developer who is doing the DBA work) needs to take a look,...

TravisDBA (3/10/2011)

---

Although I agree with the general direction of the ediitorial, database server security concerns all depend on the IT manager's policy on security. I once worked with a company...

Seems like overall news has been quiet. Rockies seem to be having a quiet camp.

The old men had practice last weekend, and that was good. Swung a bat for the...

Anything in particular? Something that the Database Design stairway did not cover well for you? I know they're different topics, but I'm looking for input on what direction you might...

Go for it. Submit them through the "Write For Us" link on the left when you can.

I'm thinking working BIDS, but getting the packages back to the file system (easy) or deploying out to a new SQL Server for running as an Agent Job.

I saw a...

I like numbers, perhaps not fascinated. days like 10/10/10 make me smile, but I don't necessarily look forward to them.

I do enjoy helping my kid to algebra, breaking down polynomials,...

Here's a short article on calendar tables, if you need one: http://www.sqlservercentral.com/articles/70482/

A few links for you:

2005, WinterCorp: 19TB warehouse - http://www.wintercorp.com/VLDB/2005_TopTen_Survey/2005TopTenWinners.pdf

Paul Randal's survey, 3 people over 100TB: http://www.sqlskills.com/BLOGS/PAUL/post/Bigger-is-better.aspx

1.1PB SQL Server: http://news.softpedia.com/news/Microsoft-Applauds-1-1-Petabytes-SQL-Server-2008-Database-97388.shtml