SSRS 2016 Error - When I try to access SSRS URL externally or from any other server it gives error: Could not load contents. Something went...
SQL Licensing Question - We have a UAT environment, in which customers outside of our organization run tests against software that we develop using...
Inserting DBCC Results into a table - Hi, my Goal is to insert the results from a DBCC CHECKDB into a table that will hold 6 months worth...
SQL Pivot Query - Hi, I have managed to get a pivot using the following code Select SALESDESCRIPTION, GROUPDESCRIPTION, ACCOUNTNUMBER, ACCOUNTNAME, SUM(NP8) AS...
Execution plan estimates Join hint spilling. - Hi, I've been troubleshooting a performance problem with a stored procedure where depending on the parameters the row count on two...
Index Foreign Key & Other Indexes - Is it a good practice to index all foreign keys? We have Index on all foreign keys currently and for some...
Always On Readonly - Have created a always on setup in which 3 nodes are involved 2 in SQL server Failover Cluster and 1...
What's the best way of getting this to work? - Hi All, I'm working on an SP that will be run as part of an SSIS package and I'm not sure...
SQL Static Port - We have named SQL Server which uses Static Port (e.g: 4000). Application in the configuration uses that port but somehow it...
Too many workers? - Hi, I think have a problem with one of my SQL 2012 SP3 CU4 servers. Twice now, our two principal servers...
How to write a string to a file in SQL. - Hello All, I want to write a varchar(max) string to a file. The file should be UTF-8 (and not in a multi...
How to find PRIOR line of service? Help plz! - Hi guys! So I am stuck! I am trying to find prior line of service and I cannot come up with...
Age as of January 1st - Hello all, I'm really strugling on this age calcualtion. I need to find the age of a patient based off January...
Restore database with move - Hi everybody, I have a script to restore a database with move. I do not have a database yet for this...
How can I prevent a record from appearing based on two columns - Sorry for the vague Subject line but, I couldn' t come up with a good summary. In the table the...
Need help with bcp - I have created a job to export the results of a stored procedure to a folder on our shared drive...
Help on query based on condition - Hello friends hopefully you can assist me In my query, I need to frame a condition like Count of activities of activity category...
SSRS Group Total does not match Excel - Am trying to create an SSRS report based off an Excel query. The source is an SSAS database. The hierarchy...
Package in Job failing, No Clear Visiable error, Errors logs clear, Unsure How to Approch for Fix - Hello, taken over where a contractor left off. He created a series of multi-step processes broken down to jobs that...
FAQ: Using the new forum Software (Jan 2017) - After we completed the forum upgrade on Jan 12, 2017, quite a few things changed, so this thread is a...
