128 characters. This is the max length of  the [`sysname`][1] datatype (`nvarchar(128)`).


  [1]: http://msdn.microsoft.com/en-us/library/ms191240.aspx

Yes, it is 128, except for **temp tables**, whose names can only be up to **116** character long.
It is perfectly [explained here][1].


  [1]: http://blog.sqlauthority.com/2012/05/01/sql-server-maximum-allowable-length-of-characters-for-temp-objects-is-116-guest-post-by-balmukund-lakhani/

And the verification can be easily made with the following script contained in the blog post before:

    DECLARE @i NVARCHAR(800)
    SELECT @i = REPLICATE(&#39;A&#39;, 116)
    SELECT @i = &#39;CREATE TABLE #&#39;+@i+&#39;(i int)&#39;
    PRINT @i
    EXEC(@i)



You can also use this script to figure out more info:

    EXEC sp_server_info

The result will be something like that:

    attribute_id | attribute_name        | attribute_value
    -------------|-----------------------|-----------------------------------
               1 | DBMS_NAME             | Microsoft SQL Server
               2 | DBMS_VER              | Microsoft SQL Server 2012 - 11.0.6020.0
              10 | OWNER_TERM            | owner
              11 | TABLE_TERM            | table
              12 | MAX_OWNER_NAME_LENGTH | 128
              13 | TABLE_LENGTH          | 128
              14 | MAX_QUAL_LENGTH       | 128
              15 | COLUMN_LENGTH         | 128
              16 | IDENTIFIER_CASE       | MIXED
               ⋮  ⋮                       ⋮
               ⋮  ⋮                       ⋮
               ⋮  ⋮                       ⋮


Visual Studio Productivity Power Tools Version 10.0.20427.1, updated 10 May 2011, is creating a &amp;lt;solution&amp;gt;.sln.docstates file.

What is purpose of the file?

Should I be checking it into version control?

What is .sln.docstates file created by Visual Studio Productivity Power Tools?

I&#39;m using the Android Compatibility library to implement fragments and have extended the layout sample so that a fragment contains a button which fires off another fragment.

In the selection pane on the left I have 5 selectable items - `A B C D E`.

Each loads up a fragment (via `FragmentTransaction:replace`) in the details pane - `a b c d e`

Now I&#39;ve extended fragment `e` to contain a button which loads up another fragment `e1` also in the details pane. I&#39;ve done this on fragment `e`&#39;s onClick method as follows:

    FragmentTransaction ft = getActivity().getSupportFragmentManager().beginTransaction();
    ft.replace(R.id.details_frag, newFrag);
    ft.setTransition(FragmentTransaction.TRANSIT_FRAGMENT_OPEN);
    ft.addToBackStack(null);
    ft.commit();

If I make the following selections:

    E - e - e1 - D - E

Then fragment `e` is in the details pane. This is fine and what I want. However, if I hit the `back` button at this point it does nothing. I have to click it twice because `e1` is still on the stack. Furthermore after clicking around I got a null pointer exception in onCreateView:

To &#39;solve&#39; this problem I added the following whenever `A B C D E` is selected:

    FragmentManager fm = getActivity().getSupportFragmentManager();
    for(int i = 0; i &lt; fm.getBackStackEntryCount(); ++i) {
        fm.popBackStack();
    }

Just wondering whether this is the correct solution or whether I should be doing something different?

Is this the right way to clean-up Fragment back stack when leaving a deeply nested stack?

What is the maximum character length of object name (e.g. constraint, column) in SQL Server 2008? 

SQL Server: Maximum character length of object names

<p>What is the maximum character length of object name (e.g. constraint, column) in SQL Server 2008?</p>


How can I generate a class from a SQL Server table object?

I&#39;m not talking about using some ORM. I just need to create the entities (simple class). Something like:

```cs
    public class Person 
    {
        public string Name { get;set; }
        public string Phone { get;set; }
    }
```

 Given some table like:

```
+----+-------+----------------+
| ID | Name  |     Phone      |
+----+-------+----------------+
|  1 | Alice | (555) 555-5550 |
|  2 | Bob   | (555) 555-5551 |
|  3 | Cathy | (555) 555-5552 |
+----+-------+----------------+


```

Generate class from database table

I am trying to order by date. I want the most recent dates coming in first. That&#39;s easy enough, but there are many records that are null and those come before any records that have a date.

I have tried a few things with no success:

    ORDER BY ISNULL(Next_Contact_Date, 0)
    
    ORDER BY ISNULL(Next_Contact_Date, 999999999)
    
    ORDER BY coalesce(Next_Contact_Date, 99/99/9999)

How can I order by date and have the nulls come in last? The data type is `smalldatetime`.

SQL Server ORDER BY date and nulls last

I want to move data from one DB to another, while keeping the identity column values in the old DB. When I run the wizard I get a validation error &quot;Failure inserting into the read-only column &quot;ChannelID&quot;.

Where ChannelID is an identity column on that table.
How can I override the identity functionality in order to be able to import the data?

Import and Export Wizard with Identity Column

In trying to improve the speed of an immensely slow query (several _minutes_ on two tables with only ~50,000 rows each, on SQL Server 2008 if it matters), I narrowed down the problem to an `OR` in my inner join, as in:

    SELECT mt.ID, mt.ParentID, ot.MasterID
      FROM dbo.MainTable AS mt
      INNER JOIN dbo.OtherTable AS ot ON ot.ParentID = mt.ID
                                      OR ot.ID = mt.ParentID

I changed this to (what I hope is) an equivalent pair of left joins, shown here:

    SELECT mt.ID, mt.ParentID,
       CASE WHEN ot1.MasterID IS NOT NULL THEN
          ot1.MasterID ELSE
          ot2.MasterID END AS MasterID
      FROM dbo.MainTable AS mt
      LEFT JOIN dbo.OtherTable AS ot1 ON ot1.ParentID = mt.ID
      LEFT JOIN dbo.OtherTable AS ot2 ON ot2.ID = mt.ParentID
      WHERE ot1.MasterID IS NOT NULL OR ot2.MasterID IS NOT NULL

.. and the query now runs in about a second!

Is it generally a bad idea to put an `OR` in a join condition?  Or am I just unlucky somehow in the layout of my tables?

Is having an &#39;OR&#39; in an INNER JOIN condition a bad idea?

I have MS SQL 2008 R2, 500 databases.
What is the most efficient, easiest and &#39;modern&#39; way to query all databases sizes.

The output should have columns:

- DatabaseName
- DataFilesSize
- LogFilesSize

SQL Server 2008: How to query all databases sizes?

I am getting following error in my SQL server 2008 R2 database:

&gt; Cannot use a `CONTAINS` or `FREETEXT` predicate on table or indexed view &#39;tblArmy&#39; because it is not full-text indexed.



Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

Is it possible to get the name of the current Stored Procedure in MS SQL Server? 

Maybe there is a system variable or function like `GETDATE()`?

Current executing procedure name

I have a bunch of product orders and I&#39;m trying to group by the date and sum the quantity for that date. How can I group by the month/day/year without taking the time part into consideration?

`3/8/2010 7:42:00` should be grouped with `3/8/2010 4:15:00`



How can I group by date time column without taking time into consideration

I am writing a Stored procedure in SQL Server 2008.
I need to check if a table exists in the database.  If it doesn&#39;t then I need to create it.

How do I do this?

Content Type	Original Author	Original Content on Stackoverflow
Question	jrara	View Question on Stackoverflow
Solution 1 - Sql Server	Martin Smith	View Answer on Stackoverflow
Solution 2 - Sql Server	Jaime	View Answer on Stackoverflow
Solution 3 - Sql Server	GorkemHalulu	View Answer on Stackoverflow

SQL Server: Maximum character length of object names

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Is this the right way to clean-up Fragment back stack when leaving a deeply nested stack?

What is .sln.docstates file created by Visual Studio Productivity Power Tools?

Attributions