I am having some difficulties while inserting a text file automatically into a MySQL database.
What is Stack Overflow's long-term solution for the Help Vampire problem?
Quote from article follows:
Identifying Help Vampires can be tricky, because they look like any ordinary person (or Internet user, whichever is lesser). But by closely observing an individual's behavior using this hand...
I'm a MongoDB noob and trying to import data from an Oracle table.
My Oracle table has 1 unique index on a single column, which is an id (a number - primary key).
I successfuly imported data to MongoDB and added a unique index on the same column, so as to have the 'same' structure.
Now, when I...
I have created a small test for checking this:
CREATE TABLE jsonb_test (id serial, data jsonb);
Then inserted some generated data:
INSERT INTO jsonb_test (data)
SELECT row_to_json(x.*)::jsonb
FROM (SELECT i AS bla,
ARRAY[i, i+1, i+2] AS foo,
ARRAY[('v' || ...
Check out the SQL Server Setup Checklist from Brent Ozar. Section 4.1 covers drive formatting and block sizes.
SQL Server Setup Checklist from BrentOzar.com
This is my linux version
Linux ArRac1 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
I'm trying to install MariaDB from this link using the RPMs since I do not have internet access
http://mariadb.biz.net.id/mariadb-10.0.21/yum/rhel6-x86/rpms/
Since I ...
First of all I agree completely with Aaron Bertrand when he suggested in the comments you move the SQL into a stored procedure. This is also the clear winner as far as "the proper way to wrap a set of SQL operations in a .NET program" by the way.
Since you're worried about managing code in two p...
This is my post, but I must have accidently submitted as a guest, and I don't have enough points to comment on my own post so I am replying here.
When I enter your command I get:
]$ cat /etc/passwd | sed 's/^([^:]):.$/crontab -u \1 -l 2>\&1/' | grep -v "no crontab for" | sh
sed: -e expression ...
we have a very old Oracle 8.0.5.0.0 database here that - unfortunately - is still used heavily as every day production system.
I want to start making plans on how to get this DB upgrade to a recent Oracle 12c.
Unfortunately, both DB versions don't seem to be able to talk to each other anymore (...
Very simply...
Comment out the WHERE clause in these two views:
SSISDB.catalog.executions
SSISDB.catalog.event_messages
Done.
Change the view catalog.event_messages by commenting out the WHERE clause:
--WHERE opmsg.[operation_id] in (SELECT [id] FROM [internal].
--[current_user_readable_op...
I just came across an interesting user who has more gold badges than most top 20 users. The low reputation of below 10,000 made me wonder how that's possible. I found out that he's continuously spending his reputation on bounties.
Would someone mind building a SEDE query that allows us to find t...
Just working from Paul's comment. The key difference in the statement in Books Online and your interpretation:
It says: ...one row per cached stored procedure plan.
You read: ...one row per cached stored procedure.
You can check which plan attributes are different and leading to differ...
I agree with Hector's assessment. It will probably be more flexible just to keep your original design. The piece that you might have missed to make it work is using recursion to traverse up the tree. I don't know much about recursion in MySQL, but this answer on StackOverflow feels like a good r...
