New posts in sql-server

Disable Enable Trigger SQL server for a table

How do you copy a record in a SQL table but swap out the unique id of the new row?

How do I restore a batch of transaction logs rather than one by one

Why is "DbccFilesCompact" status is "Suspended"?

How to get first and last day of previous month (with timestamp) in SQL Server

SQL Server Installation - What is the Installation Media Folder?

How to connect an existing SQL Server login to an existing SQL Server database user of same name

Why is the activation stored procedure not triggering on my SQL Server QUEUE?

How can I use Like operator in mssql(node.js)

How do I drop table variables in SQL-Server? Should I even do this?

What is TEXTIMAGE_ON [PRIMARY]?

How can I alter a primary key constraint using SQL syntax?

PetaPoco insert fails on table with trigger

How can a Perfmon "% Processor Time" counter be over 100%?

INSERT INTO vs SELECT INTO

SQL queries - There are no primary or candidate > keys in the referenced table

Real life example, when to use OUTER / CROSS APPLY in SQL

Must declare scalar variable @Id?

How can I backup a SQL Server 2008 R2 DB without taking it offline?

EF5: Cannot attach the file ‘{0}' as database '{1}'