Good Article Ramya!

Welcome Ken!

I think by default,table data is separated into Hot Data(that is frequently accessed) & Cold Data(rarely or almost never accessed data).So hot data stay on prem and...

Hi Jeff,

Storage Transactions are the number of requests performed against your storage account.

Storage Transactions consists of Each individual Blob, Table and Queue REST request to the...

Welcome Ken!
I would suggest to run the data collector for 3 to 4 different time frames for at least 2 to 3 hours each time.Also try to identify the...

Anyone have seen this  PREEMPTIVE_OS_CRYPTOPS Wait type before?

Thanks,
Deepak.

Thanks Ed 🙂

Hi,

I have a situation where the above script to identify the duplicate indexes does not capture this duplication:

CREATE UNIQUE CLUSTERED INDEX [IND_table] ON [dbo].

(

[ID] ASC,

[X] ASC,

[Y] ASC,

[Z] ASC

)

ALTER TABLE...

Hi,

DBCC Freeproccache also resolved this 605 error.Any idea on this? I understand that patch apply fix this and also adding column with identity and clustered indexes.

Thanks,

Deepak.

you are on which SQL Server version?

Hi,

I did check the bootstrap logs but not much info to proceed.

Thanks,

Deepak.

Hi,

I also got the same error while configuring the replication from sql server 2012 (Publisher) to sql server 2005 as (subscriber).

But I was able to configure replication by connecting the...

Thanks to every one for your input's.

Thanks,

Deepak

Hi,

Please let me know,how adding the \ Backslash to the beginning of the path listed in the "Package" box is fixing the issue.

Thanks,

Deepak

Hi,

You can check when the statistics was last update by using the below DBCC cmd.

dbcc show_statistics(table name,index name)WITH STAT_HEADER.

After getting the last update statistics date,if you see the statistics on...

The reindex job is failing because the other process(from other job scheduled) may be causing blocking on the tables\databases.so probably you can reschedule the reindex job.

Thanks,

Deepak Sahu