When creating clustered indexes, you can add page level compression.

spaghettidba (3/10/2015)

---

I don't have a SQL instance to test right now, but here's a quick thought: try to query sys.dm_tran_locks and see which session is holding a lock on that...

I tried it, but got the following error:

Msg 5064, Level 16, State 1, Line 1

Changes to the state or options of database 'Test' cannot be made at this time. The...

Yes you can. But before that, you should do some research: is col1 ever-increasing, how many records will be in one partition, min, max values for each partition, can col1...

Run both views from sys. schemas.

Why he cannot? He can.

1. Create 2 schemas

2. Alter them and transfer all needed tables.

3. Create 2 Fg's.

4. Create files for them.

5. For all tables in these schemas: create clustered...

1. Find out from sys.sysprocesses who is connected to that database.

2. Kill his SPID.

3. Alter database <> set multi_user .

All these assumes that you are member of sysadmin role

select d.name,

sum(r.cpu_time)

from sys.databases d join sys.dm_exec_requests r

on d.database_id = r.database_id

group...

It just shows that it's enabled for replication. Did you get any result from 2nd query?

Check these on publisher's server:

select is_published

from sys.databases

where name = 'your_database_name'

go

select *

from distribution.dbo.MSpublications

where publisher_db = 'your_database_name'

go

select [Table Name ] = name,

[Date created]= create_date

from sys.tables

select [My current SPID]= @@spid

Lowell (2/25/2015)

---

the question really is WHY do you need to know if any are happening, if the developers are allowed to do that. what do you want to do that...

The problem is that we have multiple databases on same server, and sometimes developers need to run join queries between them, so we can't prohibit cross-databases queries.

About catching with...

YES

Transactional replication

The requirements is that we need to...

Do you have actually replication or log shipping? In case of former, you don't need to do any changes. In case of latter, you can access database between applying logs.