|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Minimal Linked Server | |
What is the minimal number of parameters to add a linked server with sp_addlinkedserver? | |
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) |
The Internals of Writing a Page In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes? Answer: For torn page protection, an exclusive latch is used. For checksum, an update latch is used Explanation: Torn page protection requires an exclusive latch, preventing other threads from reading. Checksum uses an update latch, which allows other threads to read, but not modify. Ref: How SQL Server writes a modified data page - https://learn.microsoft.com/en-us/sql/relational-databases/writing-pages?view=sql-server-ver16#how-sql-server-writes-a-modified-data-page |
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 2019 - Administration |
SSPI handshake failed error code 0x80090311 - Hi, I have a workstation with SQL Express 2019 installed and I have a PC with a .NET application built in VB.NET. The App logs in as Attendance and the SQL PC logs in as Phone System. They are on the same domain and the SPNs match the server and Attendance has access to the […] |
SQL Server 2019 - Development |
Merge spans with Dates Logic - --for a given member if the startdate and endate is continous we need to keep in single record and if start date and end date is not continous i need to keep in separate record for a given member. drop table #test create table #test (ID int, startdate datetime, enddate datetime ) insert into […] |
Problem creating a Linked Server to MS Access 97 database from SQL Server 2019 - Hi there I need help on creating a Linked Server to an MS Access 97 database from a SQL Server 2019 express instance. We have a SQL Server Express 2019 instance and we are trying to create a Linked Server to an MS Access 97 database located on a network drive. Now I know that […] |
continuous membership - Hi, I am trying to find everyone who had membership for a continuous year without any gaps. The sample below shows two members, one who is correct,760890291, and should be returned but the other one, 82928404, should not but it does. My code is below. What would I need to change? Thanks. CREATE TABLE […] |
SQL Azure - Administration |
Azure Managed Instance Backups - Could Backup Be Completely Lost? - Some of our more regulated customers (banks, gambling sites and suchlike) like to know that we have a robust and tested recovery routine. We use Azure Managed Instance (MI) and the backup/restore process for 'normal' requirements is quite simple. But this had me thinking - is it possible for Azure to be in such a […] |
DP-300 exam - Hi, I would like to know if anyone has taken the DP-300 exam recently, so that they can recommend some material for me to study. The company I work for has taken on a project and I need to get this certification as soon as possible. Thank you. |
cleanup/dropping of all interimtables - Is there a [best] method of dropping all interim tables within a Azure SQL database. I have inadvertently, with some pipeline fails, created an awful lot of them. If there is a way to do this in one query it would be really helpful. |
Reporting Services |
Multiple value Parameters in SSRS connecting to Teradata returns error - I am connecting to Teradata using SSRS and have multiple parameters, many of them that seek multiple values. The challenge is all these parameters may not be always filled, sometimes it could be blank. So I am using a logic as below - Select * from Table Where (Param1 in (?) or ? = '') […] |
Integration Services |
SSIS Automatically Coverting a NULL to a Blank Space - Hello, I was wondering if anyone knew how to prevent this issue I am experiencing. I have a SQL Source with a query that is just selecting data where fields are casted as a varchar value. When running the query in SQL Server, the values either have a valid value or are null as expected. […] |
how to export clickable urls in excel from SSIS - I'm using ssis to copy excel file from a template, and update some cells on each copied files. problem is that after generating the Excel filen when opening it, the cell that is supposed to contains the clickable url is still I have to select the cell, then click on the formula bar and then […] |
PostgreSQL |
Need query help - MAX record - Hello - I have attached a Word document here with details about my issue. I have shown an excerpt from the main table in the first section. There are 5 different records for the subscriber in question. The second section shows how the MAX command restricts the output to 2 records. This output makes sense. […] |
Need query help - MAX record - I am having trouble writing linking the MAX query that I created back to the table to produce other data elements about the MAX record. I have created a Word document showing an excerpt from the main data table, how the MAX query pulls in the appropriate records, but then I am stumped on how […] |
SQL Server 2022 - Development |
Merge data from two different source until the data is available from both sourc - I have two sources , one coming from datalake and another is file. we need to match date to combine both dates. But , the data from source may not be avilable daily or might be delayed. So, we have data from datalake coming daily but data from file comes only from Tuesday - Saturday […] |
Migrating data from using ManagerId to HierarchyId - I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id] [smallint] IDENTITY(1,1) NOT NULL, [FirstName] [nvarchar](50) NOT NULL, [LastName] [nvarchar](50) NOT NULL, [LineManagerId] [smallint] NULL, [OrganisationLevel] [hierarchyid] NULL ) ON [PRIMARY] GO LineManagerId is a FK to the People.Person table to identify the person in the table who is the Person's […] |
Parse SQL XML column into dynamic temp tables - Hello SSC, I hope everyone is happy and healthy and ready for spring! I am looking for some alternatives to parsing an XML column in SQL. I have over 1000 rows in XML format that I would like to parse one time into a SQL table or multiple SQL tables. The caveat is that the […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |