sql-server-2008 tutorials

SQL And NULL Values in where clause

Oct 27, 2022

nolock on a temp table in SQL Server 2008

Sep 24, 2022

sql-server sql-server-2008

Pros and cons of READ_COMMITTED_SNAPSHOT

Dec 26, 2014

sql-server-2008 c#-4.0 transactions

Why IsNull(LTrim(RTrim(Lower(null))), -1) is *?

Nov 01, 2022

sql sql-server-2008 tsql

How to pass Table-Valued parameters from java to sql server stored procedure?

Nov 11, 2022

java sql-server sql-server-2008 jdbc mssql-jdbc

Simple Way to View SQL Query (ies) Generated by SSRS Reports?

Mar 17, 2022

tsql sql-server-2008 ssrs-2008

How to recover data from truncated table

Feb 22, 2022

sql-server sql-server-2008 truncate

The proper way to implement unique constraint that allows multiple NULL values in SQL Server

Jan 30, 2021

sql-server tsql sql-server-2008

Enable foreign key with Check existing data

Oct 05, 2013

sql-server tsql sql-server-2008

Sum results from two select statements

Apr 19, 2022

sql sql-server sql-server-2008 tsql

How do I enforce SSRS page breaks with empty tables?

Apr 23, 2021

sql-server-2008 ssrs-2008 export-to-excel

Normalizing an extremely big table

May 29, 2022

sql sql-server sql-server-2008 normalization database-normalization

When are computed columns appropriate?

Sep 06, 2022

sql sql-server entity-framework sql-server-2008

How can a SQL query have two from clauses?

Nov 18, 2022

sql sql-server sql-server-2008 tsql

SQL Maintenance Plan sends mail when no mail configured

Apr 08, 2020

sql-server sql-server-2008 sql-agent-job maintenance-plan database-mail

Rollback and Raiseerror, which first?

Nov 17, 2022

sql sql-server sql-server-2008 rollback raiseerror

SQL Server Geography datatype nearest point on line

Oct 20, 2022

sql sql-server tsql sql-server-2008 gis

How to create a relationship between table and view in the Entity Framework

Oct 28, 2022

entity-framework sql-server-2008

How can I check for duplicates before inserting into a table when inserting by select

Oct 13, 2020

sql sql-server sql-server-2005 tsql sql-server-2008

Migrate from sql server 2000 to 2008 r2 - how to

Sep 23, 2022

sql-server-2008 migration sql-server-2000

New posts in sql-server-2008