Viewing 15 posts - 13,906 through 13,920 (of 39,919 total)
You need to read about files and filegroups in Books Online. By default, a database as one MDF file for data, and one LDF file for logging. You can add...
May 10, 2012 at 10:20 am
It would help if you provided some DDL for the tables and list the relationships that are defined.
If I read this correctly, you have multiple databases that are...
May 10, 2012 at 10:08 am
IIRC, there isn't a difference when you grant. If you add new objects, they are picked up by datareader/writer. Seems to also work in R2.
May 10, 2012 at 10:03 am
I've usually had the media for downgrades already. You can re-use an old key, IIRC. If you don't have it, I'd contact the seller or MS.
May 10, 2012 at 9:59 am
That book talks about that. For the most part, it recommends you not drink, or have one, and do not bring your family, or bring them for short periods.
May 10, 2012 at 9:58 am
WayneS (5/10/2012)
Hey Steve... how about an "author day" where you do several articles (and maybe QotD) from one author?
...
May 10, 2012 at 9:49 am
TravisDBA (5/10/2012)
May 10, 2012 at 9:23 am
Tim Walker. (5/10/2012)
Thanks Steve. We've used SQL Azure, and changed quite a lot to do so.
So I'm wondering how Microsoft persuade your average Joe that making potentially wholesale changes to...
May 10, 2012 at 9:21 am
Henry_Lee (5/10/2012)
Steve, keep up the good site. Rarely a day goes by that I don't read something on here.
Thanks, and glad I can keep you interested.
May 10, 2012 at 9:18 am
WayneS (5/10/2012)
Regarding today's (10 May 2012) QOTD: several folks have stated that it could have been worded better. My question to you is how would you have worded it...
May 10, 2012 at 9:17 am
Clearly it's
WAYNES'S WORLD, PARTY TIME, EXCELLENT
QOD (http://www.sqlservercentral.com/questions/T-SQL/89819/) and article (http://www.sqlservercentral.com/articles/Performance/89505/) published today.
May 10, 2012 at 9:15 am
RDS gives you a database service that works like the 2008 R2 Dev edition. No Windows logins or host OS access, but if you work with the features and functions...
May 9, 2012 at 4:08 pm
you'd be better off posting this in the SQLCompare forums, but does this user exist in your instance?
SQLCompare looks at your users on the local database. If they don't exist...
May 9, 2012 at 3:52 pm
I have to ask: how does your boss letting you extend your lunch to fix a work problem equate to him being "understanding"?
There's a name for that syndrome...
That reference was...
May 9, 2012 at 3:50 pm
AFAIK, ope.three is correct. You cannot downgrade these licenses. You would need to uninstall and reinstall.
May 9, 2012 at 1:45 pm
Viewing 15 posts - 13,906 through 13,920 (of 39,919 total)