Viewing 15 posts - 20,686 through 20,700 (of 39,936 total)
Ron Kane (3/2/2010)
Of course the answer is not to tell the police about every testing database you ever create 😀
And hope you don't lose that data. Maybe that's an idea...
March 2, 2010 at 6:48 am
You probably don't want tables in master, and note in the example above, NULL does not need quotes. It's a reserved word.
March 2, 2010 at 6:38 am
You could build an SSIS package to suck out a few rows of data from each table, but as (the other) Steve mentioned, this doesn't mean you have consistent data....
March 1, 2010 at 5:03 pm
It wasn't me, Howard, but glad it helped.
If you go to that article and click the "discuss" link, you can ask the author a question and I'm sure he will...
March 1, 2010 at 4:59 pm
I think Roger has put things well. I'm not saying you don't have a PK. I'm saying identities work well in that role.
March 1, 2010 at 3:12 pm
It's not a question of the origin of the number, but the fact that it's arbitrary-generated, and as such isn't necessarily a PK. In the paper world, when someone generates...
March 1, 2010 at 2:34 pm
Les Cardwell (3/1/2010)
I'm shocked! :w00t: The only purist rationalization for a surrogate PK is when no 'natural key' exists. Otherwise, it's just a throwback to mainframe days when files...
March 1, 2010 at 1:25 pm
There are a few places that do a Code Camp/.NET event with a SQL Saturday. No reason not to do them together if you can find the space.
Space is certainly...
March 1, 2010 at 10:45 am
In the environment where I had separate accounts, it was mainly for security from viruses. We didn't want some trojan or virus to have elevated rights, so the idea was...
March 1, 2010 at 10:44 am
I was listening, but had to stop when it went to overtime to replace a faucet. I was watching the tweets to keep up with what was happening. It was...
March 1, 2010 at 10:40 am
RalphWilson (3/1/2010)
... however, if you add a GUID as your identity column and make it a PK, then you have, essentially, made a random number your PK.
Good point....
March 1, 2010 at 8:41 am
Roger L Reid (3/1/2010)
March 1, 2010 at 8:40 am
Doh! Didn't realize that. My apologies to Boston and the staff the Beth Israel.
February 28, 2010 at 5:42 pm
No idea. The team working on this asked, so my guess is they are somehow trying to determine if this will sell licenses.
February 28, 2010 at 5:42 pm
Viewing 15 posts - 20,686 through 20,700 (of 39,936 total)