I use

PK_ for primary keys

UK_ for unique keys

IX_ for non clustered non unique indexes

UX_ for unique indexes

All of my index name take the form of  
`&lt;index or key type&gt;_&lt;table name&gt;_&lt;column 1&gt;_&lt;column 2&gt;_&lt;column n&gt;`


I usually name indexes by the name of the table and the columns they contain:

    ix_tablename_col1_col2

Is it worth a special prefix for indices associated with foreign keys?  I think so, since it reminds me that indices on foreign keys are not created by default, and so it is easier to see if they are missing.

For this, I am using names that match the name of the foreign key:

    FK_[table]_[foreign_key_table]

or, where multiple foreign keys exist on the same table

    FK_[table]_[foreign_key_table]_[foreign_key_field]

I know a old topic but thought I&#39;d throw in my 2cents worth

 - PKC_      Primary Key, Clustered
 - PKNC_     Primary Key, Non Clusterd
 - NCAK_     Non Clustered, Unique
 - CAK_      Clustered, Unique
 - NC_       Non Clustered


Example;

NCAK_AccountHeader_OrganisationID_NextDate 

 Where NCAK : Non Clustered, Unique, AccountHeader : Table and OrganisationID_NextDate : Columns. 

Lets say I have the following JavaScript:

    var obj = {
     key1 : &quot;it &quot;,
     key2 : key1 + &quot; works!&quot;
    };
    alert(obj.key2);

This errors with &quot;key1 is not defined&quot;. I have tried 

    this.key1
    this[key1]
    obj.key1
    obj[key1]
    this[&quot;key1&quot;]
    obj[&quot;key1&quot;]

and they never seem to be defined.

How can I get key2 to refer to key1&#39;s value?

How can a JavaScript object refer to values in itself?

How do I create an **unmodified** hex dump of a binary file in Linux using bash? The `od` and `hexdump` commands both insert spaces in the dump and this is not ideal.

Is there a way to simply write a long string with all the hex characters, minus spaces or newlines in the output?

How to create a hex dump of file containing only the hex characters without spaces in bash?

Is there some standard way to name indexes for SQL Server?  It seems that the primary key index is named PK_&lt;tablename&gt; and non-clustered indexes typically start with IX_&lt;tablename&gt;.  Are there any naming conventions beyond that for unique indexes?

SQL Server Index Naming Conventions

<p>Is there some standard way to name indexes for SQL Server?  It seems that the primary key index is named PK_<tablename> and non-clustered indexes typically start with IX_<tablename>.  Are there any naming conventions beyond that for unique indexes?</tablename></tablename></p>


Im trying to get the value from BrandID in one table and add it to another table. But I can&#39;t get it to work. Anybody know how to do it right?

    CREATE PROCEDURE AddBrand
    AS
    
    DECLARE 
    @BrandName nvarchar(50),
    @CategoryID int,
    @BrandID int
    
    SELECT @BrandID = BrandID FROM tblBrand 
    WHERE BrandName = @BrandName

    INSERT INTO tblBrandinCategory (CategoryID, BrandID) 
           VALUES (@CategoryID, @BrandID) 
    
    RETURN

How to declare a variable in SQL Server and use it in the same Stored Procedure

I need to be able to store small bits of data (approximately 50-75 bytes) for billions of records (~3 billion/month for a year).

The only requirement is fast inserts and fast lookups for all records with the same GUID and the ability to access the data store from .net.

I&#39;m a SQL server guy and I think SQL Server *can* do this, but with all the talk about BigTable, CouchDB, and other nosql solutions, it&#39;s sounding more and more like an alternative to a traditional RDBS may be best due to optimizations for distributed queries and scaling. I tried cassandra and the .net libraries don&#39;t currently compile or are all *subject to change* (along with cassandra itself).

I&#39;ve looked into many nosql data stores available, but can&#39;t find one that meets my needs as a robust production-ready platform. 

If you had to store 36 billion small, flat records so that they&#39;re accessible from .net, what would choose and why?

Best data store for billions of rows

