How do I pass a parameter value in a function when using a join?
I am finding other solutions. I know my SQL Server query is not correct, but I need help to resolve the issue.
Below is my query and what I want to achieve with it for better understanding.
Why does this error appear when querying the database?
When querying tables in the database, this message appears even though everything is correct
How to fix the 08001 sql native client error
Im at a new workplace that has a sql server setup where all the office computers can access and modify a database through an application.
SQL Server connects remotely from any network but not local network
I have a server with two SQL Server instances on it.
MS SQL connecte remotly from any network but not local network
I have MS server with two SQL Server instance on it.
Shrink Data and Log file of a MS SQL database
We had a MS SQL database in which one audit table grew big to 5TB (due to an oversight). We identified unwanted records from this audit table and have deleted these records from this table. Now the total size of the tables and indexes is about 20GB, however the data and log file size still stays at 5TB. After looking through various forums, i found that we can reduce the data and log file size using