Viewing 15 posts - 9,556 through 9,570 (of 9,728 total)
Steve,
I completely agree with the giving out people's names thing. It's just funny that I don't have any to give out even if I wanted to. @=)
As far as the...
July 23, 2007 at 11:22 am
I keep getting calls from recruiters wanting to know "how are things going", putting feelers out for whether or not I want to jump ship. Then when I return their...
July 23, 2007 at 8:11 am
Sugesh,
Thanks, but I already knew about the System Process IDs.
My concern was why system processes were suspended. And my philosophy is "Better to know now when it's NOT a...
July 23, 2007 at 6:11 am
William,
A lot of people don't use FKs in their databases. They stick IDs from other tables in their tables (which isn't quite the same thing) and then rely on the...
July 23, 2007 at 6:09 am
Wow. I didn't come up with that entry at all on my search.
Thanks, Steve. I appreciate your help with that.
July 20, 2007 at 10:38 am
AH! That makes sense.
Don't know why anyone would do that, though, considering that until SQL 2005 you couldn't order by column aliases.
Well, maybe other people could, but I kept getting...
July 20, 2007 at 8:43 am
I use table aliases in my queries all the time. All of us at my office do. I don't recall that we had that warning in the UA when we...
July 20, 2007 at 8:36 am
It might if you're being inconsistant. Such as prefixing with the table name in the WHERE clause if you're using table aliases in the SELECT statement.
July 20, 2007 at 7:24 am
And it's only made worse for those who are trustworthy when the few "rotten apples" get their escapades published nationwide. I've read at least 5 stories in the past 3 months...
July 20, 2007 at 6:21 am
Here's a thought.
Orders table contains the summary version of the order.
OrderLines table contains the individual detail lines of the order including an FK to OrderID. That way you can have...
July 20, 2007 at 5:45 am
We use method two. Since it is possible for one tables ID field to be used in more than one other table, method two makes it easier for us to...
July 20, 2007 at 5:35 am
Sorry, I should have mentioned that my last comment was for Steve. It seems odd to me that the Upgrade Advisor wouldn't work if you didn't have Windows Admin permissions.
Has...
July 19, 2007 at 12:57 pm
Did you really mean to say SysAdmin?
I ask because the original post was about Local Admin Permissions on the Windows OS (Administrator rights) which isn't exactly the same thing...
July 19, 2007 at 12:35 pm
The backup for the Master Key requires a CONTROL permission on the database. That tells me the person has to be a SysAdmin, DBOwner or a DBBackupOperator. I don't know...
July 19, 2007 at 7:42 am
That's just it. Qwest would "get your permission" when you cashed the little checks they sent out. Or if you competed in a contest they were sponsering or even if...
July 19, 2007 at 7:13 am
Viewing 15 posts - 9,556 through 9,570 (of 9,728 total)