Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

Simple Sql Procedure with/without cursor

SQL query with an IN operator stops seeking an index and starts to scan it, becomes 100x slower

unable to convert varchar to date in sql server

SQL adding Order By clause causes the query to run significantly faster. Explanation needed

sql sql-server-2008

Eliminate queries with a temporary table that get update every x minutes

How to Encrypt SQL Server 2008 Database

XML Path expression to include Special Characters

sql xml sql-server-2008

How can you tell what method a constraint was created with in SQL Server 2008?

Select full outer join from many-to-many relationships

sql sql-server-2008

Query points using SQL Server 2008 geography type

Drop Multiple Column Using single Alter

Create a calculated field using data from another tables

SQL Server - Searching string with international characters using LIKE clause

Convert MS Access Reports to SQL Server Reporting

CASE Statement in where clause using equal to and IN

How do I remove an Identity completely

How to enable Full Text Search in SQL Server 2008 Express

User-Defined Aggregate in SQL Server 2008 - How to deploy with MaxByteSize = -1?

SQL Server query to find the number of years enrolled by member