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,382 reads
Vinay Thakur
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,493 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,104 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,040 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,315 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
628 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
550 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
573 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
607 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
425 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...