Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 3,391 through 3,405 (of 11,676 total)

RE: installing Sql 2012 Evaluation version on Windows 7 Pro

Maybe you can try deleting from the command line. You can specify specific instances and specific features there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 31, 2014 at 1:19 am

#1701484
RE: How to get this output?

Is this a homework assignment?
Hint: left outer join.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 31, 2014 at 1:07 am

#1701480
RE: Are the posted questions getting worse?

dwain.c (3/31/2014)
Now I'm just a project manager so I'm not expected to know anything technical about computers, judging by some of the project managers I've seen recruited out of business...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 31, 2014 at 1:05 am

#1701478
RE: Are the posted questions getting worse?

dwain.c (3/30/2014)
The fact that they actually have the gall to call them "software engineers" is a blatant insult to anyone that actually graduated with an engineering degree.
True dat 🙂
I have...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 31, 2014 at 12:55 am

#1701476
RE: SSIS 2012 Environment Variables and Source Control

happycat59 (3/30/2014)
Environment variables are actually stored in the registry. So, exporting them using something like "regedt32" will give you a ".reg" file that you can save into source control.
The...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 31, 2014 at 12:53 am

#1701475
RE: Default schema

WTH?
The script doesn't mention sysadmin but database owner.
The created user doesn't have sysadmin permissions, so the table will be created using the default schema.
Points back please!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 31, 2014 at 12:23 am

#1701471
RE: Strange issue while loading data from Excel using SSIS package

swathy.reddy7 (3/29/2014)
hi,
anybody please help me how can I load the data from excel to DB with using of SSIS package please share with screen shots....
Did you try Google?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 29, 2014 at 7:54 am

#1701369
RE: Getting Fired

John Hanrahan (3/27/2014)
How about getting fired for spending too much time reading the editorials and comments on SQLServerCentral?
Hopefully not true, but someone did mention Facebook.
Come come, that's called continuous learning...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 1:11 pm

#1700859
RE: compare two datasets in ssrs

doug.brown (3/27/2014)
You could perhaps try using ReportItems. Have Table A with the results form dataset 1, and Table B with the results from dataset 2. These two tables...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 1:09 pm

#1700858
RE: How do I clean old data connections out of an SSIS package?

nonghead-webspam (3/27/2014)
Koen Verbeeck (3/27/2014)
Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.
Run the package. If there's an error,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 1:08 pm

#1700857
RE: How do I clean old data connections out of an SSIS package?

Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.
Run the package. If there's an error, repeat the previous...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 11:28 am

#1700826
RE: SQL Server Agent - SSIS Package Fail as the connection cannot be seen by the Agent

tlally (3/27/2014)
I recreated the package from the beginning new connection managers but I am still getting the same error.
The connection "{EFC6889A-D312-4A9E-B251-877C7A67B8DF}" is not found. This error is thrown by Connections...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 11:27 am

#1700824
RE: GUID Pirmary key

GilaMonster (3/27/2014)
Koen Verbeeck (3/27/2014)
should a table always be clustered instead of a heap?
Yes, in vast majority of cases.
Heap has the forwarded records and the non-deallocation of pages to contend with,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 8:37 am

#1700717
RE: How do I clean old data connections out of an SSIS package?

nonghead-webspam (3/27/2014)
What is the proper procedure when deleting stuff? What do I check for to make sure I don't take out too much or too little?
And, is there some...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 8:36 am

#1700714
RE: Are the posted questions getting worse?

Sean Lange (3/27/2014)
Koen Verbeeck (3/27/2014)
W00t w00t, this one makes my 12000th point. 😎
Congrats!
Thanks. I do my best to keep ahead of you 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

March 27, 2014 at 8:26 am

#1700708

Viewing 15 posts - 3,391 through 3,405 (of 11,676 total)