Viewing 15 posts - 271 through 285 (of 429 total)
sipas (1/24/2013)
KWymore (1/24/2013)
I knew I was going to get this one wrong since it was basically a opinion piece. Good discussion but not a great question.
It's not really an opinion...
January 24, 2013 at 9:35 am
Hmm, I would think the answer to this question would be "it depends". Based on my assumptions about the limited information provided, a relational model would seem to be...
January 24, 2013 at 8:12 am
Nice question. I was concerned a bit by the specification of SQL Server 2012... had to double-check to make sure they didn't change this behavior in that version.
January 23, 2013 at 7:34 am
I imagine everyone has their own approach to this.
Your approach of using linked servers will definitely work.
I use a C# application I wrote that lets me run T-SQL...
January 19, 2013 at 2:23 pm
Lynn and Ignacio are right. If you are responsible for these servers, it's important that you start developing the skills and knowledge you need to maintain them. Running...
January 19, 2013 at 1:31 pm
If you use T-SQL, you'll probably want to use a cursor to loop through all of the linked servers. You can find all the linked servers in the Sys.Servers...
January 18, 2013 at 2:37 pm
I generally like questions regarding peculiar behavior.
It's too bad the wording of the question was a bit off. I too looked within the estimated execution plan for...
January 18, 2013 at 9:41 am
Great question!
I used to use a similar query as an example for developers to show why they should always alias tables, especially in subqueries.
January 17, 2013 at 7:19 am
Interesting.
I can't believe I've never tried to put a TRY/CATCH in a function before.
January 16, 2013 at 9:06 am
Toreador (1/10/2013)
sestell1 (1/10/2013)
Toreador (1/10/2013)I think there's a common misconception that each letter of the acronym is a higher priority than the next, instead of being pairs of operations.
That's true, but...
January 10, 2013 at 7:43 am
Toreador (1/10/2013)
BODMAS 🙂currently 7 wrong answers...
I'm alwasy surprised how many posts like this QOTD I've seen elsewhere where people proudly state BODMAS and then manage to come up with the...
January 10, 2013 at 6:48 am
Toreador (1/2/2013)
Steve Jones - SSC Editor (1/1/2013)
I changed to question to exclude Jan 31, this that doesn't work.Jan 30 won't work either. Jan 29 will only work in leap years.
+1
January 2, 2013 at 7:46 am
Ugh, spent way too long trying to figure out which one of 1, 4, 5 wasn't reliable before simply guessing to see the explaination. Glad to know I wasn't...
December 26, 2012 at 9:14 am
Nice question, I'd completely forgotten about this limitation.
December 13, 2012 at 7:41 am
Viewing 15 posts - 271 through 285 (of 429 total)