Change the database name, and insert your SQL statement(s), Function(s), or SPROC(s) in the middle.
Peter Samson,
2010-02-23 (first published: 2010-02-04)
Change the database name, and insert your SQL statement(s), Function(s), or SPROC(s) in the middle.
use <mydatabase> go dbcc freeproccache go checkpoint go set statistics profile on go set statistics io on go set statistics time on go select 'starting time: ' select getdate() go <insert your SQL here> go select 'ending time: ' select getdate() go set statistics profile off go set statistics io off go set statistics time off go
Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.
2003-02-21
9,971 reads
A look at files and filegroups in SQL Server 7.0, including some optimization tips.
2001-09-27
8,229 reads
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
2001-06-26
2,745 reads
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads