Viewing 15 posts - 301 through 315 (of 9,641 total)
Good advice thus far. I didn't take the time to completely analyze your code, but one thing that I have seen help with looping inserts is to use explicit...
August 13, 2015 at 2:07 pm
When I'm involved in interviews I ask if they know about the tally/number table. I'm always surprised how many people have never heard about it. If they have...
August 13, 2015 at 2:04 pm
I'm going to do something I typically don't do and disagree with Grant and Erikur. Unless the vendor has specific policy that states that there are specific schemas or...
August 13, 2015 at 1:50 pm
Unfortunately not a simple thing to do and any way to do it has performance implications. You can't use Fast Load because that uses bulk insert and not a...
August 13, 2015 at 1:40 pm
GilaMonster (8/13/2015)
Seriously, the limit for a table name is 128 characters iirc, why does the table have to be named TSKGRPMBRS?
Because consonants are free and vowels cost $250. 😛
August 13, 2015 at 9:10 am
...Of course the case sensitivity thing is rather silly in that system. Every table name and every column name are exactly 6 UPPER case letters.
That's why they are all 6...
August 13, 2015 at 7:42 am
I agree with Grant. Both of those tools are good and I've used both at some level. You can also sort of use both tools together as each...
August 12, 2015 at 9:29 am
I agree with Grant. Neither option is the best option. A separate Marks/grades table that stores each grade as a new record with proper data typing.
August 12, 2015 at 9:22 am
This would be the package protection level which will encrypt sensitive data.
August 12, 2015 at 9:06 am
There a couple of things that pop into my head:
1. Modify the triggers to insert into a table when they fire. Obviously adds overhead to each trigger firing.
2. Server...
August 12, 2015 at 8:51 am
A different person to each what?
Something like this will create a random order:
SELECT * FROM #temp AS T ORDER BY NEWID();
August 12, 2015 at 8:29 am
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
Yuck....
August 11, 2015 at 9:09 am
You could also be experiencing the issue listed here, http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/08/20/error-while-deploying-ssis-2012-project-from-ssdt-to-ssis-catalog-system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client.aspx
August 11, 2015 at 8:09 am
Did you check the details on the error as Jayanth suggested?
Can you navigate the catalog in SSMS?
August 11, 2015 at 8:07 am
Viewing 15 posts - 301 through 315 (of 9,641 total)