I&#39;m creating an SQL setup script and I&#39;m using someone else&#39;s script as an example.  Here&#39;s an example of the script:

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[be_Categories](
    	[CategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Categories_CategoryID]  DEFAULT (newid()),
    	[CategoryName] [nvarchar](50) NULL,
    	[Description] [nvarchar](200) NULL,
    	[ParentID] [uniqueidentifier] NULL,
     CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED 
    (
    	[CategoryID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO

Does anyone know what the ON [PRIMARY] command does?

What does ON [PRIMARY] mean?

I know this is almost a duplicate of : https://stackoverflow.com/questions/1269706/the-error-login-failed-for-user-nt-authority-iusr-in-asp-net-and-sql-server-2 and https://stackoverflow.com/questions/97594/login-failed-for-user-username-system-data-sqlclient-sqlexception-with-linq-i but some things don&#39;t add up compared to other appliations on my server and I am not sure why.

**Boxes being used:**

Web Box  
SQL Box  
SQL Test Box

**My Application:**

I have an ASP.NET Web Application, which references a class library that uses LINQ-to-SQL. Connection string set up properly in the class library. As per https://stackoverflow.com/questions/97594/login-failed-for-user-username-system-data-sqlclient-sqlexception-with-linq-i I also added this connection string to the Web Application. 

The connection string uses SQL credentials as so (in both web app and class library):

     &lt;add name=&quot;Namespace.My.MySettings.ConnectionStringProduction&quot;
            connectionString=&quot;Data Source=(SQL Test Box);Initial Catalog=(db name);Persist Security Info=True;User ID=ID;Password=Password&quot;
            providerName=&quot;System.Data.SqlClient&quot; /&gt;

This connection confirmed as working via adding it to Server Explorer. This is the connection string my .dbml file is using.

**The problem:**

I get the following error:

    System.Data.SqlClient.SqlException: Login failed for user &#39;DOMAIN\MACHINENAME$&#39;.

Now referencing this https://stackoverflow.com/questions/1269706/the-error-login-failed-for-user-nt-authority-iusr-in-asp-net-and-sql-server-2 it says that&#39;s really the local network service and using any other non-domain name will not work. 

But I am confused because I&#39;ve checked both SQL Box and SQL Test Box SQL Management Studio and both have `NT AUTHORITY/NETWORK SERVICE` under Security -&gt; Logins, at the database level, that isn&#39;t listed under Security -&gt; Users, but at the database level Security -&gt; Users I have the user displayed in the connection string.

At NTFS level on web server, the permissions have NETWORK SERVICE has full control.

The reason why I am confused is because I have many other web applications on my Web Server, that reference databases on both SQL Box and SQL Test Box, and they all work. But I cannot find a difference between them and my current application, other than I am using a class library. Will that matter? Checking NTFS permissions, setup of Security Logins at the server and databases levels, connection string and method of connecting (SQL Server credentials), and IIS application pool and other folder options, are all the same.

Why do these applications work without adding the machinename$ to the permissions of either of my SQL boxes? But that is what the one link is telling me to do to fix this problem.


Login failed for user &#39;DOMAIN\MACHINENAME$&#39;

How do you get the 30 days before today in SQL.

how to get the 30 days before date from Todays Date

How do you name different classes / interfaces you create?
Sometimes I don&#39;t have implementation information to add to the implementation name - like interface `FileHandler` and class `SqlFileHandler`.

When this happens I usually name the interface in the &quot;normal&quot; name, like `Truck` and name the actual class `TruckClass`. 

How do you name interfaces and classes in this regard?

Java Interfaces/Implementation naming convention

I&#39;m trying to put together a really simple module with one .py source file in it, and have already run into a roadblock. I was going to call it `scons-config` but `import scons-config` doesn&#39;t work in Python. I found [this SO question][1] and looked at [PEP8 style guide][2] but am kind of bewildered, it doesn&#39;t talk about two-word-name conventions.

What&#39;s the right way to deal with this?

* module name: SconsConfig? scons_config? sconsconfig? scons.config?
* name of the single .py file in it: scons-config.py? scons_config.py?

**edit:** I did see &quot;the use of underscores is discouraged&quot; and that left me at a dead end: should I use &quot;sconsconfig&quot; or &quot;scons_config&quot; (I guess the other ones are out)?

  [1]: https://stackoverflow.com/questions/711884/python-naming-conventions-for-modules
  [2]: http://www.python.org/dev/peps/pep-0008/

python: naming a module that has a two-word name

I try to adhere to the style guide for Python code (also known as [PEP 8][1]). Accordingly, the preferred way to name a class is using CamelCase:

&gt;  Almost without exception, class names
&gt; use the CapWords convention. Classes for internal use have a leading underscore in addition.

How can I be consistent with PEP 8 if my class name is formed by two acronyms (which in proper English should be capitalized). For instance, if my class name was &#39;NASA JPL&#39;, what would you name it?:

    class NASAJPL():  # 1
    class NASA_JPL(): # 2
    class NasaJpl():  # 3

I am using #1, but it looks weird; #3 looks weird too, and #2 seems to violate PEP 8. 

  [1]: http://www.python.org/dev/peps/pep-0008/

How do you PEP 8-name a class whose name is an acronym?

Much like Java (or php), I&#39;m use to seperating the classes to files. &lt;br&gt;
Is it the same deal in Python? plus, how should I name the file? &lt;br&gt;
Lowercase like classname.py or the same like ClassName.py? &lt;br&gt;
Do I need to do something special if I want to create an object from this class or does the fact that it&#39;s in the same &quot;project&quot; (netbeans) makes it ok to create an object from it?

Are classes in Python in different files?

Where can I find a detailed manual about PostgreSQL naming conventions? (table names vs. camel case, sequences, primary keys, constraints, indexes, etc...)


PostgreSQL naming conventions

Is there a way to see a list of indices on a collection in mongodb in shell?  i read through http://www.mongodb.org/display/DOCS/Indexes but i dont see anything

A list of indices in MongoDB?

When should I use a primary key or an index? 

What are their differences and which is the best?

When should I use primary key or index?

I ran this using MySql and it appears to not like `TEXT`. With SQL server I use `nvarchar(max)` What should I use in MySql? In other tables some fields will be descriptions and may be long so at the moment I am thinking that fixed length is bad.

    create table if not exists 
        misc_info (
            id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
            key TEXT UNIQUE NOT NULL,
            value TEXT NOT NULL
        )ENGINE=INNODB;



Indexing a MySql TEXT column?

What is an index in SQL?

I&#39;ve got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run

    SELECT * FROM table WHERE id = &#39;1&#39;;

the code runs fine as the ID field is the primary index.
However, for a recent development in the project, I have to search the database by another field. For example:

    SELECT * FROM table WHERE product_id = &#39;1&#39;;

This field was not previously indexed; however, I&#39;ve added one, so mysql now indexes the field, but when I try to run the above query, it runs very slowly. An EXPLAIN query reveals that there is no index for the product_id field when I&#39;ve already added one, and as a result the query takes any where from 20 minutes to 30 minutes to return a single row.

My full EXPLAIN results are:

    | id | select_type | table | type | possible_keys| key  | key_len | ref  | rows  | Extra       |
    +----+-------------+-------+------+--------------+------+---------+------+-------+------------------+
    |  1 | SIMPLE      | table | ALL  | NULL         | NULL | NULL    | NULL |157211 | Using where |
    +----+-------------+-------+------+--------------+------+---------+------+-------+------------------+

It might be helpful to note that I&#39;ve just taken a look, and ID field is stored as INT whereas the PRODUCT_ID field is stored as VARCHAR. Could this be the source of the problem?

Content Type	Original Author	Original Content on Stackoverflow
Question	Eric Ness	View Question on Stackoverflow
Solution 1 - Sql Server	JSR	View Answer on Stackoverflow
Solution 2 - Sql Server	Mark Byers	View Answer on Stackoverflow
Solution 3 - Sql Server	Stuart Steedman	View Answer on Stackoverflow
Solution 4 - Sql Server	Pixelated	View Answer on Stackoverflow

SQL Server Index Naming Conventions

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

How to create a hex dump of file containing only the hex characters without spaces in bash?

How can a JavaScript object refer to values in itself?

Attributions