|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
SSIS Catalog Object Names | |
I want to rename a project in my SSIS Catalog. Which of these is a valid name? (ignore the quotes) | |
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) |
Operator Precedence Which of these has the high precedence among T-SQL operators? Answer: ~ Explanation: The binary not, ~, has the highest precedence of all operators. Ref: Operator Precedence - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql?view=sql-server-ver15 |
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 2017 - Administration |
cannot generate SSPI context - We have one user who face this issue while connecting to SQL server ''Cannot generate SSPI context" (win authentication) When i checked the user account the account looks good and there is no password issue. Same user is able to connect SQL using command prompt. what could be the reason |
Database Corruption - LOB - Hello, I have recently inherited a SQL 2012 database (no backups available), running in SQL 2005 compatibility mode with Filestream enabled. The first error, I received was: Error: 3043, Severity: 16, State: 1. BACKUP 'mcs_mia' detected an error on page (3:1484827) in file 'e:\BLOB\mcs_mia.ndf'. When I ran DBCC check, I received several of these errors: […] |
SQL Server 2017 - Development |
arabic digits stored in varchar column with Arabic_* collation - Hello, FYI Database collation is Arabic_100_CS_AS Why do Arabic characters in a varchar column (collated as Arabic_100_CS_AS) get handled correctly (inserted and displayed) while digits get transformed into their Latin equivalent? We know that NVARCHAR is able to handle this correctly but we still want to know what goes wrong with our varchar column in […] |
SQL Server 2016 - Administration |
Partitioning and Indexes needed on huge table - I have a table with 24,000,000 records and 140 fields. The records can be divided into 3 years for a partitioning. I'm still quite new to doing indexes and partitioning and any tips would help. I'm thinking of course I need to do this at night when no one is on. Also I'm using SQL […] |
Databases status are recovery pending - Hi All , After SQL restart most of databases turned to be Recovery pending . The restart happened at primary server and automatic fail over happened. moreover the listeners are gone. i couldn’t remove db from AG either . Couldnt bring database online.. When i right click , no option to add listener . Appreciate […] |
Remove database from Distributed Availability Group replica AG ONLY! - Hi, all! I have an existing always on availability group on-prem and last week created a second one in AWS. After that, I created a distributed availability group with on-prem as primary and AWS as the replica AG. Being new to SQL Server, I configured automatic seeding without thinking for a second that it would […] |
Finding all logins that can alter DDL - Hello experts, Is there a ready-made query out there that I could run on a server to list all the logins that have the ability to alter DDL in any of the databases? I know some of this can be retrieved by finding members of db_ddladmin, but there could also be individually granted permissions for […] |
SQL Server 2016 - Development and T-SQL |
Replace Numbers - My goal is to replace the numbers 1-9 in a column with a different number. For this example the numbers would change to 1=7 2=3 3=9 4=1 5=4 6=2 7=5 8=6 9=8 I tried using the replace function shown below but my problem is a value keeps getting changed as it progresses through each replace. […] |
Development - SQL Server 2014 |
How to redesign a query - Hi Result is determined by the calculated Usage, With the below query, the result for the last output row is 0 because usage is based on the previous date and value (using LAG). How can I rewrite this so that the calculated usage is based on the previous date and value where the result is […] |
SQL 2012 - General |
SQL Server SP updates - Hello, I have a SQL server I'm managing that needs to be updated from SQL server 2012 to SQL server 2012 SP3. I inherited this box so no updates have been applied to it in regards to CUs and SPs. Is installing SP3 right off the bat a bad idea, should I install SP1/SP2 first? […] |
SQL Server 2019 - Administration |
Cannot connect to Existing Replica - Dear Friends, I setup a test run case on 2-Node AlwaysON , on developer edition.The issue is I want to add another replica to this but the connection doesn't happen in the first page of the Add Replica wizard (please refer attached file for the error). I can though connect to both the instances well […] |
SQL Server 2019 - Development |
How do I join two temporary tables using MySQL? - Hi all, I'm still pretty new to SQL and could use some help getting this query to work. The ultimate goal is to join two temporary tables. In the first temporary table, I pulled all of the distinct rows from a table called 'Table A' and used a JOIN clause to combine it with a […] |
SQL Server 2008 - General |
Insert records with a where - I want to insert record job allocations only for selected jobs I know the following code won't work form the WHERE part but this gives you an idea of what I want achieve. TIA. INSERT INTO dbo.WipJobAllLab(W.Job, Operation, WorkCentre, IExpUnitRunTim, Milestone, IWcRateInd) VALUES(W.Job, 1, '001', 0.01, 'N', 1) ... "WHERE SELECT W.Job FROM dbo.WipMaster W […] |
Insert records with a where - I want to insert record job allocations only for selected jobs I know the following code won't work form the WHERE part but this gives you an idea of what I want achieve. TIA. INSERT INTO dbo.WipJobAllLab(W.Job, Operation, WorkCentre, IExpUnitRunTim, Milestone, IWcRateInd) VALUES(W.Job, 1, '001', 0.01, 'N', 1) ... "WHERE SELECT W.Job FROM dbo.WipMaster W […] |
SQL Azure - Administration |
Row Level Security - Dear Experts, How can we implement row-level security on Azure when the application is hitting the database using a managed identity. How the same can be implemented on On-prem when an application uses SQL credentials or a windows account? Currently, the application hits the DB using a managed identity and application authentication is based on […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |