sql-server tutorials and guides

how do I reset collation for all columns in the database?

Aug 23, 2022

sql sql-server collections

Unique constraint with EFCodeFirst and SqlCe4

Jun 09, 2017

sql-server asp.net-mvc-3 ef-code-first

How to add an identity column to an existing database table which has large number of rows

Nov 02, 2022

sql sql-server sql-server-2008 identity

Clustered index on temp table

Nov 03, 2022

sql sql-server tsql temp-tables clustered-index

SQL Selecting rows at varying intervals

Oct 26, 2022

sql sql-server

FreeTDS - tsql connects, isql fails

Jul 25, 2021

sql-server ruby linux freetds isql

Cyrillic alphabet with Microsoft SQL Server Management Studio

Sep 11, 2022

sql-server ssms

Is date/time part of SQL Server's datetimeoffset UTC or local?

Mar 02, 2022

sql-server sql-server-2008 timezone

Issue with a date extraction in SQL Server

Dec 11, 2021

java sql-server hibernate spring

Group OHLC-Stockmarket Data into multiple timeframes with T-SQL

Nov 11, 2020

sql-server tsql group-by timestamp finance

What does OBJECT_ID do in SQL Server?

Feb 15, 2022

sql sql-server tsql sql-server-2005 object-identity

Multiple left joins - keeping the returned row count down?

Jul 02, 2019

sql sql-server tsql

How can I ignore 'Arithmetic Overflow' related errors from within a data view?

Oct 21, 2022

sql sql-server sql-server-2005 tsql

OptimisticConcurrencyException with System.Web.Providers

Oct 30, 2018

asp.net sql-server asp.net-mvc optimistic-concurrency

What are the benefits of using the Row Constructor syntax in a T-Sql insert statement?

Dec 20, 2019

sql sql-server sql-server-2008 tsql

Create custom "auto-increment" Compound Primary Key?

Sep 05, 2022

sql sql-server

How can I use OVER and ORDER BY

Nov 16, 2022

sql sql-server sum sql-order-by window-functions

Should GUID be used as a foreign key to many tables

Nov 07, 2022

sql-server database database-design asp.net-membership

How does Sql Server compile execution plans for logic flow in stored procedures?

Jun 25, 2018

sql-server

Finding repeated occurrences with ranking functions

Dec 31, 2021

sql sql-server sql-server-2008 tsql ranking-functions

New posts in sql-server