this is Oracle 10gr2 on aix 6100-02
The issue is that I do not manage to see the € sign from Oracle.
This is an easy way to see the issue:
SQL> insert into prueba values ('€');
SQL> commit;
SQL> select * from prueba;
EURO
------------------------------------------------------------
¿
...
Hmm. Just ran into an issue with SQL Server, maintenance plans, owners and jobs (if you create a maintenance plan and then disable the account you were logged in as, the plan's job's owner will snap back to the disabled login each time you alter the plan). Found the solution already, but is it worth posting and answering my own question about it?
Also why the hell did they have anyone working alone on their batch processing. Shit, we do two-man check-and-test and the worst that'll happen if our system falls over is exam results being delayed a couple of days
I remember my aunt that worked in a phone company, inputing phone-bills (or something), many years ago, saying that all was processed twice, by different operators, to catch human errors.
And that was a trivial task.
I can imagine what would happen in another situation; "Obama: Oops, I pressed that red button"
@ypercube I did a search on Jobserve for Python last night and the number of jobs and salries on offer showed a definite uptick from what I'd last seen. If you don't mind working for merchant bankers you might get some mileage from hunting around for jobs in that space.
@SimonRigharts Most pros in that industry are getting so old and crusty that the yanks have apparently more or less lost the ability to design new ones. I wonder just how good their processes really are.
It's pretty hard to make subcritical warheads go off. One of the security mechanisms on at least some models of warhead is they machine the fissile material and the explosive lenses to a precise shape so you have to set all of the charges off in exactly the right sequence with the right timing to get it to go off.
yeah, you can make a subcritical mass of fissile material critical by using explosives to compress it, but if even one of the explosive blocks is a dud, or goes off a millisecond too early, then you land up with a conventional explosion (with dirty fallout)
I did some study of nuclear warheads at university as part of physics papers
It not actually a problem that i'm facing. But i'm just wondering that the first
line in the code written below should be treated as a syntax error by SQL Server because of the extra comma (,) in the end of columns list. But it runs the code fine. Does anyone know the reason?
CREATE TABLE #TEMP...
If @JakeFeasal is online, or anyone else who knows about SQL fiddle, what is this error? "Component [models.Schema_Def] has no acessible Member with name [STRUCTURE_JSON]"
So what on earth do I name a column that represents the number of business days before an event that a reminder should be sent? I can't think of anything that isn't overly long....
I think my brain is telling me to stop working already
Is this being generically stored because you don't know the actual event date yet? If you know the event date I would rather store the reminder date than the reminder period.
If you calculate the # of business days to come up with the date, or you store the # of business days and calculate the date later, how would it be different?
You need to take holidays into account in both cases. (And for this you should have a calendar table.)
This is my update statement which works perfectly. If table 1 and table 2 contain an equal serial number then table 1 is updated with a yes and if it doesnt then it is updated with a no.
UPDATE dbo.table1
SET [Match] = CASE WHEN dbo.table2.[Serial Number] IS NOT NULL
THEN 'yes' ELSE 'no' END
FRO...
@AaronBertrand He seems to be good at copying something and pass it off as his:
yes SQL-Server accepts it.When executing the CREATE TABLE command, a trailing comma following the last column is allowed. Based on the grammar in BOL and comma usage in lists in other T-SQL statements, this behavior is inconsistent. This is a very minor issue and does not appear to cause any adverse side-effects. It just appears that the parser may be a bit off. I'm not sure if the behavior occurs in any other DDL statements as I only noticed it by happenstance when commenting out a constraint in some code — Ram Singh3 hours ago
@ypercube chat history is logged and searchable until a room is frozen for inactivity (at least I think normal users can't see those), the room is deleted, or the messages are deleted by moderators/the posting user
@AaronBertrand great, you've made me waste one of my precious SO reps to downvote
Okay, so this guy copied my code verbatim, 6 minutes after I had posted my answer. And he got the accept. He added a sentence above the code sample, which I neglected to do.
But the fact that he copied the code from my answer is indisputable - it is identical right down to table aliases, whites...
I have a table defined in the following way:
CREATE TABLE [dbo].[MyTable]
(
[MyTable_ID] [int] IDENTITY(1,1) NOT NULL,
[COLUMN_WITH_DATA] [varchar](128) NOT NULL,
[COLUMN_A] [varchar](128) NULL,
[COLUMN_B] [varchar](128) NULL,
[COLUMN_C] [bit] NOT NULL
)
And an index created lik...
it was a joke. just ramping up out here. headaches and allergic reactions. and now i have to present a compelling case against slapping McAfee on our SQL Servers
Some days it doesn't seem worth it and I just want to say, "go for it, I'll be here to tell you 'I told you so.'" But I'd still be stuck with the fallout/cleanup, so that's not really a good strategy
Okay, so this guy copied my code verbatim, 6 minutes after I had posted my answer. And he got the accept. He added a sentence above the code sample, which I neglected to do.
But the fact that he copied the code from my answer is indisputable - it is identical right down to table aliases, whites...
I'd never take less than 5 downvotes to mean very much on Meta (much like less than 2 is meaningless on the main site usually). People downvote anything, or they could just not like you, ect
I find the grace period can lend itself to some unscrupulous behavior on popular tags. I've often seen an earlier, minimalist answer be updated within the first 5 minutes, and incorporate something mentioned in a later answer (also in its first 5 minutes, obviously) or expanded upon immensely. It...
This is my update statement which works perfectly. If table 1 and table 2 contain an equal serial number then table 1 is updated with a yes and if it doesnt then it is updated with a no.
UPDATE dbo.table1
SET [Match] = CASE WHEN dbo.table2.[Serial Number] IS NOT NULL
THEN 'yes' ELSE 'no' END
FRO...
Actually a mod deleted that answer by Ram, so you may not all be able to see it anymore.
It was a link-only answer, copied from another answer from half an hour earlier that had better context. Ram got the accept, and someone pointed out that Ram and the OP live 3 miles apart.
@AaronBertrand That's interesting. So, If you downvoted 4 answers today, and on your rep tab says that you have 173 today, and if I sum the rep detail it does add to that, then you actually made 173 - 4 rep today?
I've noticed that if I downvote an answer, the record of the downvote is visible to me in my profile. But when I view my profile from another browser that's not logged into Stack Overflow, I've noticed that I don't see the record of the downvote.
So I was wondering if the downvote record is vis...
You shouldn't see the rep changes from my down-votes or corrections because of those posts being removed. Just up-votes and down-votes on my questions/answers.
I would recommend that you calculate BLA taking that condition in consideration. But, another way is just using your current query as a derived table and use a CASE:
SELECT SUM(Jan) Jan,
SUM(Feb) Feb,
SUM(Mar) Mar,
SUM(Apr) Apr,
SUM(May) May,
SUM(Jun) Jun...
but I remember @AaronBertrand said that nobody has make it big on SO without having aptem as a stalker
my query is returning:
+------+------+------+------+------+------+------+-------+------+------+------+------+-----+
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Bla |
+------+------+------+------+------+------+------+-------+------+------+------+------+-...
I am going on a job interview and have zero experience with MS SQL Server. However I have 1 year with Oracle. Is there such a huge difference between the two? What programming questions can I expect?
You can use a numbers table or some table that has all values from 1 to 192. You can create that table, make one on the go using a loop or a recursive CTE, using some of the system views, etc. This is one example:
SELECT ISNULL(SUM(Jan),0) Jan,
ISNULL(SUM(Feb),0) Feb,
ISNULL(SUM...
If you have multiple instances of SQL Server, no. The only reason would be if you're developing apps that need to support SQL Express, that's the best way to make sure you don't use features not supported there.
how can I see what apps are using this Sql Server instance before I remove it? I suppose the better thing to do is to just stop the service for a week or two and see what freaks out huh?
... aaaand more on RBS (or should that be moron) from The Register: http://www.theregister.co.uk/2012/06/28/rbs_job_cuts_and_offshoring_software_glitch/
@ConcernedOfTunbridgeWells Was the outage because of outsourcing? Do I read correctly that there was a team on the batch system that was let go? Or did they just all retire/leave and there was no competency to backfill?
@swasheck RBS are going to great pains to tell us that the outsourcing programme had nothing to do with the outage. This is probably a big clue that suggests that the work was cocked up by one of the people working for the 'outsourcing partner'.
Outsourcing has gotten trendy in the square mile all of a sudden, just in the past few years. I've seen a few of the results of that up close and it's not a pretty sight.
That's the most frustrating thing about things I read. "You did a really CRAPPY job. You've run our company into the ground. Go away. Here's $4 million for your ineptitude."
Jon Skeet upvoted my meta question. Isn't that worth +500 or something?
I'd like this to apply to the question, as well as answers. Sometimes I (or others) have added perfectly good answers, but then the question has been changed within the grace period, making answers look foolish without any indication of what's happened. — Jon Skeet2 mins ago
@swasheck I used to work as a typesetter back in the late jurassic period, but I'm a crap graphic designer. Pretty much a talent-free zone.
One lady I used to work with about 20 years ago was an amazing finished artist. I saw some of her portfolio work. One thing she had was a mock up of a cigarette packet that she'd painted by hand. It was detailed right down to the typeface of the small print on the packet. She'd rendered it so well you could tell what the typeface was on something that was meant to be about 10 point.
So we are migrating from Informix to Sql Server. And I have noticed that in Informix the queries are written in this manner:
select [col1],[col2],[col3],[col4],[col5]
from tableA, tableB
where tableA.[col1] = table.[gustavs_custom_chrome_id]
Whereas all the queries I write in SQL Server are wr...
Here is an example. `CREATE TABLE HereAreMyQueries(Query VARCHAR(MAX))
INSERT INTO HereAreMyQueries VALUES ('SELECT 1 AS A'), ('SELECT GETDATE() AS B')
DECLARE @Query VARCHAR(MAX) DECLARE Queries CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY FOR SELECT Query FROM HereAreMyQueries
OPEN Queries FETCH NEXT FROM Queries INTO @Query WHILE @@FETCH_STATUS = 0 BEGIN EXEC(@Query) FETCH NEXT FROM Queries INTO @Query END CLOSE Queries DEALLOCATE Queries `
Sorry, for some reason sqlfiddle is not working for me
You can also use the quirky update to generate a monster EXEC: SELECT @Query = COALESCE(@Query, '') + Query + CHR(13) + CHR(10) + 'GO' + CHR(13) + CHR(10) FROM HereAreMyQueries EXEC (@Query)
Obvious drawback there of the giant string - note that you cannot PRINT giant varchar variables or columns in SQL Server (unless they fixed this in 2012) - they will EXEC larger than they can print.
@Lamak Make a new answer on the same question, you'll be able to get votes from the same people who voted up your earlier answer to the original question. Even though the questioner should have asked a different question, you can still get credit. Not that it's all about the rep, but anyway.
@Lamak Flag it - this guy has been a bozo for a while now
@Lamak Reply with "Would you be so kind as to put this in a separate question since you've changed it so much as to not be able to modify my answer on your own and you will confuse later users of this site."
@Lamak He doesn't really have a point about being a duplicate - if the question was really that close, he should be able to use a modified version of your answer. It kills me when they get a spoonfed answer and then can't modify it because they don't really put any effort into understanding how and why the solution works.
@jcolebrand Thanks, I was about to ask if the proper thing to do once he reaccepted my answer was to do a rollback on the question, since the answer wouldn't have made sense
@АртёмЦарионов - This broaches the topic of knowing what you are asking. Take some time to think through your questions and use them as potential learning experiences and not one-off, symptomatic fixes. — swasheck6 mins ago
The term bozo bit has been used in two contexts. Initially a weak copy protection system in the 1980s Apple Macintosh Operating System, the term "flipping the bozo bit" was later reused to describe a decision to ignore a person's input.
Weak copy protection
In early versions of Apple's Macintosh Operating System, the "bozo bit" was one of the flags in the Finder Information Record (also called the "no copy" flag in some documentation), which described various file attributes. When the bit was set, the file could not be copied. It was called the bozo bit because it was copy protection so we...
@АртёмЦарионов - I'm sorry to say this, and I don't mean any offense. But if you really think that your new question would be closed as a duplicate, then that's a symptom of your lack of an effort on adapting the answers you have at your dispossal. You should be able to use a modified version of the answer I had provided without the need to change the question. — Lamak2 mins ago
I used to mess around with DBCC INDEXDEFRAG and even ALTER INDEX REBUILD. Then someone turned me on to Diskeeper. I just installed it on the server and never had to deal with this again - checked off my list man.
Seems pretty simple to me, but just my 3 cents :-)
-Peter
this is Oracle 10gr2 on aix 6100-02
The issue is that I do not manage to see the € sign from Oracle.
This is an easy way to see the issue:
SQL> insert into prueba values ('€');
SQL> commit;
SQL> select * from prueba;
EURO
------------------------------------------------------------
¿
...
It not actually a problem that i'm facing. But i'm just wondering that the first
line in the code written below should be treated as a syntax error by SQL Server because of the extra comma (,) in the end of columns list. But it runs the code fine. Does anyone know the reason?
CREATE TABLE #TEMP...
I have a table defined in the following way:
CREATE TABLE [dbo].[MyTable]
(
[MyTable_ID] [int] IDENTITY(1,1) NOT NULL,
[COLUMN_WITH_DATA] [varchar](128) NOT NULL,
[COLUMN_A] [varchar](128) NULL,
[COLUMN_B] [varchar](128) NULL,
[COLUMN_C] [bit] NOT NULL
)
And an index created lik...
I would recommend that you calculate BLA taking that condition in consideration. But, another way is just using your current query as a derived table and use a CASE:
SELECT SUM(Jan) Jan,
SUM(Feb) Feb,
SUM(Mar) Mar,
SUM(Apr) Apr,
SUM(May) May,
SUM(Jun) Jun...
my query is returning:
+------+------+------+------+------+------+------+-------+------+------+------+------+-----+
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Bla |
+------+------+------+------+------+------+------+-------+------+------+------+------+-...
So we are migrating from Informix to Sql Server. And I have noticed that in Informix the queries are written in this manner:
select [col1],[col2],[col3],[col4],[col5]
from tableA, tableB
where tableA.[col1] = table.[gustavs_custom_chrome_id]
Whereas all the queries I write in SQL Server are wr...
I used to mess around with DBCC INDEXDEFRAG and even ALTER INDEX REBUILD. Then someone turned me on to Diskeeper. I just installed it on the server and never had to deal with this again - checked off my list man.
Seems pretty simple to me, but just my 3 cents :-)
-Peter
