The "PF Usage" chart in Task Manager shows: 8.58 GB. The "Total paging file size for all drives" in performance options is: 3672 MB. How should I...
Is it possible to change some option in forums configuration so I don't receive an e-mail notification when I respond to some topic? I know that I...
<p>Is there some problem with images on the buttons?</p><p>I've got an impression that they are visible only on the buttons that I clicked...
What do you think about dual-core CPUs? Is it a good idea to use them in a SQL Server 2005 machine? Have you ever worked with such a machine? From...
[I know it's a SQL Server website, but there are many Oracle guys here, so I am postig this question here.] Is there any Oracle server available on...
A small stored procedure that tells whether a job is running or not.<br /><br /><font face="Courier New">CREATE <img...
Running SELECT job_id FROM msdb..sysjobs gives the following results - 20 job identifiers: /* 8616C780-14CF-419A-BDD0-25343D4925E6...
What is the best way to check if a system stored procedure - for example, sp_help_job (with some arguments that I don't put here, because I don't...
Hmmm, now the feed has the title, but couldn't it be a little bit more specific than 'SQL-Server-Performance.Com'?<br /><br />SSP has more than one...
Why is the title tag empty? <rss version="2.0"> <channel> <language>en-us</language> <lastBuildDate>06/25/2005 07:08:06</lastBuildDate>...
Why is there no 'Non-Performance or Non-Clustering Tips' forum? -- "Recommended By Dr. Audioscrobbler."...
I created a simple DTS package, I executed and it worked just fine. Then I scheduled it and tried to execute the job. The job failed. It consisted...
I found a following error in SQL Server Error Log: Starting up database 'foo'. Bypassing recovery for database 'foo' because it is marked IN LOAD....
There are two pieces of code. The first one works fine. declare @foo varchar(20) set @foo = 'id' select top 10 id, name from sysobjects order by...
There is a table with two columns - one of them is identity and the other contains some numeric values: id | value ---|------- 1 | 10 2 | 15 3 |...
I've just passed 70-228 Microsoft examination! [8D] PS. It wasn't as hard as I expected. -- Rediscover the web http://www.mozilla.org/firefox/
I am reading 'Inside SQL Server' by Kalen Delaney (which is an excellent book, by the way) and I found something that puzzled me. On page 117 and...
According to this Features by Edition comparison Distributed Partitioned Views are supported only in SQL Server 2000 Enterprise Edition. However,...
Sorry, if this is a totally lame question, but what are parameterized stored procedures? Is it some special kind of stored procedures? Or are they...
Column number1 is ID of an item. Column number2 is ID of the item's substitute. Column price is price of the item's substitute. number1 | numer2 |...
Separate names with a comma.
