Code pattern is:
SELECT
fmt.id
, fmt.name
FROM OPENROWSET(
BULK 'path\to.csv'
, FORMAT = 'CSV'
, FIRSTROW = 2
)
WITH (
id nvarchar(50)
, name nvarchar(100)
) AS fmt
Error is 'A correlation name must be specified for the bulk rowset in the from clause.' Only on SQL Server 2017. Thanks! 2/2
#sqlhelp
Anyone else having trouble with OPENROWSET BULK on SQL Server 2017, getting errors when trying to provide a schema definition? Doesn't happen on later editions, just 2017. (Also doesn't seem to like ROWTERMINATOR despite that being in the documentation, but that's a secondary concern.) 1/
#sqlhelp
In PowerQuery you can reference a variable just by its name. But you can now also put an @ in front of the name. Is this just syntactic sugar, or does the @ add some extra functionality?
#PowerQuery #PowerBI #sqlhelp
#sqlhelp This feels like a stupid question but what permission is required to view a database in sys.databases? I have a SQL Id that has db_owner on databaseA, but can only see databaseA in sys.databases when the current context is databaseA.
#sqlhelp
Hey #sqlserver peeps!
I’ve spent hundreds of hours using Diskspd on Windows; hoping to use it for the first time on Linux today!
Any gotchas/rave reviews to share?
Thanks!
(Working with bursty read tests, up to 10000 mb/s with 64k random reads)
When you download #SQLServer 2025 RTM Std&Dev Edtn, by default it uses #PID "33333-00000-00000-00000-00000"
Is that actually Dev Edtn with only Std features ?
#SQLHelp
screenshot from azure portal cost analysis page
#sqlhelp #azuresql
Hyperscale billing.
I know the first two line item. Computer + allocated space. What is the third one?
Any tips for getting SQL Server Database Mirroring working on PC with 3 instances (primary, mirror and witness). PC not connected to domain so instances are run using a user account which is sysadmin on all 3. TCP enabled and mirror endpoint created, but won’t start as it fails to connect #sqlhelp
#sqlhelp Has anyone figured out a way to change the time zone setting on an Azure Managed Instance? I know the documentation says it's not possible, I'm just hoping it's wrong or out of date or maybe someone figured out a hack?
#sqlhelp
I want to deploy a SQL db project to Azure SQL via GitHub actions. I'd like to deploy it as a data tier application and increment / set the version when I deploy via gh actions. How do I do that?
Does anyone know of a way to get the number of ghost records in a #sqlserver database without using dm_db_index_physical_stats? I don't want the impact on the primary of an AG or to block redo on the secondary when running it. #sqlhelp
I have observed 2 sql servers 2022 that consume significantly more CPU and with prolonged execution time after patching from CU 19 to CU 20.
Both running AMD Epyx.
Anyone else who has observed similar issue with CU20?
#sqlhelp
💡 Got a burning question about #AI, #PowerBI, or #MicrosoftFabric?
Purple Frog's expert consultants are here to help.
Drop your questions below, and we’ll answer them in upcoming posts! #DataAnalytics #SQLHelp #DataExperts #QandA
Has anyone successfully turned on mirroring for fabric on an Azure Managed Instance? #sqlhelp
Honest question for #SqlFamily ... Am I the only one who noticed that my computer gets all slow and stuttery every time I open the new #SSMS v21?
#SqlHelp #SqlDBA #SQLServer
#sqlhelp anybody using SDK Database Projects in VSCode w/extension? Trying to get Schema Compare to save changes to my project and it keeps failing. Is ADS the only way to update the project currently? My GitHub action reBUILDs the dacpac to properly exclude things, so I need the project updated.
🟢 View my Upwork profile here: www.upwork.com/services/pro...
#UpworkDeveloper, #FreelanceDatabase, #SQLHelp, #DatabaseExpert, #HireFreelancer, #MySQLDeveloper, #PostgreSQLExpert, #SQLPerformance, #ETLSolutions, #DataCleaning, #SQLQueries, #DatabaseConsulting, #TechFreelancer,
I noticed avg write stalls on tempdb of over 100ms. I raised the issue and was told it doesn't hurt user queries because those writes happen in memory. I always thought writes to data files were physical IO that happen during working in tempdb. Can someone clarify?
#sqlserver #sqlhelp
Does anyone have a case where the Azure portal is reporting Query Store is off for a SQLDB but find it's actually on when looking at the database? #sqlhelp
I've a db proj to deploy to Azure SQL DB. Enabled Change Tracking on tables and have proc to CT tables. I get an error that tells me when it deploys that it will cause issues with the proc, though I have a line to ensure that CT is on for the tables. What can I do to get around this? #sqlhelp
If you get totally stuck there's a decent SQL community here on bsky.
There used to be #SQLHelp on twitter but not sure there's a feed for that here.
Happy to connect you with folks if needed.
Hey #SQLHelp fam - I'm trying to transition from Azure Data Studio to VS Code (stupid retirement), and I can't find an equivalent of the Import extension. I need the flat file import tool. Any recommendations for equivalent VS Code extensions? I've got the available MS extensions installed.
#sqlhelp #dbatools I have code that generates a token and then uses Connect-DbaInstance. It works currently but when I add -AsSecureString to Get-AzAccessToken I get an error "Error connecting to [xxx]: Login failed for user '<token-identified principal>'." from Connect-DbaInstance. Any ideas why?
Also, I did just confirm that checktable was run after the stack dump and before the index rebuilds. It came back clean, and my understanding is that chrcktabke will check indexes. So, this still feels like some sort of bug in 2017 with the create columnstore index process.
#sqlhelp
The text file for the dump doesn't appear to have a page number in it where I can identify something to use dbcc page against.
As far as the crash error, the text file just shows:
Location: xxchng.cpp:4479
Expression: pbcCurrent ->FParallel()
Followed by the spid and imput buffer.
#sqlhelp
gives you the page number of the problem page. Then read that page with DBCC PAGE and see if the page is corrupt or not. If it is, then need to figure out if it's disk or SQL that corrupting the page (99.999% chance it's storage).
What specific version are you running? #sqlhelp
