I have a Sql Server logging table, that continuously is being inserted into, I want to revise the design of this table.  Currently, we are using a GUID as the PK,  because the software can generate this and we just insert it, and hopefully, multiple inserts won't block each other. However, UniqueId is not a very efficient PK for a table and our indexes are very large and fragmented.  If I change this column to a long with auto-increment enabled.  Will this become a concurrent insert bottleneck?  I do not need my primary key to be in any sort of order, Just a unique id for that row?
Our company would like to understand the effects:   If we have single table with Primary Key Identity column, int primary key IDENTITY(1,1),  and the Application is conducting multi-threading parallel processing, trying to conducts 1000s of simultaneous inserts on one table.   Would the identity primary key column fail, with a primary key violation in any way, for example: processors are trying to input the same identity number?  Or was SQL designed to be successful even in multithreading parallel insert?  Note: IDENTITY_INSERT is OFF
Einstein's first postulate implies the second? How to get the ASCII value of a character Create any number of paragraph fields in a multiple value field on node create form I have a paragraphs field that takes a term reference.  I need to count how many terms there are for a specific vocabulary and then create that many instance of the paragraphs multiple value field for when creating a node of a certain type. Can this be done with Hook_form_alter ?  It is important that these fields are loaded when the node creation form is loaded rather than the user having to click add more  Any help would be greatly appreciated  I have tried this but when saving the node it doesn't save the new fields  function hook_form_alter(&amp;$form, $form_state, $form_id) {    if ($form_id == 'my_form') {    $item = $form['field_features']['widget']['0'];    // get taxonomy terms   $query = \Drupal::entityQuery('taxonomy_term');   $query-&gt;condition('vid', "my_voc");   $tids = $query-&gt;execute();   $terms = \Drupal\taxonomy\Entity\Term::loadMultiple($tids);    $count = count($terms);    $i = '1';   foreach($terms as $term){     $form['field_features_para']['widget'][$i] = $item;     $form['field_features_para']['widget'][$i]['#delta'] = $i;     $form['field_features_para']['widget'][$i]['#weight'] = $i;     $i ++;   }  } } Check if table exists in SQL Server I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements.  When you Google for the answer, you get so many different answers. Is there an official/backward and forward compatible way of doing it?  Here are two possible ways of doing it. Which one among the two is the standard/best way of doing it?  First way:  IF EXISTS (SELECT 1             FROM INFORMATION_SCHEMA.TABLES             WHERE TABLE_TYPE='BASE TABLE'             AND TABLE_NAME='mytablename')     SELECT 1 AS res ELSE SELECT 0 AS res;   Second way:  IF OBJECT_ID (N'mytablename', N'U') IS NOT NULL     SELECT 1 AS res ELSE SELECT 0 AS res;   MySQL provides the simple   SHOW TABLES LIKE '%tablename%';    statement. I am looking for something similar. What is the best way to replace the file browse button in html? I know that it's possible to replace the browse button, which is generated in html, when you use input tag with type="file.  I'm not sure what is the best way, so if someone has experience with this please contribute. Does someone know if the following is true:  Let $\mathbb{X}$ be some arbitrary Banach space. $\{x_k \}_{k=1}^{\infty} \in \mathbb{X}$ is a sequence chosen from $\mathbb{X}$.  Now, if the series  $$\sum_{k=1}^\infty \|x_k\|_X$$ converges, would the "more generic" series $$\sum_{k=1}^\infty x_k$$  also converge?  If yes, could you please give the proof (or just mark the proof steps) ?  Thank you. I have a button created by my script. I wonder how I can display what the system console displays but inside blender's console. CoDEmanX did this by running a script inside it as shown , but I want to display what happens in the system console inside blender's console.  My .blend file can be found here: I have hundreds of excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 all singing and dancing file which must have the same format as the originals (i.e. maintain the four separate worksheets, which are all identically named).  While each file is structured the same, the number of columns (and the heading names) between sheet 1 and 2 (for example) is different. So it can’t be combined into one file with everything in one sheet!  There are two complications:   I need to create an EXTRA column in the merged file (on EACH sheet) to identify the source file (“file name”). The files contain a lot of zero data entries (e.g. 55 rows of useful data followed by hundreds of rows of zeros) which I need to remove from the merged file.   I’ve never used VBA, but everyone has to start somewhere I suppose. When a user votes to close a question (for whatever reason), it would helpful to receive a notification (in the inbox) when the question is edited (either the text, tags, if it closes then is re-opened) so that the user can then modify his or her vote if the question is properly adjusted. In HP-UX server, grep -r option is not working In unix server grep -r option is not working. OS is HP-UX.  If grep -r is not working any alternative way to do recursive search without -r option? What are the fundamental differences between the mainstream *NIX shells and what scenarios might prompt you to use one over the other?  I understand that some of it probably comes down to user preference but I've only ever used Bash and I'm interested to hear where another shell might be useful. Also, is there an impact on user-written shell scripts when running under one shell or another or is it simply a matter of changing the shell at the top of the file?  My instinct says it's not that easy. Does a polymorphed creature remember who his friends are? When I try to save a new file in TextEdit, I always get a popup saying I can't save with ".txt" at the end of the file name.  I want to save a plaintext file, but TextEdit insists on saving as .rtf instead. It also lists .doc, .odt, .html, and some others.  How can I save a TextEdit document as plain text? Unable to load DLL (Module could not be found HRESULT: 0x8007007E) Polygon label repeated for each tile On June 13th 2017 all SharePoint calculated columns with HTML markup stopped working.   Basically the fields now render text (regardless of setting the data type to number). The gist of the notice from Microsoft () is:     In Microsoft SharePoint lists and libraries, calculated fields that   are running in the classic UI mode can be used to display results   based on Excel-like formulas. This is a long standing capability, and   is documented in Calculate data in lists or libraries.      Some users have added HTML markup or script elements to calculated   fields. This is an undocumented use of the feature, and we will begin   blocking execution of custom markup in calculated fields in SharePoint   Online from June 13, 2017 onwards. We are also providing this as a   configurable option for on-premises in SharePoint Server 2016 and   SharePoint Server 2013 via the June 2017 and subsequent Public   Updates.   As we don't have on premise SharePoint (online), we have to find an immediate work around, given that this impacts our processes and thus, business.   Is anyone aware of third party applications that will allow for HTML, script markup (that works with SP online)? Are the tags shown in a particular order? I noticed that, sometimes, the tags I add to a question are not shown in the same order I wrote them, when the question is saved. Are they shown in a particular order? If they are, in which order they are shown? How can I recover a game center account where I forgot ID and password? A long time ago, I made a game center account to which I attached my CoC village. This account hasn't been used anymore, and I have forgotten the ID and the password.  Now I want to transfer that game to my new phone which has a new game center ID, but need a transfer code from the old account to do so. Is there a way to recover my old game center account details? Show that $a^{61} \equiv a\pmod{1001}$ for every $a \in \mathbb{N}$ Does addition imply an order? Consider any integer, suppose a number 3. We can break any such integer down into a sequence of 1's. So, we can write: $$ 3\equiv1+1+1 $$ 3 represents what we get when we add 1 to 1 to another 1. Conceptually, what I am getting confused with, is the fact that notionally, at least according to this definition, there is one unit at the beginning, to which we add another, and yet a third. There seems to be a sequence here, which would imply there being an order. Am I missing something obvious?