Viewing 15 posts - 1,831 through 1,845 (of 14,953 total)
Lynn Pettis (3/23/2012)
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.
You say that like it should be obvious it's a bad idea. I got so much flak from...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 1:14 pm
Even for a small group, a primary key on that won't necessarily help. What happens if "John Smith" comes in as "Johnny Smith"? The unique constraint on the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 1:09 pm
jcb (3/23/2012)
.Net is expected to work integrated with SQL Server.
You can try this link:
http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspx
I just tested the example code and it worked, listing all servers/instances in my network.
Note a instance...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 1:03 pm
I've got databases in the same situation. Whatever your rebuild/restore methodology is, it'll be better than "repair allow data loss".
And definitely look into the various snapshot isolation strategies available,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 11:59 am
As far as the corrupted database goes, I think restoring from backups is your best bet. Assuming you have regular log backups and can do point-in-time recovery, of course.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 11:40 am
This kind of error is precisely why NoLock is recommended AGAINST by serious database professionals. Devs love it, because it makes them feel like they just discovered a magical...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 11:38 am
L' Eomot Inversé (3/23/2012)
Brandie Tarvin (3/23/2012)
Gianluca Sartori (3/23/2012)
The Dixie Flatline (3/23/2012)
What is "google"?The working counterpart of Bing. 😛
What is Bing? :hehe:
Mr Crosby's christian name. 🙂
So, since Google is the counterpart...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 11:28 am
All things considered, I'm probably a unicycle with a turbojet strapped to it. Very Wile E Coyote type vehicle.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 8:11 am
Snargables (3/23/2012)
anyone have an opinion about http://www.zip-codes.com/ ?
I've used their data. Worked just fine for a direct mail marketing company that I worked for.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 8:08 am
The Dixie Flatline (3/23/2012)
What is "google"?
You should just Google that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 7:49 am
Johnny Lan (3/21/2012)
Any solutions?
Yes. Verify connection to the domain listed, and verify the user/group listed.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 7:41 am
If you do all your DDL through scripts, and store them in source control with time-stamps, you can actually return a database object to any particular point-in-time for its schema,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 7:39 am
SSIS can definitely do that. It's the tool I'd use for it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 7:36 am
That makes sense.
Here's what I'd do in that case:
Use OpenRowset, with the Bulk operator, and have them define format files for each file type they want to use. Adding...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 7:34 am
So far as I know, that's the same in the registries of all of those. I could be wrong, but it will be easy for you to check.
I'm on...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 7:25 am
Viewing 15 posts - 1,831 through 1,845 (of 14,953 total)