How to Quickly Restore Objects From a Backup

I'm starting this as general discussion to get different ideas on what everyone does.  We curr…

Rewrite this query to calculate the MIN, AVERAGE, and MAX of the Temperature field.

Stored Procedure output to Excel

Could use some help on this one: I have a SQL Server 2008 64bit and try to put data in excel 2010.…

Cannot insert duplicate key row in object

Hi,I'm on SQL Server 2014 enterprise edition.  I'm running into the following error when attem…

Return 2 lines of text from a row

My SQL query is: SELECT * FROM [Support_DB].[dbo].['Job info$'] WHERE [Job Completed?]= 0 AND [Atte…

Need to rename server but name is in lots code - alias?

I have to rename a SQL Server soon. Unfortunately, the server name is hard-coded in many procs, vie…

Looking for any known issues with SQL Server 2012 SP4

Hello experts, Does anyone know of a central link describing any issues people have run into after …

simple select * from table takes around 15 secons

I have a table with like 115+ columns and it got the data around 76000 records I ran the query, Sel…

Ways of tuning queries on columnstore index (in SQL Server 2014)

Hello, After migrating to SQL Server 2014, I turned one of our large fact tables (2bn rows) into a …

Converting N rows to columns, including custom headers

Hello, I have been stuck on this for a long time now, I hope that someone can help!Please refer to …

Index Fragmentation showing up blank

Hi All, I'm checking indexes on a table and it seems to show up blank for all indexes in that data…

Patching one instance out of those installed

I am looking to install SQL Server 2016 SP2 for the development instance on my server. However when…

MDX query behaviour

Hi All, I am facing a problem while querying on hierarchical data from cube.The problem area is nth…

reporting service in sql server 2016 edition develloper

good evening everyoneif i install sql server 2016 develloper edition is what i can mount a reportin…

Strng Help Again Needed.

Moving Databases from SQL 2008 Enterprise on Windows 2008 R2 Enterprise server  To SQL 2014 En…