BenWard

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 264 total)

RE: Big Gaps

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

September 23, 2011 at 5:01 am

#1385607
RE: Dotted Line Relationships Are Everywhere – Get Good at Them!

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

September 16, 2011 at 2:08 am

#1382415
RE: Breakfast

Sad day when a scottish hotel goes Englified... burn it down!
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

September 5, 2011 at 2:22 am

#1376967
RE: A Flock of SQL Servers

Darren Wallace (8/19/2011)
Hmm... new method of monitoring install based licencing... Ow! My brain just punched me for even joking about it.
That would be easy to hack though, run a...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 19, 2011 at 9:47 am

#1370849
RE: A Flock of SQL Servers

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 19, 2011 at 8:51 am

#1370791
RE: A Flock of SQL Servers

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 19, 2011 at 7:14 am

#1370704
RE: A Flock of SQL Servers

SQL Server twitter spammer?
that could make some money 😉
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 19, 2011 at 2:54 am

#1370589
RE: How well do you know MAX?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 5, 2011 at 8:59 am

#1364412
RE: How well do you know MAX?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 5, 2011 at 8:18 am

#1364378
RE: Cleaning Duplicate Data

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 5, 2011 at 8:13 am

#1364373
RE: Cleaning Duplicate Data

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 5, 2011 at 7:55 am

#1364361
RE: How well do you know MAX?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 5, 2011 at 2:22 am

#1364142
RE: That case filter

Tom.Thomson (7/27/2011)
BenWard (7/27/2011)
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.
I'm glad the MS...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

July 27, 2011 at 8:43 am

#1359320
RE: That case filter

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.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

July 27, 2011 at 2:03 am

#1359002
RE: That case filter

Ross Crawford (7/26/2011)
I said returned, not selected those are NOT synonyms). There's no dataset being returned so 0 is the correct answer.
However, returning no dataset is not strictly the...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

July 26, 2011 at 2:02 am

#1358279

Viewing 15 posts - 136 through 150 (of 264 total)