Then please do a statistics update, preferably with full scan. I wasn't asking to remove fragmentation, an index rebuild updates stats and, from what I can see, stats are way...

jcrawf02 (6/23/2009)

---

I think it's important to know these concepts so that you don't have to worry about how rigorous your cases are, because if you don't test for that situation,...

And in Firefox gives those errors...

Since you're formatting you'll have to reinstall SQL, so no changes will be necessary.

Converting to varchar's one of the the slowest ways to trim the time from a date. Also watch out for the edge cases. Between's inclusive on both sides. If a...

CheckDB will never repair damage to any of the system tables.

Can you please run the following and post the entire output?

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

Take...

What error do you get if you remove yl_rangename from the select? (leave it in the group by)

One other thing. You should be able to remove the RTRIM from the...

Don't understand your question. A datetime has no defined format, it's a date, format is a string property. The format that you see in queries is defined by your regional...

Post the query?

In the reply screen, take a look to the left of the text area. You'll see several IFCode shortcuts. Highlight your code and click the code shortcut, or you can...

One way is to use Service broker. Set the procedure that you want to run async as the activation procedure for a service broker queue and send a message when...

SELECT TOP (100) ROW_NUMBER() OVER (ORDER BY Object_id)

FROM master.sys.columns

DECLARE @TheDate DATETIME

SET @TheDate = '2008-01-01 12:12:12:223'

SELECT dateadd(dd, datediff(dd,0, @TheDate),0)

See http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/

You could restore a backup of the master database that was taken before the tables were added. You do have a backup of master?

If you rebuild master you will lose...

Look at the joins. There's only one column from each table referenced in the joins. Hence to start with, create an index on each column that's referenced in the join...