# denotes a temporary table, which I created in the DDL and test data script I posted earlier.

Temporary tables are visible...

You can use the SSMS coming with SQLExpress and it is almost fully functional.

Unfortunately the coloured status bar works only for query windows opened with "New Query", but doesn't work...

Very strange...

Have you tried this:

select hostname from master.dbo.sysprocesses where spid = @@spid

Does it return the same?

Try with shrinkfile:

USE TempDB

DBCC SHRINKFILE('tempdev', 0)

If it does not work, the TempDB contains objects that are in use by some connection or were not deleted (temp tables for instance).

For...

It depends on the data stored in the table. Try running this:

SELECT Original_Dollar_Amt , Serial_No FROM Properties where ISNUMERIC(Original_Dollar_Amt) = 0 OR ISNUMERIC(Serial_No) = 0

Does it return rows? If so,...

You could set the param values this way:

SET @sDate = CONVERT(char(8), GETDATE(), 112)

SET @eDate = DATEADD(day, 1,DATEADD(second, -1, CONVERT(char(8), GETDATE(), 112)))

Hope this helps

Gianluca

Same as here:

http://www.sqlservercentral.com/Forums/FindPost753166.aspx

It could be anything, from db related (indexes, triggers, blocking processes) to system related (disk queues, high cpu load, network traffic).

I suggest you narrow the search by adding SET STATISTICS...

You could backup and restore under different name the original database and truncate tables that don't need data inside.

If the instance you're working on is dedicated to this application, you...

This should do the trick:

WITH CTE (TimeStart, KnownAsName, ServiceDetails)

AS (

SELECT ServiceAppointments.TimeStart,

Employees.KnownAsName,

ServiceCubicles.ServiceCubicleName + '|' +

Services.FullDescription + '|' +

Clients.ClientName + '|' +

CONVERT(varchar(50),ServiceAppointments.TimeFinish,108) AS ServiceDetails

FROM ...

What I would have expected you to post was DDL for tables and sample data, something similar to this:

/*

* DDL FOR TABLES

*/

IF OBJECT_ID('Tempdb..#ServiceAppointments') IS NOT NULL DROP...

Interesting reading:

http://en.wikipedia.org/wiki/Number_of_the_Beast

Will...

Thanks Gail,

I knew that BULK_LOGGED had minimal logging, but I didn't know it was THAT minimal.

Nice to know, will be useful in the future.

Deepak Jain (7/14/2009)

---

Hi Gianluca,

Your solution too has a bug. It is not adding the third level of child. When I run it, it gives the following result:

RecordID SumCredit

125

220

The Sum...

If SELECT ... INTO runs in a single transaction, that transaction is logged while running, so it keeps growing the log file until it's over.

When the query is over,...