New answers tagged

0 votes

How to test whether current sql engine service account can decrypt the SMK?

How can I test whether a service account can access the SMK or not? Try this to open and close the master key. USE <your database> GO OPEN MASTER KEY DECRYPTION BY PASSWORD = '<your password&...
user avatar
0 votes

Row_number to not increment if values on three columns are the same from the row before

Based on your description, what you want should be dense_rank() over (partition by orderid order by DocumentNo_, CurrentPackageTrackingNo)
user avatar
  • 465
0 votes

SQLCONNECTIONPOOL growing very huge

In my experience it was a driver problem. Basically, some application is calling sp_prepare system procedure through an JDBC driver and do not call sp_unprepare. This seems to be a bug in the JDBC ...
user avatar
  • 3,322
0 votes
Accepted

SQL Server 2017 transaction log does not shrink logfile after rebuild index

In the screenshot you show are just trying to release unused space not shrink the log. If your data files are 10 GB and your log file is 60 GB, you do in fact want to get that log file size down and ...
user avatar
2 votes

SQL Server 2017 transaction log does not shrink logfile after rebuild index

Not sure if you have an issue otherwise like Tibor mentions, but if your Log file grew as a result of your index maintenance process, and you have regularly scheduled index maintenance, then there's ...
user avatar
  • 24k
1 vote

I need help with fixing this query please!

We can't help you without knowing your tables structures. What might be wrong, is either: You're joining on fields of two different types, eg. maybe patient_encounter.enc_id is a GUID and ...
user avatar
  • 308
0 votes

error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified when import excel data to sql server

Check your connection string. This Driver=Testserver should be DSN=Testserver if you're using a DSN. Otherwise use a DSN-less connection string.
user avatar

Top 50 recent answers are included