Viewing 15 posts - 1 through 15 (of 45 total)
The link in the final paragraph (Using TDS Remoting with CData SQL Broker) is broken - can you update it please?
August 28, 2017 at 4:08 am
Those listed already plus
#1
IF OBJECT_ID('OBJECTNAME') IS | IS NOT NULL
BEGIN
END
#2
CTEs
#3
The code to create a Digits and then a Numbers table (see https://www.simple-talk.com/blogs/2013/11/14/its-all-a-numbers-game/[/url])
DECLARE @digits TABLE ( d INT )
INSERT @digits...
August 21, 2015 at 8:34 am
Have you checked the power options on them both? If one is set to Balanced then this could make a difference in execution time, it should be High Performance.
October 17, 2014 at 7:56 am
You might be using this code against an earlier version of SQL Server so your results will be mixed. It looks like you need to declare the variable and then...
July 23, 2014 at 2:06 am
@ gpatterson - Yep, you could be right. Hope it proves useful for you.
@ Carolyn - Lots to consider: Does the underlying query produce any values? Is the server...
July 7, 2014 at 1:27 pm
It should be in your inbox! I emailed back in September. Let me know if you need it again
January 31, 2014 at 9:37 am
Happy to cover this one for you Steve, are there any guides on how soon you need it submitted?
J
September 5, 2013 at 3:33 am
[Answer removed. I need to read the question better next time - the other answers have the detail I missed!]
October 24, 2012 at 8:58 am
Isn't the Implicit Conversion in the Computer Scalar operator simply what deals with removing (or adding depending on settings) the trailing spaces (the padding)?
October 24, 2012 at 8:48 am
Andy, for the TSQL step to apply updates and Deletes to the destination database, would you recommend adding indexes to the stage tables that match the indexes on the production...
September 21, 2012 at 8:11 am
If its working then that is what you want. You have a trace running. What more are you expecting?
February 16, 2011 at 8:25 am
I wholly agree with craig 81366. So long as it is agreed, understood and documented then it doesn't really matter whether it's included or not.
January 28, 2011 at 2:07 am
Frank, there are some cases where your formulas dont give the correct values. When you use a series of dates from 2008 formulas 3 + 4 return the wrong days.
December 23, 2009 at 4:17 am
allen-623417 (10/21/2008)
I haven't even scratched the surface of it's features (SSIS, etc) but I LOVE the InteliSense that SQL Server 2008...
December 18, 2009 at 5:37 am
Viewing 15 posts - 1 through 15 (of 45 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy