dwain.c (11/17/2013)

---

Jeff Moden (11/17/2013)

---

WayneS (11/17/2013)

---

Speaking of Tally / Numbers tables - does anyone have a tally-table based query that you wish would run even faster? I'm going to be doing...

If you want to see the value of a variable at a certain point during execution and can't get debug to work, the PRINT (http://technet.microsoft.com/en-us/library/ms176047%28v=sql.100%29.aspx) and SELECT (http://technet.microsoft.com/en-us/library/ms189499%28v=sql.100%29.aspx) statements work...

John Travolta

Koen Verbeeck (11/15/2013)

---

Found the issue. Found a log file in \AppData\Local\Temp, called SqlSetup.log

Most important line was:

A quick google search told me to reset...

Abu Dina (11/15/2013)

---

Use Jeff Moden's string splitter function. See link below (the function can be found in a zip file at the end of the article)

Tally OH! An Improved SQL...

Windows updates are applied by either the Windows Update service and for SQL Server 2005 and beyond, SQL Server SPs and patches are handled by Windows Update.

If I'm not mistaken,...

Good question. It made me think, so I enjoyed it.

Revenant (11/14/2013)

---

L' Eomot Inversé (11/14/2013)

---

dwain.c (11/14/2013)

---

They call this the...

Cooking

Cher (Witches of Eastwick)

Junk

Sean Lange (11/14/2013)

---

Chad Crawford (11/14/2013)

---

SQLRNNR (11/14/2013)

---

Greg Edwards-268690 (11/14/2013)

---

Show me the person who is a master of all things SQL Server.

They are as rare as seeing a unicorn!

SQL Server covers...

Alan.B (11/14/2013)

---

Edward Boyle-478467 (11/14/2013)

---

If OBJECT_ID('TEST_procedure','P') is not Null Drop procedure TEST_procedure

Go

create procedure TEST_procedure

@exampleid XML

as

update tablea

set text_field = 'Y'

where

example_id in (Select x.value('(.)','varchar(100)') from @exampleid.nodes('/List/Field/text()') as x(x))

Go

If object_id('tablea') is Not Null...

Greg Edwards-268690 (11/14/2013)

---

Show me the person who is a master of all things SQL Server.

They are as rare as seeing a unicorn!

SQL Server covers such a broad range of products,...

I don't know, Lowell. It doesn't make much sense to me to have a nonclustered index on the same field as your clustered index unless the nonclustered index contains...