How do I hand my Stored Procedure A String List

I have written a function (UDF)  and a stored procedure that will hopefully take in an in…

Best way to move database data files to the same size

I have inherited an approximately 800GB SQL 2016 database (recently migrated) with 35 data files ra…

Query newbie question

I'm very new to TSQL but my job has expanded to include building some SSRS reports for our CRM envi…

Need help with derived column expression

Hi All, I have a requirement for derived column expression as if ColA ="AB" then display [ColB] els…

Is there any way to see if any of my users have accessed a linked server?

SQL Friends,We have a linked server we are looking to retire, but we cannot tell if it is being acc…

A better way than multiple subqueries?

I have a table that contains a single record for each of the (several thousand) devices we manage, …

Derived column failures due to error codes DTS_E_INDUCEDTRANSFORMFAILUREONERROR 0xC0049067 and DTS_E_PROCESSINPUTFAILED 0xC0209029

Hi All, I've been working on an SSIS package for which I've added derived columns (which I've poste…

Comparing two columns of nvarchar data that is identical col1=col2 comes back as false not true?

I have a table of data that is comparing employee job titles. This data comes from an external syst…

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

Upgrading SSIS Solution from 2014 to 2016

Hi, I'm testing out an upgrade of our ETL solution from SSIS 2014 to 2016.  These are the step…

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…

Database size vs memory

I am investigating a slowness issue with one of our database servers. The 3rd party application tha…

Query VCentreDatabase for VM stats

I am looking at many posts to find a script that can query VCDB to get CPU,Memory Utilization.I dev…

Backup

Hi , Daily database backups are running, but there is no sql job.And backups are saving in physical…

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…