Are you actually saying you have visited this site 844 times and

you don't know how to JOIN two tables and concatenate a couple of fields?

Can't you just join on the tables like this?

Insert into dbo.Inventory (ID, ServerName, Database_Name, Recovery_Model, Creation_Date, Owner, IS_Mirrored,VLFcount)

SELECT DISTINCT @serverID, @servername, D.name, D.recovery_model_desc, D.create_date, suser_sname(D.owner_sid), CASE When M.mirroring_state IS NUll...

In SQL SERVER 2012 and above.

you can use a sequence like this

CREATE SEQUENCE [dbo].[SEQ1]

AS [bigint]

START WITH 1

INCREMENT BY 1

MINVALUE 1

MAXVALUE 9223372036854775807

CACHE

GO

ALTER TABLE...

When setting up client tools for the occasional imperious .net developer I have changed GO

to RESOLVE. it confuses the hell out of them 😀

You can change the BATCH separator in SSMS by going into options/query Execution/SQL server

Change the Batch separator from GO to ;.

CREATE UNIQUE NONCLUSTERED INDEX [IX_Denominator] ON [dbo].[Denominator]

(

MemberID ASC,

MeasureID ASC,

TimePeriodID ASC

)WITH (IGNORE_DUP_KEY = ON) ON [PRIMARY]

We populate Table Valued Parameters from within MVC.

I'm not a C# developer so can't help you with specifics,

but our c# developers populate from the app which is MVC based.

Hi here's an example of loading a pdf into a varbinary

create table pdf

(

ID INT IDENTITY(1,1),

pdfFile varbinary(max),

CONSTRAINT PK_ID PRIMARY KEY CLUSTERED

(

ID ASC

)

)

INSERT INTO pdf(pdfFile)

SELECT * FROM OPENROWSET(BULK 'D:\Simon.pdf', SINGLE_BLOB)

Regards

Hi I'm currently in the process of modifying our Data Warehouse from a full load process to an incremental load.

I use a the lookup transform with a cache file and...

All Database metadata

is stored in the INFORMATION_SCHEMA views.

Example below.

USE [Database Name]

GO

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

How would you go about migrating data on an hourly Basis into a SQL azure Data Warehouse.

The Data Factory, looks like somewhere to start, looks interesting an were going to...

Hmm maybe I need to read up some more before completely dismissing this platform.

Its the change capture that's concerning me. I have used Change Tracking but it requires a lot...

One of the main disadvantages is no SQL agent.

Ill have a look at Batch deleting.

Thanks.

Simon

Igor,

I've not used delete on cascade.

Looking into it this might work.

I was under the impression this only worked if you had joins in your delete statement.

Would I add this to...