Viewing 15 posts - 3,541 through 3,555 (of 7,168 total)
Certs are a weed-out qualification. It takes a bit of time working with SQL Server and studying the material to get to a place where you can write one and...
July 18, 2012 at 1:38 pm
Lynn Pettis (7/18/2012)
pooyan_pdm (7/18/2012)
You can also try it to see what happens
I have, I am talking from experience. If you have a clustered index that is highly fragmented, rebuilding...
July 18, 2012 at 1:20 pm
GilaMonster (7/18/2012)
Kiran.Baderdinni (7/18/2012)
Won't a bad page in the tran log backup (any of the hourly tan backup) have the same outcome?
Corruption is from something in the IO subsystem stamping on...
July 18, 2012 at 1:00 pm
For HA, in my opinion Log Shipping to multiple secondary instances is a much better option than Transactional Replication.
July 18, 2012 at 12:33 pm
Munabhai (7/18/2012)
July 18, 2012 at 12:11 pm
Welsh Corgi (7/17/2012)
I could do an in Place Upgrade to the OS to Enterprise Edition.Has anyone tried that and what was the outcome>
I haven't personally tried it, but have seen...
July 18, 2012 at 12:08 pm
If you place both the dtsx and dtsConfig files in the same path on all computers, i.e. the one you use for development on your own machine, then yes, the...
July 18, 2012 at 11:13 am
Mongo DB provides a JSON/BSON interface to issue commands to retrieve and store data.
Microsoft SQL Server provides a T-SQL interface to do the same. T-SQL stands for Transact-SQL and...
July 18, 2012 at 10:25 am
Munabhai (7/18/2012)
July 18, 2012 at 10:15 am
It looks like you want to take a decimal and turn it into an integer. Try the Data Conversion Transformation instead of the Derived Column Transformation.
July 18, 2012 at 9:38 am
Post your Excel file to this thread as an attachment.
July 17, 2012 at 1:42 pm
In SSIS 2005 you could use VB.NET. As of SSIS 2008 you have the option to use VB.NET or C#.
Here are examples from Microsoft that show what they had in...
July 17, 2012 at 1:36 pm
Viewing 15 posts - 3,541 through 3,555 (of 7,168 total)