|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Hash Joins IV | |
What is a hash bailout? | |
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) |
Data API Builder APIs What formats of API endpoints can the Data API Builder present to clients when exposing the database? Answer: REST and GraphQL only Explanation: The Data API Builder will expose REST and/or GraphQL endpoints for clients as queryable APIs. Ref: Data API Key Features - https://learn.microsoft.com/en-us/azure/data-api-builder/overview#key-features |
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 |
Send results of a SQL query in Outlook email body - Hello SSC! I hope everyone had a great holiday! Happy New Year to all! Issue: I am currently using SQL Agent to send emails when a job succeeds or fails. The process is basically a bunch of SSIS packages. I also have an attachment that is the results of an SQL query, which UNIONS 2 […] |
Database Archive missing FK - Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger la base de production. Dans la configuration spécifique de la base d'archivage, il a été décidé qu'elle ne contiendrait pas de clés étrangères (FK), ce qui fragilise davantage la base. En effet, un TRUNCATE TABLE pourrait être effectué sur toutes les […] |
SQL Server 2012 - T-SQL |
convert to date - I have a field called DueDates in table where they stored a Date value as Char(10) . mm/dd/yy How can I get it to true date so I can perform logic like to find all DueDates > 10/01/2022 I tried cast and convert but when I apply logic DueDates > 10/01/2022 it doesn't find correct […] |
SQL Server 2019 - Development |
Join 2 tables - Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N ServerA T ServerB D ServerB E ServerC C ServerC D ServerC E Table B ServerName ColB ColC ColD ColE Date ServerA Z 100 200 ABC date1 ServerB D 1000 10 DEF date2 ServerB X 1000 10 DEF date2 ServerC C 11 […] |
Impact of Not Including Foreign Keys in an SQL Archive Database - Hello everyone, I am about to start a data archiving project that will affect almost all tables in my SQL database. To facilitate this process, I have created an archive database with the same schema as the main database but without including foreign keys to ease the insertion order. My question is: What are the […] |
how to fix this error? - hi I am creating a stored procedure to reduce log size when needed. I want to explicitly state which db to use but I am getting an error. How can I fix my sp so it knows which db to use? Code: ALTER procedure [dbo].[ToolReduceLogFileSize] as USE myDB CHECKPOINT DBCC SHRINKFILE (2,1024) Error: Msg 154, […] |
what if my last resort on extracting excel is at the cell level? - Hi, after i copy in ssis my excel file to a secured folder, its looking more and more like i'll need to get data out of the destination spreadsheet at the cell level. i'm looking at posts like the one at https://stackoverflow.com/questions/41702840/i-need-to-pull-specific-cells-from-a-single-excel-file-to-create-a-single-row-in but dont believe power query is the answer because 1) its an add […] |
dont see a file system task approach to copying excel - Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-and-move-to-a-new-location-using-ssis where content rather than file level copying is done, i'd like to use the file system task to simply copy an entire excel file from one folder to another. i may be missing something but i dont see that option in what the file system task would […] |
need community help on 1 final cdata odbc driver product eval question - Hi, for whatever reason, CDATA is conflicted about answering 1 remaining disclosure type question before we conclude our eval of their netsuite odbc product. Their product is installed on our sql server. together with its related objects (dsn's etc as describe in paragraph 5) that are also installed on our sql server, their purpose […] |
how to calculate an average only if a minimum number of records exist? - Hi I am working on a rolling average calculation that is not working quite right. Here is the code: AVG(T1.PRICE) OVER (PARTITION BY T1.UNIT ORDER BY T1.DATE ROWS BETWEEN 19 PRECEDING AND CURRENT ROW) This will calculate a rolling average using the last 20 rows including the current row. This works great if there are […] |
dont want pkg to abort if someone is in excel source document - Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone has it open? in my mind analogous to a dirty read in sql? maybe read what it had at last save? i'd hate to have an error handler alerting the file owner for hours […] |
Reporting Services |
Page break in multi column paginated report - Hi, I have created a multicolumn paginated report, which includes a subreport that I want to break at the group level (based on the "Date" field). Currently, the report is breaking at the column level instead of a page break at the group level. Steps I've taken so far: In the subreport, I created a […] |
Powershell |
create multiple output files based on query - I have this script that puts all of the output from query to a single file. Could it be changed to create multiple files based on query results? The query will find like a months worth of information like this in the table based on the Like condition. 20240501 20240502 20240503 Instead of creating 1 […] |
SQL Server 2022 - Development |
Using a RETURN - How does this capture multiple values from a cursor, and put them into an email message? DECLARE @SINGLE_RETURN char(2) = ISNULL(char(13), '') + ISNULL(char(10), '') (here are statements of a cursor that finds unencrypted databases) (then, EACH database name is put into a single message, (before I was sending an email with each cursor/database by […] |
Problem installing SQL Server 2022 - Hello, I currently have an instance of SQL Server 2019 Developer installed on my computer. I'm trying to uninstall it so that I can then install SQL Server 2022 Developer. I don't want two instances of SQL Server on my PC and since it's just a local development instance for my C# projects, I don't […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |