Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008-r2

How to pass string parameter with `IN` operator in stored procedure SQL Server 2008

ALTER INDEX failed because of QUOTED_IDENTIFIER when running from sp_msForEachTable

How could I force the data type of a computed column to a bit field that don't allow nulls?

cross apply xml query performs exponentially worse as xml document grows

How to get the list of active triggers on a database?

Trigger Error: The current transaction cannot be committed and cannot support operations that write to the log file

Programmatically copy indexes from one table to another in SQL Server

CTE (Common Table Expression) vs Temp tables or Table variables, which is faster?

Migrating from MySQL to SQL Server, issues with constraints

Is this a bug in MERGE, failing to implement FOREIGN KEY properly?

Query generated by EF takes too much time to execute

Why is Setting a SQL Server Bit to "false" in a stored procedure definition valid?

Set Tablix row height to a specific number in SQL Server Report Builder 3.0?

SQL Server Default Database when Query - master

How to select the top n from a union of two queries where the resulting order needs to be ranked by individual query?

How do I stop SQL Server 2008 R2 trying to install some package when I build my setup project?

sp_send_dbmail: FROM_ADDRESS

How to drop user defined objects from master database