You can generate SUBSTRINGs with something like:

WITH StringOffSets
AS
(
SELECT
COALESCE
(
SUM(CHARACTER_MAXIMUM_LENGTH) OVER(ORDER BY ORDINAL_POSITION ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING)
,0
) + 1 AS StartPos
,CHARACTER_MAXIMUM_LENGTH AS ColLen
,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA =...

• This reply was modified 5 years, 10 months ago by Ken McKelvey.

You could create a job and then have a trigger run sp_start_job.

I would not reload the production table but only INSERT/UPDATE/DELETE the differences.

I don't know much about sqlite but I doubt if joins in updates are allowed.

You could try something simple like:

UPDATE wbridge_history
SET yearclass =
(
SELECT D.payclass
FROM
(
SELECT grower, block, section,...

• This reply was modified 6 years, 1 months ago by Ken McKelvey.

Try defining $password as:

$password = "ge56hSW7U" | ConvertTo-SecureString -AsPlainText -Force

and then just using the variable when creating the object.

Personally I would be inclined not to have the password in the...

The following gives an outline:

Practical Statistics for Data Scientists by Peter Bruce

If the results are important consult with a statistician/mathematician.

https://www.experts-exchange.com/articles/13216/Migrating-your-Access-Queries-to-SQL-Server-Transact-SQL.html

Running Robocopy from the SQL Agent works fine.

You need to create a proxy with rights to both the backup directory and the share:

USE [msdb]

GO

CREATE CREDENTIAL YourBackupUser WITH IDENTITY = 'YourDomain\YourBackupUser'

,SECRET...

https://itsalljustelectrons.blogspot.com/2016/09/Enhanced-TSQL-Error-Handling-With-Extended-Events.html

Indexes should be designed with the whole system in mind, not just a single query.

Most third party applications that I come across have there own import routines. It may be worth doing some research to see if the app you are using has import...

https://www.brentozar.com/archive/category/production-database-administration/dba-training-plan/

I mainly monitor waits and latencies using code developed from the following to provide baselines:

http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/

If you have the money then a professional monitoring tool will provide more information. eg

https://www.red-gate.com/products/dba/sql-monitor/

https://www.sentryone.com/products/sentryone-platform/sql-sentry/sql-server-performance-monitoring

1. I think distributed transactions will only work between two instances of SQL Server.

2. The code should be SELECT CaseType, Status FROM inserted not SELECT CaseType, Status FROM [dbo].[tblCaseType].

3. It...

It looks as though you want to export blobs. I would do this quickly with powershell, something like:

https://andyspecht.github.io/2017-06-23-extracting-images/

Thanks Sue. This sound like a good idea; I will look into it.