|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Assigning a Server Role | |
I want to create a new Server Role for my SQL Server 2019 instance, but I want another server principal to own this role. What should I do? | |
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) |
DML Trigger Limits I am writing a trigger in SQL Server 2019 on a partitioned table. When certain data is inserted, I want the trigger to switch partitions on the table. Can I do this? Answer: No Explanation: An ALTER TABLE that switches partitions is not allowed in a DML trigger. Ref: CREATE TRIGGER - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver16 |
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 |
Null value when checking unused indexes - I'm using this query to check if I have any unused indexes.. One of the tables it display's has lots of user_updates but the indexname field is NULL... There is a non-clustered index on the table No fill factor and page fullness about 50% and 98% fragmented. Min row size 42 and max 74 avg […] |
Degraded performance with extended event session - We have noticed that our nightly jobs take 2-3 times longer when the following extended event session is running. There is a clear deterioration in server performance across two separate servers running the same XE, even though there is not much data being written to the target files by the sessions (only a few MB). […] |
Administration - SQL Server 2014 |
Replacing Physical Server - Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my head stage but need some advice. Thinking I can setup the new hardware with the exact same OS, SQL version, instance name but with a different server name. Then when the new server is setup […] |
SQL Server 2012 - T-SQL |
mdf space balance - I have a DB that is running out of space on a drive... If I add another data file will the drive that is running low run out of space, or will it use the new data file just created. How does it balance data consumption. Thx. |
Using Case with DATEDIFF for Aging Report - I need help to create a Aging report, I am not retrieving the correct amounts. I am wondering if I need add debit and credit first and then the dateiff |
SQL Server 2019 - Administration |
Is it best practice to change the password for distributor_admin? - Hello, Our audit team has decreed that all logins should password policy turned on for all SQL Server logins. They also decreed that the login password needs to be 32 characters. I found the command to change the password: sp_changedistributor_password The question that I have, is this something that is going to break my replication? […] |
SQL Server 2019 - Development |
Multiply time by hourly rate - Hello all, I have this table with time for each row. It shows hh:mm. I have rows with all kind of time, 6:30, 5:10, 5:00, 6:42 etc, and I have to multiply it by the hourly rate. Could you please help me? I think I have to, first convert this time column into a number […] |
Compare 2 tables and highlight where the column values has been updated - Hi All, I have a requirement to compare data from same table with different snapshot dates and highlight what column values changed from to TO Can any one help me with above requirement please? Regards, R |
Best primarykey and index - Hi all, i've to refactor a database with several tables with around 100.000.000 records each one. Each table has the following relevant columns: - ID (bigint) - Tenant (actually i have 10k tenants) - Year (all info has Always a filter search by year) - other 10/20 simple columns I was thinking to have: 1) […] |
stored procedure not running - Created a stored procedure and logged in SSMS as Administrator and this user is exists in the Security > Logins I'm able to successfully execute the sp using T-SQL. e.g, declare @output_execution_id bigint exec dbo.int_Bill_Run @output_execution_id output Now, when I add it SQL server agent as a job I get errors - Executed as user: […] |
Azure Data Factory |
API Configuration help ADF - Hi I am trying to connect to a HR system to simply pull down some data and copy in ASDB I have managed to get it to work in excel using the following code below in the advanced editor but dont even know where to start in terms of where i put this information in […] |
Reporting Services |
Empty Field is causing entire Page to be blank - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] |
Empty Field is causing entire Page to be blank - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] |
Powershell |
Retrieve Password from CyberArk using powershell - Hi, I am new to Powershell script and i have to create a power shell script to get password for SQL service account from CyberArk.. Could you please suggest how to do that ? |
Integration Services |
Retrieving Active Directory information - I have a requirement to process AD information through an SSIS package and have hit a problem with the "objectClass" attribute. The ADO.NET source is configured as: and the package has converted all of the output data types to NTEXT. This isn't an issue for most of them as I've converted them to DT_STR using […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |