Viewing 15 posts - 1 through 15 (of 97 total)
Thank you so much, this looks to be exactly what I need. Going to test some more.
March 14, 2022 at 3:22 pm
Scott, I hope you dont mind me bringing up an older topic, but I have question about this or rather I am trying to add to this logic and am...
March 14, 2022 at 2:47 pm
Thanks for the reply, Scott. That unfortunately is not working. It moves the "incorrect syntax" line from the plus sign to the to the first @SQL. Below is what I...
September 29, 2021 at 7:16 pm
Looking at https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-ver15
It states that the used_page_count accounts or in row, LOB and overflow. And, looking at sp_spaceused, from what I can tell and from my simple example...
December 29, 2020 at 5:49 pm
All great answers and all of them very helpful!
I will be using the used_page_count for my calculations.
Again, I appreciate everyone's help!
December 29, 2020 at 4:44 pm
Thank you both for the clarification!!
November 30, 2017 at 10:31 am
This has been great Luis!! I have some more research to do on my end, I really appreciate the insight!!
October 11, 2017 at 11:58 am
All three of the queries I provided Perform an Index Seek on the non clustered index and a key lookup, so they do use the Index and...
October 11, 2017 at 11:08 am
The LSBackup job places the file on a network share and the LSCopy job copies that tlog backup from the network share locally to the secondary server where the LSRestore...
December 14, 2016 at 11:07 am
@jason, thanks for the reply, but that is information that I am already aware of and tried to state that in my original post.
@perry, I agree...
December 14, 2016 at 8:12 am
Thank You GilaMonster for the replies. I did get this figured out. There was in fact remnants of replication still on the database that was set up in...
July 30, 2016 at 3:15 pm
GilaMonster, will that affect AG in anyway?
July 30, 2016 at 12:58 pm
Thanks for the reply, but looking at another customer that we have set up for replication, I see sysarticles (not sys.articles) system view and it is in the distribution database....
July 30, 2016 at 10:32 am
Let me add that this database used to be replicated. About 6 months ago we changed it to use Availability Groups.
Drilling into the Replication portion of Object...
July 30, 2016 at 9:46 am
Thank you both very much, both of these will work for me!!
March 5, 2016 at 2:32 pm