| Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Development |
| Reorder rank upon condition - What i like to do is to rank that when a customer address come more than once ( like 1390 des Rosiers) the first of the group should be a uneven number while respecting the order in NoSeqTrt ? Hoping that my explication is clear. Thanks in advance for your advice. Cheers |
| SQL Server 2016 - Administration |
| SPN for Always On Listener - Suppose I have the following two node cluster configured with an AG. All are on the same domain, use the same service account, and have named instance SQLInstance. SQLA and SQLB run on port 123 and SQLC (listener) runs on port 789 Node1 - SQLA Nodel2 - SQLB AG Name - TestAG AG Listener - […] |
| Unexplained tempdb growth - I left for vacation 2 weeks ago and while I was out, the tempdb drive had to be extended because it was growing like crazy. Before I left, I was monitoring some connections in the Activity Monitor; and upon leaving, I just locked my desktop. Would the Activity Monitor cause the tempdb to grow like […] |
| Planning a SQL Server Reporting Services (SSRS) 2016 installation - Hello experts, I'm trying to learn the architectural concepts of SSRS. Does SSRS have to be installed on the same host as the SQL Server that houses the ReportServer and ReportServerTempDB databases? Or can those dbs be hosted on, say, a separate cluster with the SSRS "front end" being set up as a web server? […] |
| Linked server to Oracle timing out - Hello experts, I am trying to get a linked server to an Oracle database to work. But I don't know why it keeps hanging when I try to expand the Tables section, with this error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft […] |
| SQL Server 2016 - Development and T-SQL |
| SUM and JOIN 2 columns with different tables but it duplicates results - Good day! Need help re SUM and JOIN 2 columns with different tables but it duplicates results here's the sample data tables; Transfer Shipment table; Loc Code - Item No - Description - Description2 - Variant Code - Qty Location1 Item01 Active Black […] |
| Remove spaces from an unstructured Text field - Hi Forumers, I've got a table with several Notes fields and I'm trying to remove ALL spaces from the text & replace with an underscore so the text is still easy to read. I've used REPLACE with LTRIM & RTRIM which fixed most spaces but not all. I found when I pasted the text into […] |
| Administration - SQL Server 2014 |
| SQL server index recommendations different from one environment to another - Hello, happy friday, SO i have 3 servers, each runs same application, same version, same database, BUT, i use Brent ozar BlitzIndex to help me out on index recommendations, when i run it on 1 environment, it gives me recommendations from changing index, or adding a new, or removing. When i run it on the […] |
| Development - SQL Server 2014 |
| Parse Semi colon data in seperate columns - Hi: I have semi-colon separated data in one column and I would like to split that in separate columns. CREATE TABLE #tblTest (FileData nvarchar(MAX)) INSERT INTO #tblTest values ('TEST1;Testing 123;') INSERT INTO #tblTest values ('TEST2;Testing.234;') INSERT INTO #tblTest values ('TEST3;Testing 345;') INSERT INTO #tblTest values ('TEST4;Testing 456;') INSERT INTO #tblTest values ('TEST5;Testing5.67;') SELECT * FROM […] |
| GROUP BY and SUM in inner join - My project contains below TABLES and sample data for it :: CREATE TABLE [DBO].[TBL_Budget] ( BudgetId INT IDENTITY(1, 1) NOT NULL ,BudgetName NVARCHAR(200) NOT NULL ,BudgetType INT NOT NULL ,BudgetAmount INT NOT NULL ,CONSTRAINT PK_Budget PRIMARY KEY (BudgetId) ) INSERT INTO [DBO].[TBL_Budget] VALUES ('B1',101, 500000) INSERT INTO [DBO].[TBL_Budget] VALUES ('B2',201, 1000000) --------------------------------------------------------------- CREATE TABLE [DBO].[TBL_School] […] |
| SQL Server 2019 - Administration |
| Table Create Date issue? - I'm running SQL Server 19. Is there a known issues with the table create date? (search didn't yield anything) The Create and Modify date are taken from sys.all.objects. I created a database on July 17th and created most of the tables on the same date. Now looking at the Create Date (as part of a […] |
| SQL Server 2019 - Development |
| SSIS Expression Task - Does it even work? - Okay, so I gave up on setting a string variable... and now I'm trying to just set a value for a Boolean variable, based on whether or not a variable with an integer row count is greater than zero or not. This continues to fail with the error: Error: The wrapper was unable to […] |
| SSIS Expression Task - Can you set the value of a NON-Boolean variable? - From what I've seen online in various Google searches, folks have repeatedly claimed to be able to set the value of a variable using an Expression Task, but then the only examples show it setting a value for a Boolean variable as opposed to any kind of string or numeric type of variable. I need […] |
| SSDT |
| how to pass datetime variable from Execute SQL task to the execute process task - i have created two datetime variables in execute sql task and wanted to pass those variable to executed procees task following it. I was able to create the variables in the result set of Execute SQL task but they are not passed on to the next task. any suggestions are welcome. thanks |
| Integration Services |
| Weird behaviour on Excel connection manager and files - I have an SSIS package that iterates over Excel files and it has been working fine without any issue for the past fortnight. Recently, it has been failing when new files are added due to the 'External table not in the expected format'. Nothing about the files have changed, but what I have noticed is […] |
