@PaulWhite I've modified my answer, and hopefully, incorporated all the salient points. Thanks again for the discussion - I know your time is very valuable.
You may be able to reduce index rebuild/reorg times by moving to NEWSEQUENTIALID().
You are currently inserting around 4,500 rows into the table per day. The table has around 6.3 million rows at present. That's around 0.7% of the table per day. Assuming every insert on the table results in an...
Is there a way to start a stored procedure that has been configured for automatic startup via sp_procoption without having to restart SQL Server?
Occasionally I'll need to make an adjustment and have to KILL the running session to do so, but I cannot seem to locate a way to turn it back on agai...
To me it seems in the grey area but I wonder if our dear experts have an alternative to what Damien suspects is the only way and if they'd be more persuaded to post an answer if the question was on DBA.
Based on theese questions and the answers given:
SQL 2008 Server - performance loss possibly connected with a very large table
Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
I have a table in a database SupervisionP def...
@ypercube It's a rather sad limitation. The optimizer doesn't generate an index union strategy for disjunctions by default. It can do this if FORCESEEK is used, but not if the index forced is the clustered index.
Actually it might require two different indexes, I forget the details offhand.
Not sure how to write a clear question but I really struggle with bulk importing a InnoDB Table with ~10 million rows (~ 7GB). I did some research about various options inno_buffer_* but then again testing is very time intense and I feel I'm missing some clear direction to move ;C
In the moment I use different dumps with n million rows and stop time importing but also dropping the database takes > 1hour so yes - testing process becomes very slow
Hmm... afaik InnoDB has better support for FK keys (or generally has supoort as opposed to MyISAM) - have you ever done something like this? I wonder if I would lose information then
@ypercube The CHANGE ENGINE -command (have to google it) just wondering how well conversion works. Anyway I will surely try it out after my DROP TABLE statement has finished (1h and counting ^^)
@PaulWhite Perspective :) But yes why not - I'm phrasing a question atm
in those scenarios it's not mission critical that you see Aunt Alice's casserole recipe right away
for business use relational databases are usually a better fit because it DOES matter if you are looking at the most recent version of the accounts table
@JNK big data is more than a buzzword, it's a highly subjective concept that is loosely translated, "i'm pushing the limits of my experience/competence in tuning this thing."
@Marian: Yes I actually do. As a minimal precaution I try to avoid excessive i/O operation (where possible…) not sure how it would be on our dev sever but for my working notebook ... you think external hard disk could speed up.
@swasheck Of course they do 8) Actualyl we try to get officially recognised by UN so we could live from tourism and taxes instead of writing code (these human keyboards are hard to use with dinosaur pawns :3 )
@yoshi single encrypted notebook disk? I'd reckon that's your bottleneck. That hybrid (ssd) part is not really useful for bulk writes.. so you're actually reading/writing on a slow disk.
Yes, not a big fan of encryption either but my boss has made it mandatory. The very specific table in question contains some not-exactly-uninteresting data about various people and their political views so I can understand they dislike the idea of having some dump getting lost in the wilderness ~ which I must confess is quite likely in my life :D
@PaulWhite ... OPTION (QUERYTRACEON 2312); causes SQL Sentry Plan Explorer to timeout before collecting a plan. THOSE are the kinds of queries with which I'm working
So I guess that's also why our server are not best thing money can buy. I was thinking even though I might optimise import speed and can archive some data table will still grow and the problem with a backup server remains (to get it ready in short time).
So i wonder if there's something like incremental backups … ? more like an idea but if someone could suggest in which direction to dig
Is there a formal/academic name for the family of functions in Sql Server like ROW_NUMBER(), LAG, LEAD, RANK etc, that make use of the OVER(ORDER BY <PARTITION BY> ) syntax? How much of this is covered by the ansi standard?
I can see on MSDN that some of those are listed as analytic functions, b...
> Window functions A window function is a function whose result for a given row is derived from the window frame of that row as defined by a window structure descriptor of a windowed table. Window functions may only appear in the <select list> of a <query specification> or <select statement: single row>, or the <order by clause> simply contained in a <query expression> that is a simple table query.
> A window function is one of: — A rank function. — A distribution function. — The row number function. — A window aggregate function. — The ntile function. — The lead function. — The lag function. — The first-value function. — The last-value function. — The nth-value function.
Can someone please assist me with a website to download microsoft certification dumps. I was checking the website www.braindumps.com but they do not seem to offer the actuall exam questions
Thanks
hello hello, i am searching for one of my question in stackoverflow. Question is related to sql information_schema about retrieving table, column and other details. I had answers posted. This was sometime 3-4 months ago. I couldn't find my own posting. Whether my question got deleted or how should i able to retrieve my question ?
@ypercube Import is no dobut faster with MyISAM problem comes when changing engine back to InnoDB. However answers have pointed out the keys might be a problem. Thanks again for you help!
yes... well... sounds like much, not? ^^; Sorry for confusion - I'm quite new to this "big data" stuff :> (read: I haven't designed the database nor do I [after 4 weeks] know why one would do that + the sheer amount is kinda blasting me)
@MikeFal @bluefeet exactly. it's like @billinkc told me, "nobody's done the research you've done. nobody's done the work you've done. they're there to learn from that."
The last slide of your presentation should sum up ALL its key points.Like this one, from our company-wide town hall: http://twitter.com/StackExchange/status/494537484093489153/photo/1
We are building a database for a website which is related to the farmers land certification and storing the related data.
Table : farmer_detail(id,name,address...) we store farmers details who register their land. After that there is a form which is as below:
Sl_no Details of operation ...
what's a "Hard Page Fault" in Windows? i tried reading about it and i think i'm not quite sure. basically, it's a memory page that Windows doesnt have available so it has to go get more?
You may be able to reduce index rebuild/reorg times by moving to NEWSEQUENTIALID().
You are currently inserting around 4,500 rows into the table per day. The table has around 6.3 million rows at present. That's around 0.7% of the table per day. Assuming every insert on the table results in an...
Is there a way to start a stored procedure that has been configured for automatic startup via sp_procoption without having to restart SQL Server?
Occasionally I'll need to make an adjustment and have to KILL the running session to do so, but I cannot seem to locate a way to turn it back on agai...
Based on theese questions and the answers given:
SQL 2008 Server - performance loss possibly connected with a very large table
Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
I have a table in a database SupervisionP def...
hi i want display money as 12Lc or 2Cr
if money =1200000 as 12 Lc
when 12000000 as 1.2 Cr
how can i do this help me guys
Can someone please assist me with a website to download microsoft certification dumps. I was checking the website www.braindumps.com but they do not seem to offer the actuall exam questions
Thanks
We are building a database for a website which is related to the farmers land certification and storing the related data.
Table : farmer_detail(id,name,address...) we store farmers details who register their land. After that there is a form which is as below:
Sl_no Details of operation ...
