Search: nvarchar

More Results

Sort by: Relevance | Date

  • xVelocity Columnstore Indexes in SQL Server 2012

    With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity... Tip   |   SearchSQLServer.com

  • Useful SQL Server 2012 features to become familiar with

    SQL Server 2012 has plenty of new features for everyone, from developers to administrators. There are several features for high availability and database administration that will improve DBA operations. We're going to look at four of them:... Tip   |   SearchSQLServer.com

  • Different ways to audit SQL Server security

    With strengthened security management guidance from the industry, Microsoft is building more security and auditing features into SQL Server. These SQL Server auditing features not only help DBAs generate audit trails of schema changes and... Tip   |   SearchSQLServer.com

  • T-SQL tricks for SQL Server 2012: T-SQL statements

    Editor's note: This is the fourth and final part of a series on new features in T-SQL in SQL Server 2012. Check out the other parts of this series to learn more about... Tip   |   SearchSQLServer.com

  • Six SQL bulk copy command gotchas

    The bulk copy tool (BCP) is one of SQL Server’s mainstay command-line tools -- a very handy and somewhat underrated way to import and export massive amounts of data... Tip   |   SearchSQLServer.com

  • More T-SQL statements in SQL Server 2012 you need to know about

    EDITOR’S NOTE: This is the second part of a two-part series on new T-SQL commands in SQL Server 2012. It reviews tweaks to serial numbering and data type conversion.... Tip   |   SearchSQLServer.com

  • VARCHAR and NVARCHAR data types in SQL Server 2005

    Having trouble with using VARCHAR and NVARCHAR data types in SQL Server 2005 Express or Enterprise Edition? Learn which properties could be the problem. Ask the Expert   |   SearchSQLServer.com

  • Differences between varchar and nvarchar in SQL Server

    The differences between varchar and nvarchar for SQL Server data types are detailed here by SQL Server expert Serdar Yegulalp. Learn how each data type is stored differently, how to mix and match them and what changes were made to... Tip   |   SearchSQLServer.com

  • NVARCHAR versus VARCHAR

    What is the difference between nvarchar and varchar in SQL Server 2000?
    SQL Server provides both datatypes to store character information. For the most part the two datatypes are identical in how you would work... Ask the Expert   |   SearchSQLServer.com

  • Manage, query SQL Azure Federations using T-SQL

    EDITOR’S NOTE: The following is the first article in a two-part series on managing Microsoft’s sharding technology SQL Azure Federations with Transact-SQL (T-SQL). Part 1 focuses on using T-SQL to create federated tables and migrating data... Tip   |   SearchSQLServer.com

Search Again: