Compare Microsoft Sql Server with other DBMS/RDBMS
Today I was just thinking about to know what is the difference between sql server vs.. other DBMS/RDBMS. so thought...
2009-11-04
1,973 reads
Vinay Thakur
Comparison Microsoft Sql Server with other DBMS/RDBMS
Today I was just thinking about to know what is the difference between sql server vs.. other DBMS/RDBMS. so thought...
2009-11-04
1,393 reads
Consider this while doing any UPDATE
Trigger:
When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now...
2009-10-30
1,494 reads
Replication Setup:
I saw too many questions on forum asking step by step process of configuring replication I have these links in...
2009-10-28
1,125 reads
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,406 reads
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,322 reads
Tricks and issues Part 1
Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see...
2009-10-23
633 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
552 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
576 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
608 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
T-SQL in SQL Server 2025: Concatenating Strings
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Being Mindful of Design Time
Comments posted to this topic are about the item Being Mindful of Design Time
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers