Viewing 15 posts - 16 through 30 (of 86 total)
amcalpine (6/24/2013)
This looks promisinghttp://www.red-gate.com/products/sql-development/sql-automation-pack/
+1 for this solution which got demo'd at SQL in the City last week. Your best bet would be to speak to the guys...
June 24, 2013 at 4:48 am
kevaburg (6/19/2013)
Are the two machines no the same subnet? If not then there might be an ACL on a border router blocking the port.
Good thinking Penfold! 🙂
They're both...
June 19, 2013 at 5:51 am
Thanks Elliot, we're scheduled to have another look at this one tomorrow. The only difference I've got on my gmail setup is the port number so I'll give that...
June 18, 2013 at 10:03 am
Hugo Kornelis (6/18/2013)
Toreador (6/18/2013)
I got this wrong, but having read the explanation I'm still none the wiser...
To understand the mechanics, start with the subquery:
SELECT Departmentid
FROM Emptable AS Emptable_1
WHERE (Empid...
June 18, 2013 at 3:06 am
Elliott Whitlow (6/17/2013)
I'm verifying that you are trying telnet and ping by name and not...
June 18, 2013 at 2:20 am
Ambiguity thou art a bitch!!
Luckily got it right but it was always going to be a gamble due to the available answers!
June 17, 2013 at 6:52 am
kapil_kk (6/14/2013)
Lokesh Vij (6/13/2013)
DROP TABLE [dbo].[IndexTable]
SELECT * FROM indextable
Qotd aks about "the output of select statement", but as per the code this...
June 14, 2013 at 2:10 am
Thanks for responding so quickly guys.
@Gail - that'll teach me to read the error messages in full - when I grow up I want to be a proper DBA!! 😀
June 10, 2013 at 4:38 am
I was wondering about the collation issue (i.e. case sensitive or not) and as the question didn't specify the collation I took a punt...... and got it wrong! Hey Ho....
June 6, 2013 at 4:33 am
This one made me chuckle even though I went for the sp_addmessage answer, very good start to my day. 😀
June 5, 2013 at 2:58 am
Problem solved (ish):- Caused by 32bit OS restricted to max of 4Gb - time to get to the root of what is using so much memory now then!! 😀
May 30, 2013 at 4:39 am
kapil_kk (5/15/2013)
Lokesh Vij (5/15/2013)
I found Today's question relatively easier than yesterday. 🙂true 😛
+1 to that but I was looking for a catch somewhere in the answers though (paranoid much!!)...
May 15, 2013 at 1:34 am
Liked that one, looked innocuous at first then had a think about it and had a facepalm moment as I was writing out what I thought the results would be...
May 14, 2013 at 2:45 am
Ness (5/10/2013)
RAID 10 should be better for write operations but a more expsensive option. RAID 6 good al rounder but slower for write i/o Thick disks are probably best.
Thanks Ness,...
May 10, 2013 at 4:06 am
Interesting one, had to use sp_help though as I wasn't 100% sure! 😀
May 10, 2013 at 2:20 am
Viewing 15 posts - 16 through 30 (of 86 total)