| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| Performance - I am assisting with a migration. doing a V to V migration from a legacy environment to the hosted infrastructure. I want to do some baseline testing and wondered if there are some scripts i could run in SQL that i could run on the legacy and on the new environment to compare so I […] |
| SQL Server 2017 - Development |
| Temp Table Strategy - I have a set of reports - with user defined criteria. And an optional set of statistics which are produced on the report. These are not db table stats, but things like aggregates, trends and statistical analysis of the data. The happy user then downloads their data and moves on to something else. The reports […] |
| SQL Server 2016 - Administration |
| Statistics issues - Hi All, Looking for some clarifications on UPDATING STATISTICS. In our production env, we have 3 TB database with Auto_create stats option is set to true. Every weekend on Saturday midnight we run update stats with full scan. However, during the mid of the week, application developers keep complaining that few queries are running slow. […] |
| memory utilisation - How can we calculate the memory and cpu utilisation of sql for the last 3 months ? |
| SQL Server 2016 - Development and T-SQL |
| Update large table rows within a group - I have a large employee table with lots of columns and versions and one org lookup table also with some versions. I need to update a column org_id in employee table which is all nulls now with no history. An employee can have multiple versions records each with same empid but same or different rc_code. […] |
| CAST(NULL AS varchar(1)) - Hello All, I have been tasked to improve a very old SQL code we have and first thing I see (may not necessarily be the candidate for performance improvement though) going through the code is many CASE records with CASE WHEN myColumn IS NULL THEN CAST(NULL AS varchar(1)) .... Can one advise why someone would […] |
| SQL 2012 - General |
| SSIS ForEach Loop not finding file - I used to know how to do this, I think, but I wonder if my memory is playing tricks on me. I need a ForEach loop to find a file that the name changes daily. Normally, I'd use a wildcard (*), but in this case it doesn't seem to be working. I've searched all my […] |
| SQL Server 2019 - Administration |
| SQL Permissions - My understanding is you can't grant access to users with select, View database and view definitions etc. at instance level without any user databases created on it. Please advise? |
| authgrowth log during rebuil index - Good morning all , Have any idea how I can reduce disk consumption during the reindexing phase I use the IndexOptimize procedure of the olla script |
| SQL Server 2019 - Development |
| Better way to flatten meta type data? - I have the following table how would I be able to get a view similar to SELECT [ID], [NAME], [Imaging], [Long Term], [Auto], [Factory], [Central Office], [Pizza] FROM [Some SQL Magic Code]; The best I've come up with is multiple selects with where clauses to create tables and then join all of them. I'm not […] |
| Filling in Empty Rows - Given a date parameter I've a query that will return a two column result set. The first column is a number (1 -6) that represents a condition and the second column is a number that represents the count of records in that condition. A typical result set may look like this: 1, 30; 2, 100; […] |
| SQL Server Newbies |
| SQL update to replace undetermined string value - Hello, I have a varchar column called "Message". Sometimes, this column contains a bit of text that begins with "**" and ends with "**". There can be text before and after, but what I'm looking to do is only remove the bits of text that follow the "**%**" pattern (which should only ever happen once […] |
| Reporting Services |
| Connection Pool Timeout with Data Driven Subscription - Hi, Each morning, we run several data driven subscriptions which generate about 10,000 reports and email them as excel attachments. Recently we have resolved some issues we had with the subscriptions (such as bad email addresses) that were causing subscription errors. Most days, we run through these subscriptions error-free. Some days, we get a few […] |
| Analysis Services |
| SSAS Tabular SSDT DAX Drillthrough Issue - Hello, I've come across a scenario where the drillthrough functionality is not working when multiple dates from a fact table is joined to a single date dimension. If I have a fact table with multiple status dates e.g. Resolved Date, Logged Date and join it to one Date dimension table, one of the relationship would […] |
| Integration Services |
| SSIS Custom Task for creating Excel with formulae - Hello everyone, I am currently looking for a way to create Excel reports that include formulae (probably also Pivot tables and other stuff) from Reporting Services. Searching the web and the forums on SSC I found that therer is no simple way to achieve this. Would it be possible to do such a creation in […] |
