Welcome to TechNet Blogs Sign in | Join | Help

March 2007 - Posts

Wednesday, March 14, 2007 4:35 PM

Physical Database Storage Design and Disk Allocation

The system page file should not be on the same physical spindle as any database files, otherwise you will not get optimum performance from the drive as its disk head will be jumping between the page file and the database files. Ditto for placement of
Posted by vishah | 0 Comments
Filed under:
Monday, March 12, 2007 10:34 AM

How to identify which DTS Package is being called by scheduled job

I have seen where DBAs would right click the DTS Package (SQL 2000) and schedule a job. If you schedule a package to run that way, the SQL Job it creates will have an encrypted name for DTS package in SQL job step - similar to what you see below: DTSRun
Posted by vishah | 1 Comments
Filed under:
Tuesday, March 06, 2007 9:39 AM

How to check the status of SQL Server Services remotely?

There is windows “SC” utility and the following “Heart Beat” approach. http://www.databasejournal.com/features/mssql/print.php/3347241 You can use SC query and look for string RUNNING SC \\machineName query MSSQLSERVER ! findstr “RUNNING”
Posted by vishah | 0 Comments
Filed under:
Tuesday, March 06, 2007 9:36 AM

How to parse the view definition and get the base tables and base columns information

You can use INFORMATION_SCHEMA.VIEW_TABLE_USAGE and INFORMATION_SCHEMA.VIEW_COLUMN_USAGE from SQL70 onwards. And you can use sys.sql_dependencies in SQL Server 2005.
Posted by vishah | 0 Comments
Filed under:
Thursday, March 01, 2007 11:21 AM

Indexing a SQL Table

I found one of my old documents where I kind of summarized Indexes on a SQL Table, might help. Indexing SQL Table Primary Key: · Creates clustered index on the column · Doesn't allow NULLS Unique Key: · Creates non-clustered index on the column · Allows
Posted by vishah | 1 Comments
Filed under:
 
Page view tracker