Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
Full Recovery Database restores as Simple Recovery - Ran into an issue that caused me some issues. It seems that when I backup a database that is in FULL recovery mode and restore it to a different server (just did a large migration to new servers), the database restores in to SIMPLE recovery mode. Before SQL 2017, I never saw this behavior, what […] |
SQL Server 2017 - Development |
need help on query - Hi all, need help on below requirement. Thanks, Abhas |
SQL Server 2016 - Development and T-SQL |
Reducing Temp Table Scans when joining two temp tables using OR conditions - Hi all. I have also posted this on DBA Stack Exchange, but I'm posting here because this community is pretty amazing. If this is not allowed, I will remove. I'm working on a complicated query that I have up to this point been able to refactor to reduce execution time as well as number of […] |
Development - SQL Server 2014 |
Invalid cursor state - HI, Version : Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64) I have a real basic stored proc that inset data to a table. application is calling it via ODBC. Sometime application receive following error sometime not. SQL Error: The statement could not be executed directly - [Microsoft][ODBC SQL Server Driver]Invalid cursor state I […] |
SQL 2012 - General |
Can't attach MDF and LDF files - Hi All When I tried to attach my mdf and ldf file , I got error saying " The process cannot access the file because it is being used by another process. How do I solve this issue ? Your feedback is much appreciated. |
SQL Server 2019 - Administration |
question about username dbo - I have been asked to revoke access from a few developers in SQL Server - basically we want them to be able to read anything, but deny them access to alter objects or data. The users in question are granted access as part of an AD group. So my thought was to create a user […] |
Turning ON TDE Encryption that previously had backups encrypted prior to TDE - In our environment we have been encrypting our backups for years. We now have a requirement to turn TDE on our Databases and I was trying to determine if turning on TDE would impact our encrypted database backups. I understand that in order to restore a TDE Enabled database to another server that the certificate […] |
SQL Server 2019 - Development |
Problem with SUM and GROUP BY clause connection - Hello friends, I will appreciate if someone can help me to sum and later group fields correctly. I almost have the result that I need. However, i noticed that there are a couple of fields where for some reason two columns were not summed therefore not grouped. I was trying to research this topic online […] |
The actual file SQLServerManager15.msc is missing from my computer - I did a fresh install of Windows 10 Pro and loaded SSMS on it. My database is on a different computer so I was going to connect through TCP/IP. I have done it before but I refreshed my memory by looking it up on Google. It told me that I had to find the file […] |
Issue with the format of calculation - Hello friends, This issue is a little hard to explain, but I hope you will be able to understand what I am trying to ask. I believe my issue is that I format the formula in SQL incorrectly. I need to have such a calculation namely f.TOTHIST / (f.TOTFCST - f.TOTHIST) - 1 which will […] |
SQL to display HTML for Dropdown - I have created a webpage with a form that allows people to register for an event. The event will occur on the same day at three different times, 10am, 1pm, 3pm. The event is limited to 10 people per time slot. I'm trying to write a query that generates the HTMLtag based on […] |
General Cloud Computing Questions |
Difference between SaaS and web application? - I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for SaaS. But not always classical SaaS are targeted (e.g. Home Assistant, IoT, Blogging Platforms). What is the difference between web applications and cloud? I'm not a tech-savvy maybe it's still possible someone could explain me the core differences. Thanks in advance. |
Azure Data Factory |
Azure data factory tutorials - Hi all I was wondering if anyone knows where to go for help with azure data factory. I'm trying to use a derived column to create a column from data in another column. The problem is I don't know how to write the expression or where to look for help. The azure documentation isn't clear […] |
Powershell |
Email send issue - I getting an error try to use this piece of code. Error: Send-MailMessage : An invalid character was found in the mail header: ','. Thanks. $messageParameters = @{ From = "xxxx@xxx.com" To = "xxx@xxx.com,yyy@yyy.com,zzz@zzz.com" Subject = "DBLocks " Body = "Job Status" SMTPServer = "xxxxxx" Attachments = $file.FullName} Send-MailMessage @messageParameters |
Suggestions |
Page number in forum topic - Hi all. I’m not even sure if this is the right section to post this question but I have a small suggestion for the forum. Since we have a huge number of threads and topics that lead to multiple pages of threads, why can’t we be able to choose a specific page number among hundreds […] |