Viewing 15 posts - 1,921 through 1,935 (of 8,416 total)
That's covered in the link I mentioned earlier. There's a special note:
Some of the SQL Server utilities set one or more of the ANSI settings to OFF to maintain...
June 30, 2011 at 8:25 am
dean.g (6/30/2011)
How often would you say you have to use index and locking hints to force SQL server to do what you want?
Index hints: very rarely. There is usually...
June 30, 2011 at 7:54 am
DECLARE @Data TABLE
(
ProductCHAR(3) NOT NULL,
ColourVARCHAR(10) NOT NULL
);
INSERT @Data
(Product, Colour)
VALUES
('AAA', 'RED'),
('AAA', 'GREEN'),
('AAA', 'YELLOW'),
('AAA', 'BLUE'),
('BBB', 'GREEN'),
('CCC', 'RED'),
('CCC', 'GREEN'),
('CCC', 'BLUE'),
('DDD', 'BLACK'),
('DDD', 'RED'),
('DDD', 'YELLOW');
SELECT
d.Product
FROM @data AS d
GROUP BY
d.Product
HAVING
SUM
(
CASE
WHEN d.Colour = 'RED' THEN 1
WHEN d.Colour...
June 30, 2011 at 7:47 am
CREATE SCHEMA Fact
CREATE TABLE OrderDetails
(
CustomerWIDINTEGER NOT NULL,
DistributedDateDATETIME NOT NULL,
OrderNumberDECIMAL(5,2) NOT NULL
);
GO
INSERT Fact.OrderDetails
(CustomerWID, DistributedDate, OrderNumber)
VALUES
(2034, '2011-05-16 23:50:14.080' , 1.00),
(2034, '2011-05-16 23:50:32.407' , 0.00),
(2034, '2011-05-16 23:54:10.883' , 1.00),
(2034, '2011-05-17 00:14:12.333' , 1.00),
(2034,...
June 30, 2011 at 7:21 am
Gianluca Sartori (6/30/2011)
Personally, I don't like the StackOverflow model. There's no way to discuss things and every post has the only purpose of avoiding downvotes.
Oh I don't know, I've had...
June 30, 2011 at 6:36 am
j.miner (6/30/2011)
I do not understand the advantage of a insert/delete with a exclusive lock over two statements in a transaction.
Hi John,
The TABLOCKX isn't required - I just added it out...
June 30, 2011 at 6:18 am
Grant Fritchey (6/30/2011)
I wouldn't want to take away from our conversations that we have, but some method of designating a good answer would be helpful.
Absolutely - the conversations are all...
June 30, 2011 at 5:39 am
Trey Staker (6/29/2011)
I wish there were ratings on posts, maybe a thumbs up or down on answers like on Ask SCC.
Interesting idea. One effect might be that the frustration...
June 30, 2011 at 5:08 am
No worries. If you feel like posting a plan at some stage, feel free - I always enjoy looking at those.
By the way, 4GB RAM is really pretty tight...
June 30, 2011 at 5:01 am
It seems temporary tables always have an OwnerId of 1.
That's inconvenient; looks like you are out of luck.
🙁
June 30, 2011 at 4:21 am
ARITHABORT should be set ON in all modern development work. Many new features require that setting, for example XML methods, indexed views (as you mentioned), and indexed computed columns....
June 30, 2011 at 4:15 am
manning20 (6/29/2011)
June 30, 2011 at 3:54 am
manning20 (6/29/2011)
June 30, 2011 at 3:48 am
Viewing 15 posts - 1,921 through 1,935 (of 8,416 total)