GilaMonster (7/15/2011)

---

You can run it if you want, though running it with NORECOMPUTE means that you do not EVER want that statistic to be automatically updated. If you've been updating...

GilaMonster (7/15/2011)

---

Possibly they haven't been needed since. Stats are updated the first time that they are used after the 20% threshold is reached. If no query has tried to use...

Hi,

As per you suggest this URL, I am not getting clearly,

so can you explain default schema(dbo) not able to give grant permission to particular user for create table, view,...

yes, I have full permission to use this server.

I login with sa user.. after that create one database name is test,

then create login, user etc.. and give command

grant...

Yes, I have correct schema (dbo) and user name.

1. Login - test1 with pw ( default db is test)

2. query editor - USE database name

3. create table - but till...

In SQL server 2008 Version, there is one of the auditing configuration at server level and database level, Through database level auditing you able to monitoring like how many data...

Ok, I understood .

Thanks you very mouch for Help.

Hi SQLkiwi,

Wonderful and Greate reply...

what i have done?

1. ALTER DATABASE TELEDATA SET AUTO_CREATE_STATISTICS ON;

2. CREATE NONCLUSTERED INDEX [IX dbo.TEL_TXT_LI_ST site (a)]

ON dbo.TEL_TXT_LI_ST (SITE)

INCLUDE (A);

GO

After that data feteching time 00:00:00, the...

hi SQLkiwi,

I have faced problem for fetching data long time around 56 seconds and application(asp web) getting time out expired error.

1.this is main table

select * from Tel_bincard_detail

(15366 row(s) affected)...

Yes, thank you for reply...

I got it delete this index as below statement

drop index [NonClust_anamoly, sysname,>] on dbo. tel_bincard_detail

Thanks

ananda

Hi,

This is very nice script for quickly get and clear output consistancy checking database for all database.

Can anyone help me, I want to know how ouput file attached or...

sorry Mr.

schema name - DBO, and attached file for execution plan file, please find out.

I have changed set ompatible level 100 after upgraded

thanks

execution plan for query

SQL Server Execution Times:

CPU time = 43313 ms, elapsed time = 45799 ms.

yes, after migration i have done as below

1. dbcc checkdb with data purity

2. Rebuild index

3. update statistics both all existing statistices and column level

thanks

Syed Jahanzaib Bin hassan (5/2/2011)

---

Database backup size depend on the total files size,he has mentioned each file have 5GB restricted size,how many files are there,do you people know this, if...