Viewing 15 posts - 27,586 through 27,600 (of 39,769 total)
Haven't read that one, but I did have one called "Data Modeling" that I read years ago and liked. There's a new one from Eric Johnson and Josh Jones that...
July 31, 2008 at 12:41 pm
GROUP BY the other fields. I think that will get you where you want to be.
July 31, 2008 at 12:40 pm
Somewhere there is a default location for data and log files.
No worries, after you've installed it, you can change this. Right click server, properties, database properties. You can choose...
July 31, 2008 at 12:38 pm
tempdb should always be in simple mode. If it's growing large, you have a large transaction, or open transactions.
dbcc opentran will look for open ones.
For large ones, not much you...
July 31, 2008 at 12:37 pm
No idea here. Is the schema changed between the old and new databases?
July 31, 2008 at 12:34 pm
select @@servername
July 31, 2008 at 12:32 pm
The links have been changed to the Resources section at the bottom of the article.
July 31, 2008 at 12:28 pm
You need to perform that log backup before shrink will work. The active transactions (committed, not backed up), need to be removed.
July 31, 2008 at 9:07 am
A logreader would be the only thing. There's no other way to do this without adding a column.
You could add a column with a default, which might work for you....
July 31, 2008 at 9:06 am
Jeff,
You should get clarification from MS. They can be funny about this.
My understanding is you can use Dev for yourself, but everyone else needs a CAL to hit it as...
July 31, 2008 at 9:04 am
It's not in the permission list. Appears only moderators and admins can do this.
July 31, 2008 at 8:50 am
There is not. It's too much overhead to encrypt all data in there database by table. There are quite a few encryption options for columns.
In SQL Server 2008, there is...
July 30, 2008 at 9:52 pm
I don't see an option to allow this, but I'll ping the InstantForum team.
July 30, 2008 at 9:50 pm
I think that some of the crazy shipping stuff will come to a close. Still not sure if overnighting things from Amazon makes sense, but there's probably some hybrid models...
July 30, 2008 at 4:53 pm
That "editorial" isn't fact, it's an inflammatory piece. It got widely picked up for that reason and there have been some stories that show a Prius is not worse than...
July 30, 2008 at 3:51 pm
Viewing 15 posts - 27,586 through 27,600 (of 39,769 total)