More Results
-
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
-
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 formatting
Editor's note: This is part three of a series of tips on T-SQL tricks for SQL Server 2012 by SQL Server expert Robert Sheldon. This installment examines formatting within expressions. The first part of the series covers... 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
-
New datetime data types in SQL Server 2008 offer flexibility
The fifth and final tip in this series on SQL Server datetime values outlines four new data types supported by T-SQL in SQL Server 2008. SQL Server expert Robert Sheldon walks you through how to use DATETIME2,... Tip | SearchSQLServer.com
-
Using DATEADD and DATEDIFF to calculate SQL Server datetime values
SQL Server DATEADD and DATEDIFF functions allow you to easily perform calculations such as adding or subtracting a time interval from a datetime value or for comparing two date/time values. SQL Server expert Robert... Tip | SearchSQLServer.com
-
Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
Part three in our series on datetime in SQL Server describes functions for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value. Learn how to extract the day, month or year... Tip | 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
-
SQL Server 2008 data types: Datetime, string, user-defined and more
Find out about data types available in SQL Server 2008 and how to use them, including datetime, string and user-defined data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005... Book Excerpt | SearchSQLServer.com
-
SQL Server data conversions from date/time values to character types
T-SQL supports two built-in methods for converting date/time data to character data and vice versa. SQL Server expert Robert Sheldon takes you through a step-by-step process for using each method -- implicit and explicit... Tip | SearchSQLServer.com
Search Again: