|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Unlimited Text | |
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run? | |
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 Minimal Linked Server What is the minimal number of parameters to add a linked server with sp_addlinkedserver? Answer: 1 Explanation: The minimum is 1. With a SQL Server linked server, this is a valid command. EXEC master.dbo.sp_addlinkedserver @server = N'Aristotle' Ref: sp_addlinkedserver - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-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 |
Question on SQL Query with NOT condition - I have a record, in those the three columns where firstname / last name and full name is empty. ID = 198765 FirstName = empty LastName = empty FullName = empty Flag = 0 I am trying to pull the record with ID 198765 out from select query where first and last or full name […] |
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 |
isnull, coalesce overhead - hi, one of our sister division's erp extract view is going thru at least one mod to do the equivalent of a coalesce on a column that if null brings down our dw load job. since they were doing that i asked if they could do the same on all columns that had never be […] |
is there an elegant way for agent notification to show failure if any step fails - hi our corp dw load sqlagent job goes to the next step on the 14+ erp loads if they fail. but quits notifying of failure on any cube step at the end. most of the loads are ssis but there is some t-sql too. without making the job really ugly, is there an elegant way […] |
is there an elegant way for agent notification to show failure if any step fails - hi our corp dw load sqlagent job goes to the next step on the 14+ erp loads if they fail. but quits notifying of failure on any cube step at the end. most of the loads are ssis but there is some t-sql too. without making the job really ugly, is there an elegant way […] |
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. |
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. […] |
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 |
CAST(VARCHAR(n)) resolved performance issue? - Hi, I would love to hear if anyone can tell me why a CAST in a query can "resolve" this performance issue. Same symptom on test server with a copy of the database. weblab_reportlog = 207 850 195 rows Requisitions = 30 143 466 rows DBCC FREEPROCCACHE SELECT [LID], [Datestamp], [logmessage], [Reporttype], [UserID] FROM [dbo].[weblab_reportlog] […] |
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 […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |