Viewing 15 posts - 1 through 15 (of 17 total)
Good Article Ramya!
May 26, 2020 at 4:35 am
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...
January 16, 2019 at 6:25 am
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...
December 4, 2018 at 4:13 am
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...
September 21, 2018 at 2:59 am
Anyone have seen this PREEMPTIVE_OS_CRYPTOPS Wait type before?
October 9, 2017 at 6:00 am
Thanks Ed 🙂
July 13, 2016 at 4:32 am
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].
July 11, 2016 at 3:32 am
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.
September 24, 2015 at 5:44 am
you are on which SQL Server version?
September 22, 2015 at 4:56 am
I did check the bootstrap logs but not much info to proceed.
August 20, 2015 at 5:35 am
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...
December 29, 2014 at 12:42 am
Thanks to every one for your input's.
October 20, 2010 at 5:26 pm
Please let me know,how adding the \ Backslash to the beginning of the path listed in the "Package" box is fixing the issue.
October 20, 2010 at 11:40 am
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...
October 19, 2010 at 4:49 pm
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.
September 23, 2010 at 2:03 am