Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Profiler and Tuning Advisor Stats Recommendation - I ran SQL Profiler and did a trace, and after handing the file off to the Tuning Advisor, it had some Index recommendations which is understandable. However, there are a ton of statistics recommendations. The capture I did was only for about 20 seconds. The recommendations were very numerous, but the main thing is that […] |
display cluster alwayson in windows - hello , I need your help please in my server SQL on ssms I can display my avaibility group always on and the nodes and the listen so if I connect through failover cluster manager I have nothing thanks |
SQL Server 2017 - Development |
Email CSV file - We have a stored procedure and job that will email out invoices daily. It all works great, however, we are trying to get the current date in the CSV filename. Here is the line we are using now for the filename: @query_attachment_filename = 'test.csv' We are thinking of 3 different formatting options: MMDDYYYY.csv Wynne-MMDDYYYY.csv MMDDYYYY-Wynne.csv […] |
SQL Server 2016 - Administration |
Rebuliding a WSFC with availability groups - We have been having issues with nodes loosing communication on a underlying WSFC that we have our Production Always on Availability Groups on. The Server provisioning team seem to reckon that the cluster, that they built, is not in the best of shape and are talking about rebuilding all the cluster servers. Being a DBA […] |
SQL Server 2016 - Development and T-SQL |
SSRS Int64 Multi Select Report Parmeter error - I have a SSRS report in VS2017 that pulls Int64 values into a Report Parameter named "pCampusEquipment" but fails at runtime with a "The property "ValidValues" of report parameter "pCampusEquipment" doesnt have the expected type" error. The parameter works fine if I changed parameter Data Type to "Text" instead of "Integer" but the SQL Call […] |
Pivot with Ranges - This is my table BSEG_ID DST_ID BILL_SQ AUDIT_CALC_AMT Remarks 12334 REV-WSC 62 6.40667 For 0 - 60 (Next 62.000 cubic meter) @US0.10 per cubic meter 12334 REV-WSC 62 64.06667 For 60 - 120 (Next 62.000 cubic meter) @US1.00 per cubic meter 12334 REV-WSC 3.6 11.16 For 120 - 180 (Next 3.600 cubic meter) […] |
Development - SQL Server 2014 |
How to get all the column name and data type a table variable - there is a parameter in stored procedure, and this parameter is table variable, How to get all the column name and data type for a table variable? thanks! |
SQL 2012 - General |
How to select data based dynamically based on start and end of AffectedProduct ? - I work on SQL server 2012 I need to get data from #partsdata table where part number matches Affected Product both start and End as Example where I have Affected Product as APAMS-***G then I will get Parts That have start APAMS- and End by G start must be end with dash (-) this roles […] |
SQL Server 2019 - Development |
Create string from broken hierarchy - Hi I have a broken hierarchy where I need, for each row, to create a string that contains all possibæe combination ordered by creationdate (id column) So for the 1st row it would be: |96811577|2959885|5825374| as row 3 and 5 contains the same values then the result here should be the same as above. I […] |
Issue with Foreign Keys - So recently I began to start a personal project to push my limits and try to gain an edge on database work. I have been using MySQL and I am using IonnDB to make use of the Foreign Key relational system. I wrote a long document of tables that I could copy and paste to […] |
Reporting Services |
Report acting Differently in SSRS Report Editor and on the Server - Having a really interesting problem. I've added a subreport to an existing report, by adding a second detail row, merging the columns and putting the subreport there. Originally I had the subreport set to hidden and visible by toggling a group button (in y case, Division). Works, but when I run the report the row […] |
Integration Services |
SSIS : How to export data into Excel from Stored Procedure - I might be barking up a wrong tree, but hope someone can advise on the forum. I have an established stored procedure, which returns a list of records, e.g. EXEC my_stored_procedure returns idColumn (INT) and descColumn (VARCHAR(50)). Now I have a new task to write SSIS to export same result set into an Excel file […] |
Error running simple SSIS package - I have a simple package that loads a small staging table from a CSV file. I create the table (succeeds), truncate it, then reload it via OLE DB. It fails on truncate table SQL task. [Execute SQL Task] Error: Failed to acquire connection "WIN-3SVP8BUQIEM_SQL_2016.AdventureWorksDW.sa". Connection may not be configured correctly or you may not have […] |
PowerPivot |
Default values for power bi slicer - In most any data analysis tools a fundamental function is the ability to set a default value for a slicer or report parameter. Power BI being the exception. I know there are dozens of semi effective results in a simple google search to circumvent this glaring deficiency in Power BI. I realize that this post […] |
SQLServerCentral.com Website Issues |
Changing my username email - Apologies if this has been posted but I did a search on email and profile and didn't find anything similar. I have changed jobs and consequently need to change the my email username. When I go to "Edit Profile" under "Profile" on my user account, I am able to do the changes and it says […] |