Viewing 15 posts - 7,756 through 7,770 (of 8,416 total)
tony.sawyer (6/17/2009)
Paul White (6/17/2009)
It might pay those bemoaning the quality of the question to submit a better one...?
Ooh theres a challenge... Where do we send them? 🙂
Hey Tony,
http://www.sqlservercentral.com/Contributions/New/Question
There is a...
June 17, 2009 at 6:56 am
Ooo! Just found a better way to break INDEX(0):
SET FORCEPLAN ON
INSERT dbo.[976231EF-DA13-4A8A-91DC-7D8931A2C14B] (cost)
SELECT TOP (10)
FLOOR(RAND(CHECKSUM(NEWID())) * 1000)
FROM master.sys.all_columns C1
CROSS
JOIN master.sys.all_columns C2
GO
That produces the...
June 17, 2009 at 6:44 am
There is a risk of taking this too seriously you know...
Most of the recent QODs seem to have been posted by the author of this, and from memory, they were...
June 17, 2009 at 6:39 am
Lynn,
Well yes, quite. The previous discussion on this emphasized that INDEX(0) was not required.
Indeed, it is still not sufficient, try:
INNER LOOP JOIN dbo.[976231EF-DA13-4A8A-91DC-7D8931A2C14B] AS Test WITH (INDEX(0),TABLOCKX)
The rows seem...
June 17, 2009 at 6:35 am
hakan.winther (6/17/2009)
Please leave it, my mailbox is flooded with notifications from this matter and now i will unsubsribe to this forum.
I wonder if you were quick enough to avoid the...
June 17, 2009 at 6:25 am
Hugo Kornelis (6/17/2009)
June 17, 2009 at 6:17 am
Tom.Thomson (6/17/2009)
I think that sort of assumption is careless and sloppy
...and I think that sort of statement is arrogant and presumptious 😉
Tom.Thomson (6/17/2009)
June 17, 2009 at 6:13 am
GilaMonster (6/16/2009)
I just got word from the documentation people. The lack of the UPDATE <alias> was simply an oversight and it will be corrected in a future version of BoL.
While...
June 17, 2009 at 6:01 am
GilaMonster (6/17/2009)
In all cases that have been observed.
Maybe not 😉
USE tempdb;
GO
CREATE TABLE dbo.[976231EF-DA13-4A8A-91DC-7D8931A2C14B]
(
row_idINTIDENTITY(1,1)PRIMARY KEY CLUSTERED,
costINTNOT NULL,
running_totalINTNOT NULL DEFAULT 0
);
GO
CREATE TRIGGER [trg_976231EF-DA13-4A8A-91DC-7D8931A2C14B_IOI]
ON dbo.[976231EF-DA13-4A8A-91DC-7D8931A2C14B]
AFTER INSERT
AS
BEGIN
IF@@ROWCOUNT = 0 RETURN;
SETROWCOUNT 0;
SETNOCOUNT ON;
DECLARE@total INT;
SET@total =...
June 17, 2009 at 5:38 am
Good stuff Glenn.
Setting asynchronous statistics doesn't prevent a move to single user mode - but the change may be blocked until any in-progress background stats update completes. There are...
June 16, 2009 at 10:20 pm
Have you considered enabling asynchronous statistics updates in the database?
ALTER DATABASE [db name] SET AUTO_UPDATE_STATISTICS_ASYNC ON;
Paul
June 16, 2009 at 7:27 pm
Carl Federl (6/16/2009)
June 16, 2009 at 2:58 pm
RBarryYoung (6/15/2009)
Finally, you may need to string name it (see here: http://msdn.microsoft.com/en-us/library/xwb8f617(VS.80).aspx)
Heh. There was I about to post that the assembly needs to be signed, when I thought I'd...
June 16, 2009 at 4:33 am
Hey, interesting issue.
Try tracing the Showplan XML Statistics Profile and Showplan Text (Unencoded) events.
(You can save the XML plans to a separate file by specifying that on the Events Extraction...
June 16, 2009 at 4:22 am
@Aaron: that's great news!
@Barry: no worries - I was just pointing it out in case you or anyone was particularly interested 😎
Paul
June 16, 2009 at 3:52 am
Viewing 15 posts - 7,756 through 7,770 (of 8,416 total)