Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,325 reads
Vinay Thakur
Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,479 reads
Logins no longer exists.
Today while checking the logins, just want to clear/clean logins which are no longer exists on NT domain.
To get...
2009-10-22
553 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
578 reads
Network backup Access via Query Analyzer
Hi,
Today while working on query analyzer found very interesting thing about security.
My sql server A is running with service account...
2009-10-14
611 reads
Blogging
Hi,
Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling...
2009-10-13
431 reads
Reindex and Update stats.
Today I was reading blog by Ben Nevarez it is great... (I am impressed with ben now a days) that's...
2009-10-09
755 reads
Select count(*)
Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...
2009-10-09
1,949 reads
Impact of uninstall instance on replication.
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,658 reads
Transaction Replication Backup/Restore or DR
Hi,Want to discuss on DR plan or Backup restore plan for transactional replication (here I will discuss on PUSH T...
2009-09-14
1,696 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers