Laden...
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Quantums | |
The time a worker can remain active in a scheduler is called the OS quantum. What is the maximum length of time for a quantum? | |
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) |
Restoring a Certificate I use the BACKUP CERTIFICATE command to back up a certificate from my SQL Server 2019 instance to a file. I want to restore this on another instance. What command do I use? Answer: CREATE CERTIFICATE, LOAD CERTIFCIATE Explanation: The CREATE CERTIFICTE command is used to restore a certificate from a file onto an instance. Ref: CREATE CERTIFICATE - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-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 2017 - Development |
Left Join with reference data. - Records Refrenace | DataMaster DataKey 1 A | A 22 2 B | B 33 3 C | C 44 4 E | 5 F | 6 G | 7 H | 8 D | 9 R | For the Above which is not in the Master data I need to set it as 'Unknown' […] |
SQL Server 2016 - Development and T-SQL |
Left JOIN Works Appears to Only Work with Certain Table - Hello Community, If I execute the following query on table name optionsettransposedall_copy: SELECT C1.Id ,C1.SinkCreatedOn ,C1.SinkModifiedOn ,C1.statecode ,C1.statuscode, CASE WHEN ISNULL(CAST(C1.prioritycode AS VARCHAR(50)),'') <> ISNULL(CAST(C2.prioritycode AS VARCHAR(50)),'') THEN CAST(C2.prioritycode AS VARCHAR(50)) ELSE CAST(C1.prioritycode AS VARCHAR(50)) END AS prioritycode FROM ( SELECT *,ROW_NUMBER()OVER(ORDER BY prioritycode)RowNum FROM appointment )C1 LEFT JOIN ( SELECT *,ROW_NUMBER()OVER(ORDER BY prioritycode)RowNum FROM […] |
Administration - SQL Server 2014 |
Sudden rise in memory - Hi How i can check which process was run that Sql memory suddenly increased. Thanks |
Development - SQL Server 2014 |
SSRS Rendering format Excel Change ? - I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file so the default cell format is text and not General. If not, is there any way to format my fields in the stored procedure so when I download to Excel it formats as text? Thanks |
SQL 2012 - General |
Urgent help needed. MS SQL Server 2012 - Hi, I've just got a call (6pm on a Friday!) from a customer who has had his line-of-business application provider sell him a solution which required SQL Server 2012 Standard, yet the supplier (joyfully) installed the evaluation version of SQL Server 2012 Enterprise. This has now ticked over and expired. My problem is that (a) […] |
Merge Replication or Back up and Restore - Hello I have a database copied on two servers. Same name. I have tried a merge replication but it keeps failing on various objects. I have removed objects one by one and left with the bare minimum tables and still won't work. Users won't mind using one database as master and do all the updates […] |
SQL Server 2019 - Administration |
Extending High Availability Group into Azure - Hi I've been asked to extend a HAG which is currently on premise to include an azure vm sql instance. currently i have a 3 node cluster, two nodes in on city with synchronous connect and auto failover and one in another city with asynchronous connect and manual failover. I want to add an azure […] |
Intermittent Witness Failures - Hi guys, Any one experienced in working in GCP with SQL Clusters? My File Share Witness intermittently failing but I cannot work would why. It will be in failed state and then I'll bring it online and its fine for a while before going off again. Below the the only error I can fine. I […] |
SQL Server 2019 - Development |
Return data from a calendar table with associated active events - Hello, Thanks if you can help. I am trying to build a view that returns all calendar data for a date range and any associated events if the event is active on that day. I am getting error "An aggregate cannot appear in an ON clause unless it is in a subquery contained in a […] |
Calendar table in SQL - Hi guys Could you please help me to build a calendar in SQL, with the normal holidays from Portugal. Is this possible? Or....is there any chance of getting the holidays from Portugal for a specific year (2019-2022). I looked everywhere but i must be looking the wrong places.... Thank you all very much for helping […] |
Amazon AWS and other cloud vendors |
Possible to use SCP’s to enforce readonly console access? - We wanna foster a culture where all changes and deployments happen through CICD, hence we dont want to allow our users to have any write permissions when using the console. Alternatively we could probably enforce it using permission boundaries on all users/roles, but SCPs would be so much easier to manage. Anyone who have done […] |
General Cloud Computing Questions |
Could an API reduce latency vs a Direct Cloud Database Connection? - Recently, a potential client at work has requested that we provide an API in the cloud as opposed to a direct database connection for a cloud database. The application we’re developing is a Desktop application that will require a significant number of queries throughout the day. In the past, when clients have tried to move […] |
Reporting Services |
Can I filter a table based on parameter IIF statement, otherwise no filter? - Hello! I have a dataset that has daily stats with days specified as Weekend/Weekday, and I have a parameter ("@Daygroup") to represent this. I'd like the report users to be able to filter the data by this field, but also have the option of viewing everything/both. Currently, it's inside a table in which I've only […] |
Integration Services |
Replace function in SSIS Expression - hi, I have files that are coming in .txt files. Example MA.textfile1.txt ,MA.textfile2.TXT . I need to replace the file name after i process these files. I have a foreach loop to get the file names , and file system task to rename files. However i have set up variables within file system task, if […] |
Anything that is NOT about SQL! |
Web site font colour/background colour and readability - Hi everyone I'm just interested in getting peoples about the readability of many web sites as far as the general words in sentences (not headings). Maybe it's my imagination, but it seems to me that there seems to be a tendency for there to be a lack of contrast these days between the font colour […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
© 2024