Viewing 15 posts - 316 through 330 (of 397 total)
GSquared (3/23/2010)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 23, 2010 at 9:54 am
blandry (3/23/2010)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 23, 2010 at 9:51 am
I have always struggled with the decision. I guess I still have a bad taste in my mouth from when an MSCE was way too easy to obtain and...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 23, 2010 at 7:08 am
We have a similar situation using SS2005, however we use synonyms. When I worked on SS2000, I used linked databases to provide a layer of abstraction.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
February 3, 2010 at 8:01 am
While intuitively I expected a result set of (0,1), I must echo what everyone else has said, I also achieved the results set of (1,1) when I tested it for...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
January 29, 2010 at 6:53 am
I should not have made the assumption that the question was solely about the differences between char and varchar! I was assuming (see, that was my problem!) that the...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 4, 2009 at 6:51 am
I agree that both the SQL OS and the T-SQL enhancements should be done. In fact, it seems logical to me that by paring down the OS side, much...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 29, 2009 at 7:44 pm
Michael Ross (8/26/2009)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 26, 2009 at 3:23 pm
A stripped down version of Windows to support SQL Server is a great idea. It's a rather proven concept (as many others have pointed out) that would simplify administration...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 26, 2009 at 1:42 pm
marklegosz (8/18/2009)
I was shocked to see only 49% getting this right (when I checked). Surely all DBAs should be all over this one.
Yeah, it was a "no-brainer" and evidently my...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 18, 2009 at 7:04 am
Doh!! Goes to show what you get when you click through something too quickly without checking your answers! (I checked 0 when I meant to check 1).
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 18, 2009 at 6:42 am
joncooney73 (8/13/2009)
You would ASSUME 'range of values' implies string length here. Obviously it doesn't.
I don't believe so. The range of numeric values is limited because the datatype is limited....
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 13, 2009 at 9:36 am
Slick84 (8/10/2009)
So...why exactly is this happening? I thought the whole 'This is a test string' without the quotes would show up in my result-set.
If you'll notice, the parameter to the...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 10, 2009 at 6:56 am
I've been burnt by this "feature" too often to not recognize it! It took me hours to track down an issue cause by a string truncation that was being...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 10, 2009 at 6:40 am
Paul Thornett (8/7/2009)
IMHO, working (unpaid) overtime on a regular basis because it's expected or required is folly and madness.
I couldn't agree more. One company I worked at previously though...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 7, 2009 at 11:37 am
Viewing 15 posts - 316 through 330 (of 397 total)