Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

Query to find the FIRST AND SECOND largest value from a group

sql sql-server-2008

Why deadlock occurs?

SQL Server - Creating a Schema Bound Indexed View with a current GetDate filter

SQL Server XML exist()

xml sql-server-2008

Query SQL Server with IN (NULL) not working

Types don't match for creating a CLR Stored Procedure

c# .net sql-server-2008 sqlclr

Compare multiple columns, but only those having valid values, and create y/n flag if all are equal

Where to download AdventureWorks2008.msi?

How do I select X random rows while guaranteeing that Y certain specific rows are in the result?

Permission to access sys.dm_db_index_usage_stats

sql sql-server-2008

Get the list of unique constraints and indexes in a database

RETURN inside a transaction with TRY-CATCH block

SQL Count to include zero values

sql sql-server-2008 count

Determining page count on each SQL table without using DBCC

sql sql-server-2008

Inserting multiple rows into a SQL Server table using a table variable

DBCC CHECKIDENT RESEED -- is new value required?

Parse XML using T-SQL and XQUERY - Searching for specific values

What is the fastest way to delete all customers from SQL Server based on that customer not meeting a single criteria

Tedious or Sequelize uses the wrong syntax for `findOne()`

Using PIVOT in SQL Server 2008