Viewing 15 posts - 271 through 285 (of 497 total)
aaron.reese (2/11/2014)
If they would only add an SSIS / SSRS documenter solution it would be perfect.Aaron
PragmaticWorks have a BIDocumenter product that may meet your needs. Disclaimer: I don't work for...
February 11, 2014 at 7:43 am
I don't expect Mist sells very well in German-speaking countries! 😉
February 11, 2014 at 5:32 am
Koen Verbeeck (2/11/2014)
How can a single column be a composite key?
😀
Assuming that there is at least one more column involved here, I'd say that to some extent it depends...
February 11, 2014 at 2:51 am
Use a RowCount transform in your Data Flow task just after your OLEDB Source component and store the result of the RowCount in a variable, scoped at the Package level.
In...
February 7, 2014 at 7:34 am
It's an interesting discussion this. I think most of the time we gravitate to what we are most comfortable/familiar with to solve a problem, rather than choosing the 'best' option...
February 7, 2014 at 1:57 am
I have a book titled 'Practical MDX Queries for Microsoft SQL Server Analysis Services 2008" by Art Tennick that contains over 300 practical MDX examples, but I think the OP...
February 6, 2014 at 8:49 am
Kevin,
1) Should developers use their own windows login? Or a Generic Domain User Account (which means they would have to log onto windows with this Domain User Account each time...
February 5, 2014 at 8:11 am
Alone (2/5/2014)
We have sql2005 standered edition and now a days one sql job is getting hanged frequently.
Have you tried:
sp_configure 'disable capital punishment', 1?
😀
February 5, 2014 at 4:06 am
p.swathi4 (2/3/2014)
The ole db provider "sqlncli10" for linked server '' servername" indicates that either the object has no columns or the current user does not have permissions on that object.
The...
February 3, 2014 at 9:20 am
Jeff Moden (2/3/2014)
Thanks, Lempster. Seems like all of that makes emergency repairs pretty tough.
Yes, I guess a lot of DEVs\DBAs would prefer to tackle break-fix issues using scripts. Reading...
February 3, 2014 at 8:01 am
Jeff Moden (2/3/2014)
February 3, 2014 at 7:40 am
Koen Verbeeck (2/2/2014)
asranantha (2/2/2014)
February 3, 2014 at 3:07 am
Jeff Moden (1/31/2014)
The truth be told, they're both not that great because of the mixed character data in denormalized columns instead of using the correct DATETIME datatype.
Yep, and I think...
January 31, 2014 at 8:23 am
sneumersky (1/30/2014)
Dude, I really feel for you getting put through the ringer like that.
Thanks! 🙂
I have to be phlegmatic about it and think that at least I'll learn something along...
January 31, 2014 at 2:13 am
Viewing 15 posts - 271 through 285 (of 497 total)