The bcp command line tool allows you to import and export data from a SQL Server database into a text file. There is also a freebcp tool from the FreeTDS library so you can do this from Linux/Unix … [Read more...] about Export data from SQL Server to a tab file with bcp
Microsoft SQL Server
Help And Howtos For Microsoft Sql Server
Microsoft SQL Server is Microsoft's relational database management system (RDBMS). Microsoft originally worked with Sybase on earlier versions but later parted company and Sybase renamed their version more recently to Sybase Adaptive Server Enterprise. The current version of SQL Server is SQL Server 2008 R2.
This post looks at how to check if an index is fragmented in a Microsoft SQL Server table and how to rebuild the index. The advice offered in this post works for both SQL Server 2000 and SQL Server … [Read more...] about Check Index Fragmentation with SQL Server 2000/2005
While modifying a table in Microsoft SQL Server with about 10 million records in it, I got the error message "unable to modify table - timeout expired..." and the table was not able to be modified. … [Read more...] about Unable to modify table, timeout expired errors with Microsoft SQL Server
This is the third and final post in a series about using the sp_tables, sp_columns and sp_stored_procedures stored procedures with Microsoft SQL Server databases. This post is about … [Read more...] about List stored procedures with MS SQL Server