Development – Page 2

ADO.NET

19 February 2008 iby 0

For test purpose I did a little test in C#, where I did use ADO.NET to make a connection to my SQL Server. The common way to access a database is to do the following: […]

DBREINDEX and INDEXDEFRAG example

4 April 2006 iby 0

If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.

If you are a SQL Server administrator or just working with it, these commands would be use full for you. ALTER INDEX Modifies an existing table or view index (relational or XML) by disabling, rebuilding, […]