Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008-r2

What is a non-clustered index scan

Best way to store quarter and year in SQL Server?

Why do people use RaiseError instead of Print in T-SQL

sql tsql sql-server-2008-r2

Fill In The Date Gaps With Date Table

ssrs 2008 passing a parameter list to a subreport

Get average value per day/hour without Group By

sql tsql sql-server-2008-r2

Enable xp_cmdshell does not work

Conversion failed when converting date and/or time from character string Error

tsql sql-server-2008-r2

Partitioning Table Error with more partitions than Filegroups

SQL Server query - how to insert selected values into another table

SQL Query sort by closest match

tsql sql-server-2008-r2

Column level compression in SQL Server

The transaction log for database 'Name' is full.To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

sp_whoisactive resulting an unknown query: "Insert Into <table_name> select *,%%bmk%% from <table_name> option (maxdop 1)"