I'm shocked at the number of IT people who class themselves as professionals who have never written a single line of code in their lives.

No, you don't necessarily need to...

I hate dotted lines. It often seems to me that there are more dotted ones than solid ones...

If you have requirements of another team, you should be raising a...

Sad day when a scottish hotel goes Englified... burn it down!

That would be easy to hack though, run a...

or, you could set up a php webpage, presented over https, which is username and password protected that presents you with a text box to enter the number, and a...

I don't see any purpose for this where DBAs are concerned but some businesses would love it.

Say for example you work for a company like Perkz or Groupon or HotUKDeals...

SQL Server twitter spammer?

that could make some money 😉

Sean Lange (8/5/2011)

---

BenWard (8/5/2011)

---

Am I the only person who thinks those salaries are horrifically low?! If I was only paid 5000 units of currency per year (regardless of currency!) I...

Am I the only person who thinks those salaries are horrifically low?! If I was only paid 5000 units of currency per year (regardless of currency!) I wouldn't be best...

and another thing (apologies if this is overly simplistic) but if at all possible make sure your server has more (preferably over double) RAM available to it than there is...

dunno maybe this is more efficient?

INSERT INTO SampleTableDetails_Clean

SELECT *

FROM SampleTableDetails

WHERE SampleTableId IN (

SELECT * FROM @UniqueIds

)

AND DATED BETWEEN @startDate AND @endDate

changes to:

INSERT INTO SampleTableDetails_Clean

SELECT a.*

FROM SampleTableDetails a

JOIN...

sneaky! very nearly got that one wrong.

I think the use of 'not in' threw me off there as opposed to <>

'not in' implies that multiple results are going to...

Tom.Thomson (7/27/2011)

---

I'm glad the MS...

I know rowcount would have returned 5, my point was that Microsoft's developers themselves consider no results grid to equal 0 rows not null rows.

Ross Crawford (7/26/2011)

---

However, returning no dataset is not strictly the...