Tag: sql-server-2008
- Delete duplicate from 140 GB SQL server table where 30% records are duplicate without causing overheads like transaction logs full?
- Need best practices to maintain TempDB which is growing to 100GB now, is moving Tempdb to 35GB drive have any limitations?
- Finding groups which have two values in another column
- Changing SET options within cursor – Different behavior based on compatibility level
- Replicate one database in one server to 2 other servers SQL2008
- Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1
- Anything but small ODBC queries failing over long distance VPN after SQL Server Swap
- Why SERIALIZABLE level does not lock the table for other session in SQL Server
- Cannot Insert it into in the table for Special characters when ANSI_WARNINGS is Off even with nvarchar
- Always on high availability groups option is grayed out