Hello experts

Help please

When I am using Drop_existing = on for NonUnique clustered index , I see no change in nonclusted indexes.

But When I do this for unique CLustered index , I...

er.mayankshukla (8/26/2014)Hello Experts,

I have defined a Nvarchar column of 30 bytes

Lets say

create table demo (name nvarchar(30))

But when I see the length of this column by selecting table and pressing Alt+F1

Or...

fn_dblog , I found useful becoz it gave me the log size created with a transaction.

You can fire a command and check the new transaction id created in the log...

Thanks Gail,

Every time when google doesn't works for me, you have an answer 🙂

I got you point and tested it by examining the query plans.

Just a last clarification,

as u stated...

I will try to ask my question with giving table structures

create table sample(id int,name varchar(10))

create unique clustered index cix on sample(id)

with (drop_existing = ON)

Success

create clustered index cix on sample(id)

with...

Well It means that whenever I fire Drop and create index command with drop_existing option.

Sql engine waits to check for create command after drop command.

I am still doubtfull about this.

Also...

Yes, but dmv's like dm_tran_active_transactions Or dm_tran_database_transactions

do not provided me the log length which I require to see which transaction is making my log size to increase.

Thanks Gail,

Your knowledge in SQL is really admirable.

I would not suggest you to use DBCC ShrinkDatabase, but should see the query which is creating this.

In one of my projects I observed such a behaviour when I was...

By key columns I mean key columns of clustered and non clustered indexes.

Data columns can do in place updates.

Answering to atomicity, even in place updates are atomic and rolled back.

My...

Thanks,

I have searched a lot but didn't got a proper response.

If specifying Compression option in Create Table statement means an automatic compression in the table, then what will the threshold...

Hello Experts,

Any comments for my question

Temp tables go to tempdb not any other database

IF OBJECT_ID('tempdb..#temphistory') IS NOT NULL

DROP TABLE #temphistory