Forum Replies Created
Viewing 15 posts - 1 through 15 (of 21 total)
-
RE: Drop Databases
Wondered whether this might be a trick question, but the correct answer seemed pretty obvious.
Glad to know I can't accidentally drop tempdb ...
-
RE: Character Field Declaration
Nice question - neatly demonstrates the two uses of the "char" keyword in T-SQL.
Also, I managed to get it right without looking it up or loading up SSMS, which is...
-
RE: SQLServerCentral apologizes and you can win a book
Firstly - well done on dealing with the plagiarism issue so openly - and a free book giveaway never hurts!
We use windows functions extensively in our code base, particularly for...
-
RE: REGEX
Mighty (11/14/2013)
As far as I know SQL Server can only handle REGEX via the CLR, so .NET.The queries as shown here were not using REGEX.
+1
This was a really good question...
-
RE: The MCM Program is dead. Long live the MCMs!
I think there's an understandable negative attitude towards MS certifications amongst a lot of experienced developers. That's probably better than taking an overly rosy view of what certification can...
-
RE: Global Configuration Settings
"The SQL Server Database Engine recognizes any unique string that is part of the configuration name."
Wow, I did not know that. Good question, I always like it when I...
-
RE: Stunned
David.Poole (8/28/2013) My expression would be "Kalen Delaney".
I was about to say pretty much exactly the same thing. Having seen her speak at this year's SQLBits, I can...
-
RE: Expressions
As many others have said - great question, probably the best I've seen on the site. Challenging without being pedantic.
I did get it wrong but understand why and definitely...
-
RE: A Beginners Look at Hadoop
David.Poole (6/5/2013)
Have a look at the SQLBits website for Justin Langford's presentation on HDInsight. Again, its very easy to install this on a Windows box and get started. ... -
RE: Assigning values to Variables with CASE
Hugo Kornelis (4/3/2013)...The code was long and complicated, making this question more an exercise in parsing code....
...which personally I quite enjoyed in this instance, but agree that Hugo's recommendations to...
-
RE: Updating Views
Hugo Kornelis (2/7/2013)
paul s-306273 (2/7/2013)
Steve - 0 points to you for creating a view using 'select *'...
So how should Steve have made a QotD about the dangers of select *...
-
RE: Data compression
roger.plowman (1/30/2013)
if your application makes extensive use of seperate data, it would seem you would really need it.
Yes - exactly why I thought this was a good question. ...
-
RE: BIT Primary Key
Good question, not too difficult but required taking into account PK, check constraint and data type which meant it took me a few seconds.
Obviously some valid criticisms of the explanation...
-
RE: File Tables
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..need to read it again ..
+1
-
RE: Developer Deployment Frustrations
To get back to the original topic...
From my experience of working in a small (3-man) development/ IT team, easier access to the cut-down versions of SQL Server should hopefully mean...
Viewing 15 posts - 1 through 15 (of 21 total)