Viewing 15 posts - 23,416 through 23,430 (of 39,919 total)
Not sure if it includes a CD. You can check on Amazon if one is listed.
June 24, 2009 at 9:40 am
This is related to SQL Server in that a geoid is used as part of the basis for spatial modeling in SQL Server 2008
June 24, 2009 at 8:59 am
Not in 2000, and it's a bad idea. Even the mirror'ed backups in 2005 have issues. If one fails (one drive, network, etc.) both fail.
Don't do this. Back up locally,...
June 23, 2009 at 11:11 pm
You might have a lack of memory, slow disks, poor code, too hard to tell.
I'd suggest that you start with looking at heavily run queries and trying to tune them....
June 23, 2009 at 9:54 pm
Note that I've received a complaint on this thread.
I don't think anyone has crossed a line, but I see a few posts that are close. Please remember that this is...
June 23, 2009 at 6:52 pm
LOL, that kind of defeats the purpose of connecting to master.
I think the only thing you can likely do here, is connect as admin, then pause the server. That prevents...
June 23, 2009 at 6:08 pm
You shouldn't need to be in the database to change to multiple users. Connect to the master database as a system administrator and then alter the properties of the database.
June 23, 2009 at 5:45 pm
You could purchase a license to SQLSentry, which will help you handle this and prevent them colliding with each other. Otherwise, I like Mani's solution. Just look at history, schedule...
June 23, 2009 at 1:04 pm
I'm a little confused about what you mean by the awards and then the two approaches. Can you post a bit of sample data and explain how you see the...
June 23, 2009 at 12:59 pm
I think certifications *could* help, but they don't, at least not as they're configured. They'd need to be more practical, with a variety of things to solve.
However Jay has a...
June 23, 2009 at 9:08 am
Tom Brown (6/23/2009)
Cute photo Steve - your daughter?
Yep, at about 16 months, just learned to walk, started to dance, hasn't slowed down in 7 more years 😀
June 23, 2009 at 8:59 am
OK, I'm confused, are you writing the query in Access?
It's not clear what linked servers you have, and where you are querying. If the tables are in Access, then you...
June 23, 2009 at 8:52 am
Wow, excellent information. Ed, you need to write this up as a short article!
June 23, 2009 at 8:49 am
Do you mean the same backup to 2 locations (having a copy), or striped as in 1/2 on one drive, 1/2 on another?
Either way, running a backup to a remote...
June 22, 2009 at 10:44 pm
Viewing 15 posts - 23,416 through 23,430 (of 39,919 total)