Viewing 15 posts - 37,696 through 37,710 (of 49,566 total)
Jeff Moden (7/14/2009)
July 14, 2009 at 6:34 am
Have you looked at the templates in 2005's management studio? Ctrl-Alt-T to open template explorer.
July 14, 2009 at 3:26 am
Paul White (7/14/2009)
edit: stupid angle brackets! I give up - you get the idea
Use the escape codes, not the brackets, unless you're writing actual xml. Markup's not allowed within...
July 14, 2009 at 3:12 am
Dave Ballantyne (7/14/2009)
IIRC it wasnt a turbo button , it was a 'go-slow for compatibility' button.
Yeah, it was. That was part (maybe too subtle) of my joke. It could be...
July 14, 2009 at 3:05 am
The rollback has to complete. If it didn't, you'd be left with an inconsistent (suspect) database. There is no way you can stop that rollback. Even if you restart SQL,...
July 14, 2009 at 2:52 am
Christopher Stobbs (7/14/2009)
would it be worth trying to add a non-clustered index to the temp table to try and get ride of the key lookup?
Could widen the nonclustered to include...
July 14, 2009 at 2:19 am
Dave Ballantyne (7/13/2009)
GilaMonster (7/13/2009)
I was referring to one of the other of his threads, the one that Dave posted.
SELECT <lots> FROM <somewhere> WHERE tatcalltype = 'null' AND <other conditions>
Done, apparently,...
July 14, 2009 at 1:35 am
Paul White (7/13/2009)
GilaMonster (7/13/2009)
tatcalltype ='null'Why.....Oh Lordy. I just found the full line:
update Auditdata set tatcalltype = 'null' where tatcalltype is null:sick:
I was referring to one of the other of...
July 13, 2009 at 3:32 pm
Ignore the stuff on the forums, there's an official article on rebuilding MSDB somewhere on the MS site. Might be on MSDN, might be on support.microsoft.com. A search should find...
July 13, 2009 at 3:32 pm
-c? What does that do? It's -m for single user mode, -f for minimal config (which I believe is what you need for fixing msdb). Where did you get the...
July 13, 2009 at 12:15 pm
Excellent. That's what I was hoping for. How does that perform?
Add these lines before the query and post the details from the messages tab
SET STATISTICS IO ON
SET STATISTICS TIME...
July 13, 2009 at 11:01 am
Dave Ballantyne (7/13/2009)
Select into will be faster if 'select into/bulkcopy' is set in sp_dbOption as it will be a non-logged operation.
From Books Online:
Starting with Microsoft SQL Server 2000, if the...
July 13, 2009 at 10:50 am
Ok, that OR really doesn't like me. Can you change the query as follows?
SELECT t.RowNumber, u.UserID, u.DisplayName, t.RecentPoints, t.AllPoints
FROM #TopScores t
JOIN Users u ON u.[UserID] = t.UserID
WHERE t.RowNumber <= 5...
July 13, 2009 at 10:06 am
Ok, index didn't help much, and it's because of the OR.
Can you try changing that index and adding a second
CREATE CLUSTERED INDEX idx_TopScores_RowNumber ON #TopScores (RowNumber)
CREATE INDEX idx_TopScores_UserID ON #TopScores...
July 13, 2009 at 9:48 am
Mel Harbour (7/13/2009)
July 13, 2009 at 9:45 am
Viewing 15 posts - 37,696 through 37,710 (of 49,566 total)