Extended stored procedures have names prefixed with 'xp_'...

This article from Brian Knight talks a little more about clustering:

http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine__2.asp

If you are installing a 2-node cluster, you would install a default instance of SQL Server on the first...

Try rewriting you query like so:

select stakeholders.stakeholderID, stakeholders.comment, history.time, history.username

from stakeholders INNER JOIN history

on stakeholders.stakeholderID = history.stakeholderID

left outer join (

select distinct history.stakeholderID as stakeholderID, Max(history.time) as [time] from history where...

Each instance of SQL Server has its own tempdb database, which is where temp tables are created.

If you use the single '#' in creating your temp table, then it's...

This is an unusual behaviour to say the least, are you able to confirm that sufficient memory is available for the OS and other applications? Would there be other applications...

Try executing the command DBCC SQLPERF(LOGSPACE) to determine what percentage of the log file is used. If too high, then you can't really shrink it down much further. If the...

You can try the 'WITH INDEX (index_id)' table option. More info can be found in BOL under search item 'FROM' clause (described).

Another option you might light to try is to...

You might want to look up 'BULK INSERT' in Books On Line (BOL) or on the web.

I presume that transactional replication in SS2005 works similarly to SS2000. In that case, when you add an article to a publication (I find it easiest to do this through...

Thanks for the suggestion Mike, but the repository was recently migrated to SQL Server. The thing is, it seems to be working again, but I'm not sure what is causing...

Tempdb growth is mainly due to poor performing queries, so you can use SQL Profiler and probably filter on Duration to determine if there are any stored procedures that are taking more...

You have two options that I can think of:

1. Parse the string (a bit of coding) to extract individual values and store it in a table variable (@tbl), then change...

The issue does not appear to be related to the identity column, but to some other column that is defined as 'NOT NULL'. The reason being that the identity column...

On the server you are monitoring, you can use the DBCC sqlperf(logspace) command to return the size of the log file (in MB) and take action as appropriate:

create table #logspace...

Thanks for your input Kunal.

I am more leaning towards a corruption (of sorts) of the master database myself. Will need some downtime to check the master database, but here is...