sql-server-2008 tutorials

SQL Server stored procedure line number issue

Mar 25, 2022

sql-server-2008 stored-procedures deadlock

Recommend usage of temp table or table variable in Entity Framework 4. Update Performance Entity framework

Aug 22, 2019

c# sql-server-2008 entity-framework-4 temp-tables

Why insert-select to variable table from XML variable so slow?

Nov 15, 2019

sql-server xml sql-server-2008 variables

Using UNION ALL in STUFF / XML Path

Nov 02, 2022

sql-server sql-server-2008 tsql

How to use @@ROWCOUNT in IF statement as well as within BEGIN..END block?

Apr 26, 2021

sql sql-server sql-server-2008 stored-procedures

SQL 2008 geography & geometry - which to use?

Oct 20, 2022

sql-server-2008 geometry geospatial geography

Union all geometry in a SQL Server table like GeomUnion in Postgres

Nov 08, 2022

sql sql-server-2008 spatial

Deleting column doesn't reduce database size

Oct 25, 2022

sql sql-server sql-server-2008

How to rename something in SQL Server that has square brackets in the name?

Oct 17, 2022

sql sql-server sql-server-2008

can SQL insert using select return multiple identities? [duplicate]

Aug 17, 2022

sql-server sql-server-2008 lastinsertid

Generate ASP.Net Membership password hash in pure T-SQL

Sep 11, 2018

asp.net tsql sql-server-2008 hash asp.net-membership

which datatype to use to store a mobile number

Dec 14, 2019

sql-server-2005 sql-server-2008 sql-server-express sqldatatypes

Create PK for #temp table failed when the script is run in parallel

Feb 28, 2018

sql-server sql-server-2008

SQL - convert int to double

Sep 16, 2022

sql-server-2008

How to only check the time on datetime fields but ignore the date?

Oct 15, 2022

sql sql-server-2008 tsql

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query

Oct 28, 2022

sql sql-server-2008

SQL CASE and local variables

Oct 23, 2022

sql sql-server tsql sql-server-2008

Can you use an asterisk (*) to filter a column in a WHERE clause under SQL Server 2008?

Oct 30, 2022

sql sql-server sql-server-2008 select

Do CTEs use any space in tempdb?

Nov 08, 2022

sql-server-2005 sql-server-2008 common-table-expression tempdb

Is the SQL Server 2012 version of Microsoft.SqlServer.Types' geometry UDT backward compatible with SQL Server 2008?

Apr 04, 2022

sql-server-2008 sql-server-2012 spatial backwards-compatibility sqlgeometry

New posts in sql-server-2008