Viewing 15 posts - 38,266 through 38,280 (of 49,571 total)
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...
June 23, 2009 at 6:54 am
jcrawf02 (6/23/2009)
June 23, 2009 at 6:32 am
Tom Brown (6/23/2009)
SELECT
'blank line above',
'and below'
above gives me some IE errors in preview - but preserves the blank lines
(syntax highlighter can't find brush for 'noncode')
And in Firefox gives those errors...
June 23, 2009 at 6:23 am
Since you're formatting you'll have to reinstall SQL, so no changes will be necessary.
June 23, 2009 at 6:05 am
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...
June 23, 2009 at 5:25 am
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...
June 23, 2009 at 5:18 am
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...
June 23, 2009 at 2:58 am
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...
June 23, 2009 at 2:58 am
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...
June 23, 2009 at 2:06 am
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...
June 23, 2009 at 1:37 am
SELECT TOP (100) ROW_NUMBER() OVER (ORDER BY Object_id)
FROM master.sys.columns
June 23, 2009 at 1:33 am
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/
June 23, 2009 at 1:24 am
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...
June 23, 2009 at 1:22 am
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...
June 23, 2009 at 1:08 am
Viewing 15 posts - 38,266 through 38,280 (of 49,571 total)