You're right that clustered key should be small. But (maybe I don't understand you well) if you halve size of the clustered key it doesn't mean all nonclustered indexes will...

Hi,

This error message indicates that you have values in tPersonRelation in Person2ID column that do not exist in tPerson. Here's an example:

create table tperson(personid int primary key, personname sysname)

go

create table...

Agreed,

Triggers updating data on linked servers promote transactions to distributed and this opens a whole lotta new possibilities of failure, mainly related to availability of the servers, network stability,...

Hi,

There is usually also "State" information related to the error. Please look if this information is available, perhaps in SQL Server logs. This blog entry explains various reasons of the...

Hi,

Yes, you can store files (up to 2GB in size) in database in columns of type varchar(max) or nvarchar(max). The files will have all formatting preserved. You can use SSIS...

Jeff, I guess you were looking for syntax of the FK constraint for multiple columns?

CREATE TABLE password

(

[First] varchar(50) NOT NULL,

[Last] varchar(50) NOT NULL,

...

Ok, if it a separate server, it doesn't matter. SSIS creates temporary files for storing blobs or temporary data buffers on disk. If you don't change it, it is usually...

Where do ETL loads store temporary files? Is it SSIS? Are they running on the DB server?

Regards

Piotr

It's a long shot only: are you sure that

SUBSTRING(Employee_Master.BasicEarnGL,16,3)

returns all values besides '110'? This the nulls and 'c1' would suggest that the substring is returning something not covered...

I wonder, how this would work?

update pharm.dbo.cms_medorderimport

set import_rec_status = 'A'

from pharm.dbo.cms_medorderimport imp

where

import_rec_status = 'i'

and not exists (select 1 from pat..cmspatviewl

where imp.patientid = patid

and imp.mardbname =...

Please have a look at IN (and NOT IN) predicate of WHERE clause in Books On Line.

Regards

Piotr

Did you try to see what T-SQL is used to create backup? Right click on the plan, select Modify.

When the plan is open, right click on "Back Up Database"...

I don't know if this helps you, but restarting database service will reset tempdb to initial size. What is the size you want to shrink to and what is MAXSIZE...

To hire and to consider hiring are two different things Jeff 😉

Why No? Imagine you have a small company with a website you paid a contractor for, and there is SQL Server under the hood, and everything is working fine.. and...