Viewing 15 posts - 2,431 through 2,445 (of 39,771 total)
Noooooooooooooooooooooooooooooooooooooooooooo
August 28, 2020 at 2:46 pm
I don't have one here, though I should write a quick one.
Here's one I've used before: https://towardsdatascience.com/sql-server-with-python-679b8dba69fa
August 27, 2020 at 3:37 pm
Altered the question to note a database file on the c: drive.
August 27, 2020 at 4:20 am
you can re-run setup, and check the "add features" checkbox to see what's installed.
For settings, you can get sp_configure and some other settings, but this might help: https://www.red-gate.com/simple-talk/sql/sql-training/how-to-document-and-configure-sql-server-instance-settings/
Can I...
August 25, 2020 at 5:50 pm
Simplest, make a DBA database, on startup, have a proc that writes the time to a table. use a job that writes to a second column of the latest entry...
August 25, 2020 at 5:20 pm
Whoever signs the checks usually wins.
August 24, 2020 at 4:50 pm
A scheduling mishap. This thread shouldn't be visible either.
August 22, 2020 at 4:51 pm
Feel good shot of the day, born last night

August 21, 2020 at 2:24 pm
I probably shouldn't have included control in there. The master instance is a place where the query management and connectivity take place. I'll reword the naming in the answer choices.
August 21, 2020 at 2:22 pm
Replication to other platforms is not supported after SQL 2016
there are third part products to do this, but they cost money.
You can use a linked server and a trigger,...
August 20, 2020 at 7:05 pm
Is this needed in real time? As in a replication type scenario?
August 20, 2020 at 4:44 pm
So many companies don't bother.
And they fight the same fires over and over.
August 20, 2020 at 4:43 pm
Or a CASE. I think this is what you want
CREATE TABLE A
( fullname VARCHAR(100) NOT NULL CONSTRAINT aPk PRIMARY KEY
, firstname VARCHAR(50)
...
August 20, 2020 at 4:43 pm
Viewing 15 posts - 2,431 through 2,445 (of 39,771 total)