Viewing 15 posts - 3,631 through 3,645 (of 11,678 total)
Nice example Jeff, I'll keep it in mind.
February 27, 2014 at 6:40 am
pmadhavapeddi22 (2/27/2014)
I would like to gain performance also 🙁Thanks for the reply
CTEs won't give you a performance gain.
Indexing might. Maybe you can create an indexed view.
February 27, 2014 at 6:33 am
As far as I know there isn't a training kit for this exam. I'm not convinced there will be released one either.
There's a course though for this exam with an...
February 27, 2014 at 5:45 am
Sushil Dwivedi (2/27/2014)
I don't think you can add primary key on the column which has duplicates values already
Indeed. That's why I suggested an unique filtered index.
February 27, 2014 at 4:18 am
I might take one up. How long is an editorial supposed to be?
February 27, 2014 at 12:23 am
It should be possible.
If you install SP1, you can choose which instances to upgrade.
Haven't done it myself though, so I am not aware of any potential pitfalls.
February 27, 2014 at 12:21 am
Jeff Moden (2/26/2014)
Koen Verbeeck (2/26/2014)
February 26, 2014 at 11:53 pm
super48 (2/26/2014)
i didn't taken destination connection string in XML configuration
Any specific reason you did not include it in the configuration?
What is the protection level of the package?
February 26, 2014 at 11:48 pm
How did you try to modify the config file?
Through the package configurations?
The location of the XML config file is hardcoded into the package, for example C:\Configs\MyConfigFile.dtsconfig.
On the other machine, the...
February 26, 2014 at 3:43 am
Are you sure the file is ANSI?
Open it up in a decent text editor such as Notepad++ (it is free) and check the encoding.
February 26, 2014 at 3:36 am
Viewing 15 posts - 3,631 through 3,645 (of 11,678 total)