Jeff Moden (11/17/2012)

---

You might be able to fix this. I haven't tested it but it might work.

Make the clustered index on the IDENTITY and the GUID column and then...

DjVu

seankyleprice (11/16/2012)

---

I personally think the answer should be 'none of the above'. The accuracy of sysdatetime() depends on the computer hardware and version of Windows on which the instance of...

seankyleprice (11/16/2012)

---

Best Practice for 2008 onwards is surely to use TRY CATCH as suggested by Stewart. For 2005 and prior I agree that the method suggested by Carlos would be...

Carlo Romagnano (11/16/2012)

---

Best practise: save @@error and @@rowcount to test them later

declare @err int

,@rows int

select 1

SELECT @err = @@error, @rows = @@rowcount

if @err <> 0 or @rows = 0

...

Good basics question, nice and easy.

Interesting discussion on the deprecation of 'DEFAULT' used as a default value; I can't imagine a more lunatic restriction myself, and I see Hugo's amusing...

By "my country" did he mean Scotland, the United States, or Russia?

WotD: Trinationality

venoym (11/14/2012)

---

Wait... after Implementation? I thought it was the Step just after "Deployment" and just...

This is an easy question for those not fooled by the title who either remember that in SQL the power operator (POWER) is written as a function (not as an...

Good question.

I got it wrong through sheer carelessness - read too quickly, and failed to remember when I got to the end that the very first insert is before the...

mbova407 (11/12/2012)

---

Thanks for the question

Will someone please explain example C in english

CREATE TABLE T (a int, b int, c int);

GO

INSERT INTO T VALUES (1, 1, -3), (2, 2, 4),...

Nice question, and easy.

But I suspect a sales manager who noticed that goals were being set like that would not be happy - fancy giving the salesman who made the...

Craig, it's clear that we each have our own viewpoint on what a spool operation is and whether all operations carried out by SQL server show up in query plans,...

sknox (11/10/2012)

---

If you think of it that way, you'll see why a NULL in a column or variable can (must) have a type associated with it, while a NULL constant...

Rod d'Armand