Viewing 15 posts - 1 through 15 (of 160 total)
Ah, I was researching elemenTARTY keys, probably why I got it wrong 😉
October 5, 2011 at 3:09 am
since switching to contracting 3 years ago, I've found fitting in and becoming part of the team much quicker and easier to do. on average, it'll take me around...
July 19, 2011 at 4:19 am
Good question, great answer 🙂
March 21, 2011 at 4:52 am
Thanks, Jeff. Also some interesting stuff about control characters, something I've never really considered before.
March 18, 2011 at 2:54 am
archie flockhart (10/27/2010)I might have had to think twice if the possible answers had been April 30th, April 31st and May 1st.
archie flockhart (10/27/2010)
My thoughts exactly
October 27, 2010 at 2:13 am
Argh, got this one wrong (I knew it as I clicked the button).
Managed to work out what the second field was for and then rushed my answer for the first...
April 16, 2010 at 2:20 am
arghh!! I spent a few minutes playing with a spreadsheet to mock up the bitwise AND and OR functions (a happy little diversion) and i missed the data type gotcha!
October 14, 2009 at 2:13 am
Warren Gilbert (10/1/2009)
The question specifically asks for extensions (subclauses) to the GROUP BY clause.
GROUPING_ID is a function, NOT a sub-clause...
October 1, 2009 at 2:45 am
if you use SSMS, you can right-click on the table and choose properties. Within the properties window there is a section for storage which has an entry for the...
September 3, 2009 at 3:14 am
have worked out how to implement this using a hierarchy bridge and multiple hierarchies. see the section on multiple hierarchies in this pdf document for more information.
happy to discuss...
September 1, 2009 at 8:26 am
Ideas/things I have tried:
Implemented multiple perspectives that are identical apart...
June 22, 2009 at 3:41 am
Does anyone have any ideas about this? Or, even know if this is possible? I need to know by the end of the day if it can be...
June 22, 2009 at 2:39 am
i hate to be a pedant, but the var in varchar and nvarchar stands for varying:
June 18, 2009 at 3:21 am
I enjoyed this article; a good introduction to test-driven database development, something I have been looking to implement for quite some time.
I would be interested to see this expanded with...
April 30, 2009 at 2:25 am
I have been able to solve this (after coming back to it after a little while) by using the dts.Events.FireCustomEvent method.
The method's signature is: eventName as string, eventText as string,...
November 28, 2008 at 6:07 am