SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Wednesday, March 9, 2011
Shrink Log File
›
Just a few days back I received an issue regarding disk size is out of space. I have tried to shrink the database using DBCC ShrinkFile but ...
Tuesday, March 8, 2011
SQL Server Database Consistency Check Errors are Reported by DBCC CHECKDB
›
Microsoft SQL Server includes an inbuilt utility, called DBCC CHECKDB, to check the consistency and integrity of MDF (Master Database File)....
1 comment:
Monday, March 7, 2011
Resolving “Internal error. Buffer provided to read..” MS SQL Server Error
›
Microsoft SQL Server enables you to create tables for short term uses. Such tables are known as Temporary Tables that are usable only for a ...
2 comments:
Saturday, March 5, 2011
USING OPENXML TO PROCESS CSV (COMMA-SEPARATED VALUE) STRINGS
›
This may be common knowledge to those among us that are handy with XML (I'm not), but since I just uncovered this nice little trick I th...
Friday, March 4, 2011
Connect to SQL Server from command prompt – list tables and database
›
Q. How do I connect to Microsoft SQL Server from command prompt? I just wanted to see list of tables and database. A. MS- SQL Server is rela...
‹
›
Home
View web version