Is there a way to tell how much free space there is in a file besides using the EM task pad view?
When I ran "select * from sysprocesses order by waittime desc" RESOURCE_QUEUE is the highest waittype. Most of the documentation I've found on this...
Does anyone know of a good resource for how memory is allocated in the non-AWE space for SQL 32-bit? I'm looking for limits on how much memory can...
I'm bcp'ing data from one SQL 2000 database to another SQL 2000 database. They're basically the same database just one has an older dataset than the...
I have a table called TblA with a column named Col1 of type INT. I'd like to add the IDENTITY property to Col1. Can someone please show me the...
Are table variables like Declare @Table1 Table(cola int) stored in TempDB? BOL isn't very clear...
I'm looking for an explanation on the varying levels of insert performance I'm observing. I've got an 4x700MHz, 4GB RAM, test server with an 8-disk...
I realize it is rather new, but has anyone had a chance to purchase / view a copy of Kalen Delaney's new book titled: "Hands-On SQL Server 2000:...
Does anyone know if it is possible to call a stored proc from a view? If so could you post an example?
I would like to figure out a way to not use the 'NOT EXISTS' portion of the following query as it is causing a Nested Loops join. As the query...
Separate names with a comma.
