To determine tables growth rates you need to keep a record of table sizes periodically. I store table sizes on a daily basis to draw growth reports.

My name can be spelt a few different ways and I am used to people getting it wrong. However I get very annoyed when people spell my name incorrectly when...

\\network

DECLARE @age SMALLINT = 11,

@date DATE = '2013-12-07',

@time TIME = '02:00',

@gender CHAR(1) = 'M',

@paid_amt SMALLINT;

SELECT

@paid_amt =

CASE

WHEN DATENAME(DW, @date) = 'Sunday' THEN

CASE

WHEN @Age <= 10 THEN 300

ELSE 700

END

WHEN DATENAME(DW, @date)...

Venkataraman R (10/28/2013)

---

You can disable trigger using "Disable" FROM Context menu of a trigger in SSMS object explorer. But, you cannot script "DISABLE TRIGGER" from SSMS. You will be able...

CREATE TRIGGER CHECK_RANGE ON ASSET_CLASS

FOR INSERT, UPDATE

AS

IF NOT EXISTS(SELECT * FROM inserted i JOIN RANGE r ON i.NO_RANGE = r.NO_RANGE WHERE r.ACCNT_TYP = 'A')

BEGIN

RAISERROR('Invalid NO_RANGE', 16, -1);

ROLLBACK;

END;

GO

Yes you can

BOL will give you the syntax to...

You're welcome. I'm glad to assist.

ElijahE (10/24/2013)

---

Bhuvnesh, that would certainly return the same results and...

Hi,

Your pages are only using 49% of the available space. This is a particular behaviour of heaps that have frequent deletes. I have blogged about this behaviour.

Heaps of Trouble

Try build...

What do these give you?

USE [OSBE_ILEADS];

GO

EXEC sp_spaceused Registration_loaderr;

USE [OSBE_ILEADS];

GO

SELECT index_id, avg_fragmentation_in_percent, page_count, avg_page_space_used_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), OBJECT_ID('Registration_loaderr'), NULL, NULL, 'SAMPLED');

GilaMonster (10/22/2013)

---

And the correct schema.

vineet_dubey1975 (10/22/2013)

---

can i have a mechanism to hold the original data to the view..

IF i refresh view then only data should refresh

Can i define any type or any...

Indexed views do not need...

INSERT INTO sample

SELECT @id, Item FROM dbo.DelimitedSplit8K(@string, ',');