It would help if you could provide the DDL (CREATE TABLE statements) for the tables, sample data (INSERT INTO <tablename> SELECT <values> UNION ALL ... ), expected results based on...

We have SCOM where I work but I haven't had the opportunity to work with our network admins in seeing how we could use it for monitoring SQL Server. ...

I think that has been suggested.

Understand, but I thought you...

Yes, your welcome!

Before you start looking deep into partitioned tables I have one question for you, are you running SQL Server 2005 Enterprise Edition or SQL Server 2005 Standard Edition? This...

Instead of the above, I'd use the following in MS SQL Server:

select dateadd(dd, datediff(dd, 0, getdate()), 0)

Gus, you beat me and you provided additional info that is quite appropriate. Three thumbs up!

You can easily answer this question yourself. Before running the query in SSMS, set it to also return the Actual Execution Plan and review the plan. You should...

Works on my computer at home.

Edit: Except you need to change the varchar(18) to varchar(19) or varchar(20) as I originally posted. You could also...

Okay, I bit the bullet and I am now on twitter, @LynnPettis. So, who else is out there?

JonJon (11/3/2009)

---

Im loading a datawarehouse with many dimension tables.

WHen I moved to sql 08, I added more indexes but things were working well for a month.

My issue just started. When...

Not with the information provided. lease read Gail's article about asking for help with performance issues (the second article I have referenced below in my signature block).

Here is the code I developed.

declare @time decimal(4,2);

set @time = 14.23;

select right(convert(varchar(20), dateadd(mi, (@time - floor(@time)) * 100, dateadd(hh, floor(@time), 0)), 100), 7)

Being in the US, I am assuming the comma (,) is just like the decimal point (.)...