Viewing 15 posts - 916 through 930 (of 11,676 total)
below86 (3/12/2015)
Koen Verbeeck (3/12/2015)
below86 (3/12/2015)
Koen Verbeeck (3/12/2015)
below86 (3/12/2015)
I'm not a fan of SSIS 2012 for sure, 2008 is OK.🙁
What's worse in 2012 than in 2008?
One huge problem I see...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 8:49 am
Alvin Ramard (3/12/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 8:21 am
below86 (3/12/2015)
Koen Verbeeck (3/12/2015)
below86 (3/12/2015)
I'm not a fan of SSIS 2012 for sure, 2008 is OK.🙁
What's worse in 2012 than in 2008?
One huge problem I see so far is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 8:17 am
below86 (3/12/2015)
I'm not a fan of SSIS 2012 for sure, 2008 is OK.🙁
What's worse in 2012 than in 2008?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 7:59 am
spaghettidba (3/12/2015)
rodjkidd (3/10/2015)
Gianormous (:-) ) was only there Saturday as far as I know. So if you did see him on Thursday then you should have also done the lottery!
Yes,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 3:22 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 3:12 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 3:10 am
I think the dummy tables is a good idea to reduce locking and contention on the destination table.
At the end, you can write a UNION ALL query on all the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2015 at 3:08 am
SQLRNNR (3/10/2015)
Jack Corbett (3/10/2015)
Wow! I have little to say.😀
You rock!
I'd say he's clearly the bigger man 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2015 at 2:24 am
Which edition do you have of SQL Server?
Regarding the XML files: how complex are they? What kind of processing do you do?
Parallellism seems the most obvious performance improvement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2015 at 2:23 am
PRAMANA.DBA (3/11/2015)
Thanks,I am gng to install SQL 2005, But already I installed SQL 2012 and Visual studio 2010,
Should I Uninstall Visual Studio 2010 ?
Not if you ever...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2015 at 2:19 am
8GB is low, very low. The OS needs RAM, SQL Server needs RAM, so there is very little left for SSIS, which is a memory-intensive application. My laptop has more...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2015 at 1:45 am
To develop SSIS 2005, you need BIDS 2005 (the shell of Visual Studio 2005). You can find this on the installation media of SQL Server 2005.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2015 at 1:43 am
Brandie Tarvin (3/10/2015)
SQLRNNR (3/10/2015)
Jack Corbett (3/10/2015)
SQLRNNR (3/9/2015)
Jack Corbett (3/9/2015)
Grant Fritchey (3/9/2015)
By the way, Gianluca is a giant.
So this means if and when I meet Gianluca he'll...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 3:17 pm
Eric M Russell (3/10/2015)
A medium powered server should be able to perform a full table scan of 200 million rows...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 11:33 am
Viewing 15 posts - 916 through 930 (of 11,676 total)