New post in Sql-server-2008-r2

How to determine which SSAS Cube is processing now?

July 13th, 2022

Shrinking a SQL Server database not working

July 9th, 2022

How can I select the nearest value less-than and greater-than a given value efficiently?

July 9th, 2022

Create geography polygon from points in T-SQL

July 9th, 2022

The formal parameter “@mode” was not declared as an OUTPUT parameter, but the actual parameter passed in requested output

July 22nd, 2022

Error Converting data type 'Numeric' to Decimal (help!)

July 10th, 2020

how to get the distinct records based on maximum date?

July 19th, 2022

Delete all Stored Procedures at once

July 12th, 2022

SQL Server Reporting Services 2008 R2 always show for login prompt

August 5th, 2020

Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053

July 24th, 2022

Sub report could not be shown. Sub report works separately - Not with Main Report

August 7th, 2021

How to allow temporary tables to accept null values

June 12th, 2021

Where are views stored in SQL Server

July 9th, 2022

How to convert SQL Server 2008 R2 database to SQL Server 2012?

August 1st, 2022

Inner joining to a select statement where the inner select statement's where clause references the outer select?

August 23rd, 2020

Bring SQL Server database online

July 19th, 2022

Give a title to each sql query output

July 9th, 2022

Rollback transaction from trigger

July 9th, 2022

How to SET IDENTITY_INSERT ON in SQL Server 2008 for multiple tables at once

December 23rd, 2020

How to concatenate strings from multiple rows in one column + inner join in one query

April 1st, 2021

How to get SQLCMD to output errors and warnings only

March 9th, 2020

Convert string into xml and insert Sql Server

July 9th, 2022

Password mismatch while logging to sql server

July 9th, 2022

Optional multi-valued parameters in SSRS

April 30th, 2021

"Adding a value to a 'datetime' column caused an overflow."

July 9th, 2022

Can I LEFT JOIN between column types INT and VARCHAR?

July 9th, 2022

How to automatically generate unique id in SQL like UID12345678?

December 16th, 2020

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

September 3rd, 2020

Programmatically copy indexes from one table to another in SQL Server

March 8th, 2020

How to execute a stored procedure against linked server?

July 15th, 2022