Forum Replies Created
Viewing 15 posts - 1 through 15 (of 2,838 total)
-
Reply To: NULL Storage
What's the size of a pointer to a variable width column?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
Reply To: NULL Storage
Thanks Scott, but "present" how? They don't show up in storage.
And if NULL is set as 1 bit per column, then I should be showing the size of the table...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Are the posted questions getting worse?
Thank you all for the input. I know I was vague, but I can't be disclosing company-sensitive stuff.
I'm glad I can come here for more opinions of people who...--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Are the posted questions getting worse?
They say it is scalability and rapid development.
I believe it is because someone heard buzzwords & they don't understand the technologies involved.
They have not done any study. They...--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Are the posted questions getting worse?
Hi everyone,
It has been awhile since I posted here and I hope you're all doing well.
I have a weird situation and I was wondering about the opinion of...--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Zero to Many relationship
The child information gets created first as it is configuration data. Parent records might not get created for hours or days after.
Basically I want to create orphans and have...--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Strange visual during restore
Since the person in question was transferring a terrabyte database on a laptop, lack of RAM is likely it. Thanks all!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
Jeff Moden (12/27/2016)
ScottPletcher (12/27/2016)
Jeff Moden (12/26/2016)
Sergiy (12/15/2016)
ScottPletcher (12/15/2016)
Pretty soon you'll see in queries "WHERE Status&8 >0".
I guess I don't see why that's so much worse than a non-bit comparison...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
Jeff Moden (12/26/2016)
Sergiy (12/15/2016)
ScottPletcher (12/15/2016)
Pretty soon you'll see in queries "WHERE Status&8 >0".
I guess I don't see why that's so much worse than a non-bit comparison of "status =...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Random number generation based on condition
squvi.87 (12/14/2016)
Need to generate random number based on ID3 column. Have mentioned each rows logic in remarks. Note: This is a sample data I need to apply on big set...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
ScottPletcher (12/15/2016)
Pretty soon you'll see in queries "WHERE Status&8 >0".
I guess I don't see why that's so much worse than a non-bit comparison of "status = 8" or "code1...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
Jeff Moden (12/15/2016)
Sioban Krzywicki (12/15/2016)
Jeff Moden (12/14/2016)
Sioban Krzywicki (12/14/2016)
What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?Who's...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
Jeff Moden (12/14/2016)
Sioban Krzywicki (12/14/2016)
What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?Who's going to read the...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
Sergiy (12/14/2016)
Sioban Krzywicki (12/14/2016)
What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?Then they are not needed.
Of course...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
RE: Bitwise & NULL
What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 15 posts - 1 through 15 (of 2,838 total)