Viewing 15 posts - 22,981 through 22,995 (of 39,823 total)
skjoldtc (7/23/2009)
I'll let somebody else make a joke about the "shiny bits". 😀
I didn't get a good quote here about shiny bits. I kind of forced it. I'd welcome suggestions...
July 23, 2009 at 9:56 am
Thanks and one minor note. Someone pinged me about me using freedom, as in liberty, when saying that it can be a problem. My use was intended to be freedom...
July 23, 2009 at 9:56 am
Are you talking filegroups?
The objects are all in one location, in the filegroup on disk. Not sure it matters other than trivia. AFAIK, an object cannot cross filegroups, so an...
July 23, 2009 at 9:54 am
you are welcome, and one thing I'd do is document what you do as you go along, and then save copies for yourself (and put it on a blog).
I've carried...
July 23, 2009 at 9:44 am
I work for Red Gate, so I'll mention Response. I wasn't thrilled early on with the way it worked, but I think that's because I was looking for something else....
July 23, 2009 at 9:33 am
Interesting thread, and some good info.
Here's the weird one. What if you have a 32bit VM on a 64bit host. do you want to know the host platform? I'm...
July 23, 2009 at 9:28 am
I don't remember this being a concern for me ever. Other than looking annoying in reports, or being unable to remove the user if they owner a database, but I...
July 23, 2009 at 9:25 am
Is this production?
As mentioned if you want SSIS, it will be only one version. A couple other services are not instance aware.
Otherwise, same issues as any other multi instance box....
July 23, 2009 at 9:24 am
One small addition. I'd make sure they all use their Windows account, not SA, to make changes. It will help them to be respectful towards each other, and provide a...
July 23, 2009 at 9:22 am
In 2000, if you use the built in mail, you have to use Outlook, or a MAPI complaint system. You can get some SMTP senders, like XPSMTP (http://www.sqldev.net/xp/xpsmtp.htm), but that's...
July 23, 2009 at 9:19 am
This isn't stored in the system tables, AFAIK. There are likely ways to read the IAM, SGAM, pages and relate this back to an object, but I'm not sure. The...
July 23, 2009 at 9:16 am
the error you posted seemed to indicate appends. Definitely check that.
There are some good scripts here on the site for backups that can help if you want to look at...
July 23, 2009 at 9:09 am
Is that the bent, Natural shape keyboard with the two halves separated? I tried those, but since I use my left index for "y", it didn't work for me.
I have...
July 23, 2009 at 9:08 am
there are places for improvement, and the code in the article was updated in an earlier comment. I have updated the article to reflect that.
I think SELECT is a good...
July 23, 2009 at 9:01 am
Are you appending backups to an existing file?
Don't do that. It increases your risk dramatically. If there is a file issue, and there could be as it grows, then you...
July 23, 2009 at 8:21 am
Viewing 15 posts - 22,981 through 22,995 (of 39,823 total)