|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Convert Dates for XML | |
I have a date value stored and I want to convert this with SELECT CONVERT() to a format that works well with XML. What should I use? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
DOP Feedback and QDS In order to use DOP feedback in my query processing, what are the Query Data Store (QDS) requirements? Answer: QDS must be enabled, but must be read/write Explanation: The QDS must be enabled and in read/write mode. Ref: DOP Feedback - https://learn.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing-feedback?view=sql-server-ver16#degree-of-parallelism-dop-feedback |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Development and T-SQL |
Alternate SQL - In my sql result, I want to create a column called RCount. Condition: For each RecNo, AccNo * If the field Reason is "Accepted", it doesn't matter what other records contain for a specific RecNo, AccNo. It should return 1 for the very first instance of Accepted and ignore the rest. * If more than […] |
How do I script the creation of a job to use environments? - I have been googling and googling and I have yet to find a way to check the environment box when configuring an SQL Job using an SSIS package. Specifically, when you configure a step of a job, there is a checkbox to use an Environment as shown in the image attached I have been […] |
Update a row based on MaxDate - Morning all Does anyone know how I can update a table (one row) based on the maxdate of the row? The problem being the id is different for the same item just used multiple times, so all the other rows for the item need to stay the same but the maxdate row needs to change […] |
SQL Server 2019 - Administration |
Permissions to view SSIS SQL Agent job step - I have a requirement for specific users to view SQL Agent jobs through SSMS. They've been granted the SQLAgentOperatorRole and that works up to a point. However for jobs owned by another login, if the job step is a "SQL Server Integration Services Package" type, when clicking on the "Configuration" tab, the "Connection Managers" and […] |
sql server replication Mointoring alert - Hi How to monitor sql server replication i mean there is replication monitor but i wanted to check lag between publisher and subscriber. I mean in log shipping we know how many log files are pending to be applied on dr. In always on its redo and undo logs which can helps to estimate how […] |
SQL SERVER 2019 ... ERROR TO CONNECT WITH A NEW LAPTOP - If I try to connect with a new laptop I receive this error ... (ARCA EVOLUTION SOFTWARE) This error compare also if I try to connect to database with MsExcel please help me to solve ... thks and rgds |
Always on Secondary Database - I want tp create a scenario when I perform failover from Node1 to Node2, I want the database to get stuck in Reverting/In Recovery state on Node1 for longer time so that I can control it until I am done with testing. I know this can be done as index maintenance or big chunks of […] |
Integrated Authentication showing in ErrorLogs - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only Server info Below: Authentication Mode: Windows and SQL Server Authentication SPN is correct |
Azure Data Factory |
Question: Adding set variable activity output to copy data - In azure data factory I created a lookup for getting the id, place. After that in a foreach I used a webactivity to run the an api to get the formatted_address. I extracted the formated_address through a set variable activity. I want to make a new sql table with the id and the formatted_address. I […] |
Reporting Services 2008 Development |
Export SSRS Report Data into Multiple Excel Worksheets Not Working - I am trying to Achieve below task Export SQL Server Reporting Services Report Data into Multiple Excel Worksheets https://www.mssqltips.com/sqlservertip/3527/export-sql-server-reporting-services-report-data-into-multiple-excel-worksheets/ I doing all the Steps as Specified in URL Still i am not getting the Sheet Names As expected. Could you Please let me know the Reason. |
Connecting |
unable to connect to SQL2005 Cluster via instance name with Microsoft Intune pc - We are currently testing a pc deployed and managed using Microsoft Intune. We notice we cannot connect to a clustered SQL Server 2005 instance using the instance name. IMO the problem is that with SQL 2005 the SQLBrowser service always replies using the ip address of the node that hosts the instance. When using the […] |
Integration Services |
SSIS Package to csv and i have some phantom CRLF - I have a script in the SSIS package that goes to a flat file destination. When I run the script in management studio it runs fine no blank rows. When I use the script in the data flow of my SSIS package it randomly puts a CRLF at the end of a 60 rows and […] |
Editorials |
Article review timeline - Hi, I have been frequenting this site for a while and I would like to contribute an article regarding a recent project of securing RDS that I helped with. I have submitted an article for review couple of weeks back and I am curious on the timeline when I can get some feedback on it. […] |
SQL Server 2022 - Administration |
In Place Upgrade of OS and SQL Server - I'm being asked to do an in-place upgrade of both the OS and SQL Server on a physical server. Currently running - Windows Server 2016 Standard SQL Server 2017 Standard Edition (64-bit) Wanting to upgrade to - Windows Server 2022 Standard SQL Server 2022 Standard Is it recommended to update the OS first or […] |
SQL Server 2022 - Development |
Export SQL Data Classification Recommendations - Is there a way export Data Classification recommendations as a pdf or text file? Thanks you. |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |