June 26, 2012 at 9:16 am
Brandie Tarvin (6/26/2012)
Grant Fritchey (6/26/2012)
WayneS (6/26/2012)
I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?Sorry. I'll be down in Florida with the Scouts, sailing & snorkeling.
You won't even have to find a lake or the ocean to do either. @=)
Debby is still hanging out, Grant. Your weekend may be ruined, but keep an eye on the weather to make sure.
That looks like it's mostly Northern Florida. We're down in the keys. Weather looks pretty good.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 26, 2012 at 9:16 am
Brandie Tarvin (6/26/2012)
BTW, we got a 4 star review from Manic Readers on our new YA series. . . . Makes up for half the state being underwater.
Brandie, I am getting the feeling that there are lots of people who would disagree. 😉
However, congratulations on your continued success!
June 26, 2012 at 9:19 am
Revenant (6/26/2012)
Brandie Tarvin (6/26/2012)
BTW, we got a 4 star review from Manic Readers on our new YA series. . . . Makes up for half the state being underwater.Brandie, I am getting the feeling that there are lots of people who would disagree. 😉
Bah. I'm not near a creek. I'm not worried...
Much.
Wow, that's a mighty big river a couple of streets over...
June 26, 2012 at 9:37 am
Ick - that sucks.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 26, 2012 at 9:43 am
EL Jerry (6/26/2012)
Revenant (6/26/2012)
Stefan Krzywicki (6/26/2012)
EL Jerry (6/26/2012)
Jan Van der Eecken (6/25/2012)
Brandie Tarvin (6/25/2012)
0-1 column instead of BIT.Don't take the word BIT in your mouth. JC is watching!
Does anybody else agree with me that there should be a BOOLEAN data type as in other languages? I used it in PASCAL and xBASE (I guess) and it works wonders for these cases.
"El" Jerry.
What would be the difference between BIT and BOOLEAN?
BOOLEAN would allow you to write --
IF myBoolean THEN ...Stefan,
The BOOLEAN data type would only have two values: TRUE or FALSE. Not 0, 1 or NULL, just TRUE or FALSE. This is why it would be simpler to write:
[font="Courier New"]
DECLARE ProcessedFlag BOOLEAN
ProcessedFlag = FALSE
.
IF NOT ProcessedFlag THEN
BEGIN
.
.
.
ProcessedFlag = TRUE
END
/* */
SELECT CustID, CustName, OrderNo
FROM PurchOrders POs
WHERE POs.HasBeenApproved
[/font]
This is only my opinion.
"El" Jerry.
I guess I just don't see how it makes enough of a difference to justify including it as yet another data type. I think ATM I'd be in favor of getting rid of some data types before adding any new ones. Decimal for example.
--------------------------------------
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
June 26, 2012 at 10:09 am
Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.
http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx
June 26, 2012 at 10:14 am
bitbucket-25253 (6/26/2012)
Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx
As an individual, nope. As part of a team, sure. Just need to know I would work evenings and weekends as I'm looking to augment my current income.
June 26, 2012 at 10:25 am
Lynn Pettis (6/26/2012)
bitbucket-25253 (6/26/2012)
Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx
As an individual, nope. As part of a team, sure. Just need to know I would work evenings and weekends as I'm looking to augment my current income.
That's what I told him he will need.
Lynn, I will have a piece of work that I will be able to farm out, in about four weeks.
June 26, 2012 at 10:44 am
Revenant (6/26/2012)
Lynn Pettis (6/26/2012)
bitbucket-25253 (6/26/2012)
Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx
As an individual, nope. As part of a team, sure. Just need to know I would work evenings and weekends as I'm looking to augment my current income.
That's what I told him he will need.
Lynn, I will have a piece of work that I will be able to farm out, in about four weeks.
Sounds good, I'll send you a PM with my email so we can discuss the details.
June 26, 2012 at 12:05 pm
SQLRNNR (6/26/2012)
Ick - that sucks.
I'm curious about what is being done to ensure that something like this doesn't happen again?
They do know about those file checksum thingys, don't they? Verifying that those match should be a mandatory first step after downloading the file.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 26, 2012 at 12:55 pm
WayneS (6/26/2012)
SQLRNNR (6/26/2012)
Ick - that sucks.
I'm curious about what is being done to ensure that something like this doesn't happen again?
They do know about those file checksum thingys, don't they? Verifying that those match should be a mandatory first step after downloading the file.
Not a clue. And since I'm not likely to publish anything again any time soon (during which the process will change again), kind of don't care. Just figure out how to get those two 1-star reviews pulled off of it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 26, 2012 at 2:22 pm
Well, I did the best I could.
I 'liked' the book on Amazon, gave it 5 stars and wrote a small review.
Also voted the 1-star review as unhelpful, as it discusses only layout and not really the content.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2012 at 5:28 pm
And we have another horror story, Already tried repair, rebuild, detach/attach, backup/restore (no backup prior to this error).
June 26, 2012 at 8:09 pm
EL Jerry (6/26/2012)
The BOOLEAN data type would only have two values: TRUE or FALSE. Not 0, 1 or NULL, just TRUE or FALSE. This is why it would be simpler to write:
I vote for a TROOLEAN datatype: Yes, No, Maybe (and unknown)
And I also pine for a time duration datatype.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
June 26, 2012 at 8:45 pm
dwain.c (6/26/2012)
EL Jerry (6/26/2012)
The BOOLEAN data type would only have two values: TRUE or FALSE. Not 0, 1 or NULL, just TRUE or FALSE. This is why it would be simpler to write:
I vote for a TROOLEAN datatype: Yes, No, Maybe (and unknown)
And I also pine for a time duration datatype.
That data type is called TRIVALENT and was available in several now-extinct languages introduced in the 70s.
Viewing 15 posts - 36,691 through 36,705 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply