SQL Server Browser missing - Hi We have installed SSRS 2012 and upgraded to 2016. The SQL Server Browser is not installed on the machine. The setup...
Data Copy for reporting purposes - Hi! @ present we have a reporting server which is for internal and external users..they run regular reports. - we keep the...
Access users can't use SQL 2016 (?) - I'm migrating several Access backends from SQL Server 2005 to SQL Server 2016. I have successfully gotten the ODBC connections...
Rewrite SQL code to perform better and be in line with best practice. - Is there a better way or a more efficient way to write the attached stored proc that leans on to...
Performance improvement following a disable indexes, shrink, enable indexes - but why? - I'm stumped and need the assistance of the wider community to understand what is going on. The database in question has...
Help me with the SELECT statement please ? - Good Day For the sake of simplicity, I just added one members records. What you see is this member had enrollment...
Need a SQL Query to find numeric values - Hi Experts, Can you all help me out to find a query in which i can find all the tables in...
Grouping dates and IDs together - I have what at first (and second and fifth) glance appears to be an impossible task. I have to take...
Running total with reset condition - hi all, i would like a running total with a restart after a certain limit. Let set the condition to be...
The queue %d in database %d has activation enabled and contains unlocked messages but no RECEIVE has been executed for %u seconds - I am getting below the message in error log every 1000 seconds on one of my instances where I have...
How to uninstall SSAS - I've been tasked with uninstalling SSAS from our SQL Server 2012 instance and re-installing it with the Multidimensional mode rather...
SqlException :- incorrect syntax near the keyword as,incorrect syntax near t2 - Hi All, I'm trying to run this code in my asp.net app below but getting error SqlException :- incorrect syntax near the keyword as,incorrect...
Query - Performance between dates - Im running a query and it has numerous linked tables. I have entered a date parameter of one week (28/01/2018...
Index operation fails with below - Hi All, Index operation is failing on SQL 2008 R2 Enterprise with below message. Any idea what's happening? It used to...
sql server database size and recovery model script. - Hi everyone. Can i get T-SQL script for SQL 2008R2/2012, which include database name, DB size & recovery model in single...
Count from joins - Hi, Is there a better way of doing this? I'm joining back to the same table 4 times and counting from...
Stored Procedure for Data Driven Subscription? - I've found that the T-SQL I want to use for a data driven subscription isn't considered valid by the RS...
Visual Studio Data Tools 2017 - TFS lock icons missing and other issues - Hi all We've just installed a test instance of Microsoft SQL Server Data Tools for Visual Studio 2017 (Version 15.3.5) and...
Why can't I paste SQL code into a post??? - I've just spent 20 minutes preparing a new post in the SQL 2008 forum. It took me that long to...
Migrated DB to 2016, having ODBC Access problem - Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One...
