Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

When to keep an index - Analysing index usage stastics in SQL Server 2008

SQL Server 2008 - MERGE statement - Perform multiple actions in WHEN MATCHED block

sql-server-2008 merge

Group close numbers

Cannot call methods on char

Using SqlDependency with named Queues

SQL 2008: returning data rows as JSON?

c# .net sql json sql-server-2008

Suppress transaction in stored procedure

T-sql, ticks, timestamp

.net sql tsql sql-server-2008

Converting int primary key to bigint in Sql Server

Conversion to datetime fails only on WHERE clause?

How to do a UNION on a single table?

sql sql-server-2008 union

SELECT TOP N with variable

sql sql-server-2008

Check if a date range has a weekend

t-sql: convert varchar to xml

Split string by space

sql sql-server-2008 split

Alternate of lead lag function in SQL Server 2008

SELECT INTO behavior and the IDENTITY property

sql tsql sql-server-2008

smallint vs. int on performance

tsql sql-server-2008

GRANT a user to view single database? (deny viewing the rest)

Is there a performance difference in using a GROUP BY with MAX() as the aggregate vs ROW_NUMBER over partition by?