Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2016 - Administration |
Logshipping - I have a requirement to configure logshipping on a database , where mirroring is configured . i need to setup the logshipping to the primary database which is in mirroring . But multiple secondaries on the same secondary instance with diferent names of the primary database . as the sql is ql 2008 vesrion. how […] |
ExecuteScalar: CommandText property has not been initialized - One ASP.NET project keeps on receiving a message below from "Try...Catch...End try" block. System.InvalidOperationException: ExecuteScalar: CommandText property has not been initialized I searched Google but can't get help. Is this SQL script mistake? Please help. --------------------------------------------------------- It points at a function from app below dim iCount as Int32 = 0 dim SQL as string = […] |
How to stop database restore that survived reboot showing progress in error log - SQL Server 2016 SP CU7 on Windows Server 2012 R2 Standard. Backstory: Agent job runs daily that performs restore of database in about 30 minutes (360G MDF). All of a sudden one day restore still running hours later. Waited it out. Ran in 18 hours then several hours later early morning restore ran as normal. […] |
using Powershell scripts to do SQL backups - Hello, hopefully this can be a straight forward question, but at the same time, looking to get some advice and if possible experience from someone that tried this... but as the title says, My company has large databases, about 1.5 tb, and dont want to invest in software, but of course we do have good […] |
SQL Server 2016 - Development and T-SQL |
CONCATE_WS Not Recognizable - I am trying to use the CONCATE_WS function in SQL Server 2016 but receive the following error. Here is my code and the error. Why is this not working and is there a fix? I need to be able to separate the concatenated columns. Intellisense will pick CONCATE_WS up as a selectable option as I […] |
Query plan for scalar UDF not displaying in my execution plan - Hello, I am running SQL Server 2016 SP2 with 130 compatibility mode. SSMS version 18.5 My understanding is if I run a query that calls a scalar udf, my execution plan will have a double-pane, with the top pane having my exec plan with the Compute Scalar operation. And there will be a bottom pane […] |
Need Help to write a query - I have a table like this I need to write a query to get the following output Columns Tenor, 0, 0.5, 1, 1.5, 2, 2.5, 3, ....... , 10 (0 to 10) Sum of Count of Col A and Col B where Col values are >= the abs values of the columns For 0 […] |
Nested FOR XML Problem - I have the following data and I want to generate XML where the transactions are nested under the position for the relevant asset. CREATE TABLE #temptable ( [bp_sym] varchar(50), [person_key] varchar(100), [bargain_date] date, [disp_acqu_text] varchar(9), [quantity] decimal(12,2), [cumulative_qty] decimal(12,2), [book_cost_change] decimal(12,2), [cumulative_book_cost] decimal(12,2), [swim_refs] varchar(6), [security_code] char(7), [asset_name] nvarchar(4000) ) INSERT INTO #temptable ([bp_sym], [person_key], […] |
SQL 2012 - General |
Configure logshipping - We have a requirement to configure logshipping on a mirrored databasé on sql 2008 server ,also to configure the lògshipping for multiple databases on the same secoñdary server.how can we coñfiguré. |
Run same query on multiple servers with sqlcmd and save the output - Hello, I have this 3 lines: sqlcmd -S "Server1" -d -U -P -i query.sql -o result.txt sqlcmd -S "Server2" -d -U -P -i query.sql >> result.txt sqlcmd -S "Server3" -d -U -P -i query.sql >> result.txt If I copy and paste this code to a cmd […] |
SQL Server 2012 - T-SQL |
Merging date based on start and end date - I have tried to group/merge dates (Min/Max) but due to same data at line 1,2 and 4 , its not working as expected. Thank for looking into it. create table #Temp ( ID INT, Status_ID INT, StartDate DATE, EndDate DATE ) INSERT INTO #TEMP SELECT 101,1,'01/01/2020','01/28/2020' UNION ALL SELECT 101,1,'01/29/2020','01/31/2020' UNION ALL SELECT 101,5,'02/01/2020','02/29/2020' UNION […] |
SQL Server 2019 - Development |
create view out of dynamic query from INFORMATION_SCHEMA.COLUMNS - Hi, Is there a way to create a view out if this query below? DECLARE @query nvarchar(max) SELECT @query = STUFF( ( SELECT ' UNION ALL SELECT ''' + TABLE_SCHEMA + ''' AS SCHEMANAME, ' + '''' + TABLE_NAME + ''' AS TABLENAME, ' + 'LEFT(''' + TABLE_NAME + ''', 3) AS SYSTEM, ' + […] |
Reporting Services 2005 Development |
Average in a Matrix - Hello I'm using the Matrix Wizard and everything is working right except one total that I modified. See image: The detail columns total at the bottom and along the row without any problem. But in my last column 'Avg FTE' I'm trying to get an average. The average works across the row, but not at […] |
SSDT |
SSIS Expression help - Hi Guys,/ Is anyone can help me convert this SQL to SSIS Expression? SELECT DATEADD(DAY,DATEDIFF(DAY,0,CONVERT(DATE,DATEADD(WK,DATEDIFF(WK,0,GETDATE()),0) - 8)), '00:00:00') Thanks in Advance. |
Design Ideas and Questions |
Columnstore Index and Nonclustered Index on Table - We have a table definition below with a columnstore index and nonclustered row indices. The data in this table increases 10K per day and in a year can have 400K ColNumber with each having 1 to many ColProperty. This table will be used mostly for reads/reference and hardly have updates. Would it be beneficial to […] |