Tag: sql server

Community

WinSQL

WinSQL is a utility that uses ODBC to connect to different databases. You can connect to multiple data source at the same time. It also displays the database catalog information including table name, field name, stored procedures and their parameters. Moreover, it uses a multi-threaded architecture

Community

Do the Splits

By Kalen Delaney – In "More Fill-Factor Mysteries," May 2001, I demonstrated that SQL Server performs a page split when it needs to insert a row on a full page. To determine whether a split occurred, I examined the output from the DBCC IND command, which shows how many pages are in a table.