Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

Delete tables older than 12 months using table name

what is Reads and Writes in Sys.dm_exec_requests DMV of SQL Server

sql-server dmv

Refactoring a tsql view which uses row_number() to return rows with a unique column value

sql sql-server tsql sql-view

sp_ddopen - What is this doing?

IF NOT EXISTS in Merge statement?

sql sql-server merge

SQL char to varchar comparison works, why?

on cascade delete on a table with two FK to the same table [duplicate]

How to merge/combine two SqlDataReader Objects

c# sql-server ado.net

When would sys.database_permissions contain a row with state = 'R'?

Counting and combining rows

sql-server tsql

NOLOCK with Multithreading

Can't add index to persisted computed column because it is "of a type that is invalid for use as a key"

sql sql-server clr

T-SQL try ... catch and multiple batches (2 begin...end, if...else)

Find the most Overlapped days?

SQL query to retrieve the single line of data with desired values for the columns

Is WCF recommended to use with WPF and MVVM to retrieve data from SQL Server?

wpf sql-server wcf

SQL Optimization: how many columns on a table?

DateDiff to output hours and minutes

sql sql-server

Which is faster in SQL, While loop, Recursive Stored proc, or Cursor?

How to change the table name in visual studio 2013 in design mode?