Viewing 15 posts - 46 through 60 (of 75 total)
Actually,
They should use COALESCE, it's much easier to use, doesn't request nesting for multiple tests and is ANSI SQL compliant.
ISNULL may not be ANSI SQL compliant, but I think you...
March 23, 2009 at 3:55 pm
Sounds a lot like genetics. The "Pure Breeds" are often far more susceptible to health problems whereas the mongrel will be healthy for decades 🙂
February 11, 2009 at 2:33 pm
K. Brian Kelley (2/10/2009)[hr
From a security perspective, we've come to the point where we don't assume that because you're behind a firewall, you're okay. Nimda, Welchia, and now Conficker have...
February 10, 2009 at 3:17 pm
I think it all depends.
If your server is in a position where it is accessible to the net at large, then oh yeah, AV that bad boy, run it real...
February 9, 2009 at 10:28 pm
I would love to be able to pass in an array variable as a variable and not some hacked delimited list that requires processing to rip it apart into a...
January 26, 2009 at 9:18 pm
agile > waterfall
when done correctly for your environment.
Yes I realise that many people still aren't convinced, and that's fine, but this is my opinion and a lot of the concepts...
January 26, 2009 at 4:05 pm
I remember reading a similar article on here back in 2007 (http://www.sqlservercentral.com/articles/Advanced+Querying/3181/[/url])
Always good for these things to pop up every now and again, keeps people thinking about ways to do...
January 6, 2009 at 4:12 pm
Cool.
Yup, BOL needs that "more info needed" button alright 🙂
November 24, 2008 at 8:07 pm
Hrmm...
Either BOL is wrong or there is a bug (sorry, undocument feature) in SQL Server, either of which is possible.
One question I do have is whether the windows 2k3 password...
November 24, 2008 at 4:17 pm
One thing I think people need to be careful of is sequence.
If you set expiration off and then follow up with a set check policy on then the check policy...
November 24, 2008 at 3:27 pm
Per Books Online under the section headed Password Policy
Policy Enforcement
The enforcement of password policy can be configured separately for each SQL Server login. Use ALTER LOGIN (Transact-SQL) to configure the...
November 24, 2008 at 2:39 pm
I can understand your confusion, some of the comments and examples are referring to faking an array for data that already exists in the database, which I do have to...
November 16, 2008 at 5:32 pm
The english language, she's a savage beast 🙂
And yes, more emoticons, MORE I TELL YOU!
November 4, 2008 at 4:46 pm
I read it the first time. You seemed to say (and therefore like it or not did say) it was about 3D arrays, but the author didn't go far enough...
November 4, 2008 at 4:05 pm
Viewing 15 posts - 46 through 60 (of 75 total)