Viewing 15 posts - 9,541 through 9,555 (of 9,720 total)
Check your database options. AutoShrink on? AutoClose on? Auto Create Stats on? What about your Transaction log checkpoint stuff?
Chances are the reason the first 3 logs were so huge was...
July 25, 2007 at 5:46 am
What tool are you using to do an Autobackup? A job scripted out in T-SQL or the DB Maintenance Plan backup stuff? Or a third party tool like Litespeed?
This makes...
July 25, 2007 at 5:39 am
If you can't add a non-admin user to the app server and the web server, you may be stuck. That's the best solution I can think of, is using a...
July 25, 2007 at 5:31 am
I'm glad I could help you out, Cathy. And Chris actually has some good ideas (the best come from personal experience) that you might want to consider also.
July 24, 2007 at 10:59 am
Hear, hear, James! Having to explain why you want a wrist pad for your keyboard or monitor risers so you don't strain your neck ("Why didn't you need this before?" they...
July 24, 2007 at 9:21 am
I am also a beginner at this, so someone correct me if I'm wrong, but here's what I've gotten from the articles I've read.
Once you've determined where all your source...
July 24, 2007 at 9:15 am
Cathy,
There are a couple of things you should note about Paul's comment. First, he suggests using a combo primary key for your OrderDetails table which you said you wanted to...
July 24, 2007 at 5:44 am
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
Viewing 15 posts - 9,541 through 9,555 (of 9,720 total)