SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Wednesday, June 22, 2011
How to Move TempDB
›
Determine the current location of the MDF and LDF files. Run the ALTER DATABASE command to move the files USE master; GO ALTER DATABA...
Tuesday, June 21, 2011
How to take backup of data if the system got corrupted?
›
You may require emergency data backup in following situations The OS is corrupt or system is not booting The OS is running but FusionRet...
37 comments:
Monday, June 20, 2011
Update a column in a Large Table in SQL Server
›
Consider a table called TestTable which has more than 6 millions rows. Suppose you want to update a column with the value 100 if that colu...
Saturday, June 18, 2011
Setup Black Box in SQL Server
›
Check out the below script to trace. This will capture all the SQL Server statements and activities. Be extra cautious as this will take sig...
Friday, June 17, 2011
How to communicate to SQL Server through a Firewall?
›
Firewall systems prevent unauthorized access to computer resources. To access an instance of the Microsoft SQL Server Database Engine throug...
‹
›
Home
View web version