Replication
Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...
2009-09-03
745 reads
Vinay Thakur
Data Type Synonyms
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
626 reads
reading.
Reading another great book ( I know its old but good book)...Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.
2009-08-30
1,591 reads
Conditional reIndex and update stats.
Hi,This script is very helpful, specially for sql server 2000. I made some changes into this.Thanx to T.Pullen for this...
2009-08-28
1,900 reads
Things to consider...
Hi.... I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....Cool Stuff:
1.SSMS: now...
2009-08-20
555 reads
2009-08-14
2,966 reads
What's new in Sql server 2008
Hi...Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything includes features which other competitors...
2009-08-10
891 reads
2009-08-05
3,619 reads
What's new in Sql Server 2005
Its very difficult to write what all new in Sql server 2005, almost everything is new... the complete engine has...
2009-08-03
714 reads
Transaction isolation level
Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...
2009-05-19
1,141 reads
Blogs
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Marketing Analyst: The Data-Driven Superhero Your Company Needs
Want to blend your love of marketing with the power of data? Becoming a...
Can You See Table Valued Parameters in Extended Events?
I live for questions and this was an interesting one. Can you see Table...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Azure SQL database import permissions
What the required permissions are for "Database import" on an Azure SQL database ...
Migrating MDS model individually using MDS UI
Hi All, Is there a way i can create package for an individual...
Question of the Day
Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers