Viewing 15 posts - 2,086 through 2,100 (of 39,860 total)
Should be, they have it linked and listed from multiple places.
May 12, 2021 at 4:32 pm
It's helpful if you post data in a consummable format, as in the DDL to create a table and the DML to insert data.
What I might do here is create...
May 12, 2021 at 3:54 pm
What format are you logs? Any data can be loaded into SQL SErver in a table, but you usually need a process to run the import.
May 12, 2021 at 3:44 pm
This comes from sys.sysprocesses. If you check the docs (https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql?view=sql-server-ver15), this is listed as the last time that the user executed something.
May 12, 2021 at 3:42 pm
Microsoft has published container images for SQL Server 2017 and 2019, but they use their own registry. mcr.microsoft.com
https://github.com/microsoft/containerregistry
If you query from the docker CLI, you can get the tags....
May 12, 2021 at 3:31 pm
You can. If you use Transparent Data Encryption, then everything is encrypted and Excel can just query.
If you want just specific columns, you likely will want a stored procedure to...
May 12, 2021 at 3:25 pm
You can also create a table as:
create table dbo.mytable(myid int)
May 12, 2021 at 3:14 pm
You will have to understand what type of encryption is being used. If PHP is doing the encryption, then you may or may not need to decrypt the data. You...
May 12, 2021 at 3:11 pm
First, there is no first and second records. Records in a database have no ordering. You'll have to better explain what you are looking for here, or what results are...
May 12, 2021 at 3:05 pm
This might help: https://stackoverflow.com/questions/30939180/change-logical-and-physical-file-name-when-deploying-dacpac
I'll post a note and see if anyone has an idea
May 7, 2021 at 5:23 pm
You are adding the log and data files together?
There might be some rounding here, though that seems high. Can you provide exact values you see and how you are getting...
May 6, 2021 at 4:14 pm
No simple answer here. Clustering, AGs, both work, but have limitations, pros, and cons. Best bet is to engage a consultant to talk through some ideas for an hour. I...
May 6, 2021 at 4:05 pm
Redgate's SQL Compare will get the schema back (Disclosure, I work for Redgate Software)
For data, we have data compare, but depending on how much data, this may or may not...
May 6, 2021 at 4:03 pm
What are you looking to do? If you want to visualize this data, PowerBI can help. If you need to join data from 30 spreadsheet tables because they are all...
May 6, 2021 at 3:59 pm
Viewing 15 posts - 2,086 through 2,100 (of 39,860 total)