Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008-r2

Statistical Process Control Charts in SQL Server 2008 R2

Generate **bare** CREATE TABLE and CREATE PROC statemnts in SQL Server

SQL Server INSTEAD OF INSERT trigger failure

Clustered Index internal structure

Alternative to ROW_NUMBER() OVER (PARTITION BY x ORDER BY z)

How to output columns as rows in a select?

How to add hard-coded literals to a query results on SQL Server?

sql sql-server-2008-r2

Are there any drawbacks to turning on ALLOW_SNAPSHOT_ISOLATION

What is the difference between being db_owner vs. db_datareader / db_datawriter?

SqlException: User does not have permission to perform this action

CLR User Defined Aggregate Function in order to get the first element of a sequence

SQL Server XQuery - Selecting a Subset

sql server unique key for each partition

Find duplicates, display each result in sql

Unique Key or Index with 'Is Unique'

sql sql-server-2008-r2 ssms

Self Join query to find duplicate records

sql query to insert values to auto increament column

SQL Server multiple shrink operations