Hopefully you have an adequate computer at home. If so I would suggest purchasing a DEVELOPER EDITION of SQL Server 2008 and become familiar with it. Practice, for...

Amy.G (1/13/2012)

---

When running isdate the only records with a '0' are NULL columns. I wouldn't think that's what's messing it up. Well, aparently that was the problem, since when I...

+1

Nice question... now as we approach the end of the week will Friday's

QOD be another tough one ?

DeanORenO

you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster should...

Still a suprisingly low correct

Another nice easy question ......... Thanks

Try this:

CREATE TABLE #domCategory(CategoryId INT,CD VARCHAR(40))

INSERT INTO #domCategory

SELECT 1, NULL UNION ALL

SELECT 2, 'something'

CREATE TABLE #Category(CategoryId INT, CD VARCHAR(40))

INSERT INTO #Category

SELECT 1,'Yes' UNION ALL

SELECT 2,'no'

MERGE #domCategory AS target

USING #Category AS...

Easy QODs at the beginning of the week ... now what confusing, complex, obscure QOD will Steve post for Friday ?

L' Eomot Inversé (1/9/2012)

---

Here is a connect item that I've raised as a result of the discussion about one of Paul's QotDs. I hope it will gather some votes...

Too much snow boarding without sun glasses ?

L' Eomot Inversé (1/8/2012)

---

SQL Kiwi (1/7/2012)

---

Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! ...

Ninja's_RGR'us (1/7/2012)

---

Dev (1/7/2012)

---

@Remi: It’s pretty much insulting and I am ignoring you for a long time. I don’t think I have said anything insulting to anyone, especially you...

Here is an example from BOL for SQL Server 2008 ... Note that the first portion of the code shows how to perform what I believe what you want to...

To learn more about CHECKPOINTS I suggest reading Paul Randal's:

http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1530)-checkpoint-only-writes-pages-from-committed-transactions.aspx