The secodnary database of a log shiping is continously on recovery mode. You cannot access it. So you need to set the db to Standby mode.

However, you can create db...

You can do this, but it may cause problem when you manage the text using string functions. By utf-8, some characters need one byte, some need 2 or more bytes to...

I think you need to talk with BI users/developers about the BI task (loading data etc) schedule. If there is time period that the db is not heavily used, schedule the...

Try to set the transaction isolation level to SERIALIZABLE in the beginning of your script:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

let's say if 50% of the records have null value for all the nullable columns, you do not need to insert those records into the second table. The second table only contains records...

Table schema reflects real world entities or relations. Without knowing the "real thing" the table represents in the real world, it's even hard to say the spliting is a nomalising...

You can try to load the data of the select without subquery into a temp table:

INSERT #TempTbl(sales_office_id, invoice_id)

Select sales_office_id, invoice_id from data_warehouse

where (date range, order type, misc criteria)

Then, remove existing...

Yes. You need to run the setup to create new instances

select

database_id,name as database_name,recovery_model, recovery_model_desc FROM sys.databases

The partitions you created are (t<1900-01-01 1:00:00), (1900-01-01 1:00:00=<t<1900-01-01 2:00:00), ...

So in fact if you insert data at 1:00am, the data will go to the 2nd partition.

To retrieve all data...

SELECT constid,

id,

colid,

status

error

FROM Sysconstraints

is the same as:

SELECT constid,

id,

colid,

status AS error

FROM Sysconstraints

here error is treated as the alias of column of status.

 The syntax should be:

ALTER TABLE dbo.employee SWITCH PARTITION $partition.HourRangePF1(

In sql agent, open job property-->steps tab-->the step 1-->advanced, try to change "on failure action" to "go to next step"

One basic requirement for partition switching is both the source partition and the target table and their blob columns (text, image etc) must in the same file group.

You need to...

You need to change both triggers as follows (in red).

1. *** Trigger after inserted to add account balance

 set ANSI_NULLS ON

 set QUOTED_IDENTIFIER ON

 go

 ALTER TRIGGER [AddAccountBalance] ON [dbo].[journalChild] AFTER INSERT AS

 BEGIN

  UPDATE...