Viewing 15 posts - 7,741 through 7,755 (of 13,877 total)
ElNevera (1/7/2016)
Phil Parkin (1/7/2016)
So, do your development using Windows Auth and then use an SSISDB Environment to reconfigure the connections accordingly after deployment, so that they work on the server.
Thanks...
January 7, 2016 at 10:00 am
ElNevera (1/7/2016)
Phil Parkin (1/7/2016)
Is there a reason you're not using Windows Authentication?
Whilst initially setting up the packages we were using Windows Authentication but when I deployed the packages to SQL...
January 7, 2016 at 8:55 am
dramon14 (1/7/2016)
January 7, 2016 at 8:53 am
ElNevera (1/7/2016)
I work in a newly created BI team. We have experience using Business Objects for ETL and some development experience using Visual Studio 2013 and TFS. We are using...
January 7, 2016 at 8:38 am
Michael L John (1/6/2016)
Ed Wagner (1/6/2016)
Sean Lange (1/6/2016)
Ed Wagner (1/6/2016)
Brandie Tarvin (1/6/2016)
Sean Lange (1/6/2016)
January 6, 2016 at 1:41 pm
Alvin Ramard (1/6/2016)
Jeff Moden (1/6/2016)
Brandie Tarvin (1/6/2016)
djj (1/5/2016)
SQLBill (1/5/2016)
If I hear of any openings anywhere that allow full work from home, I'll pass them your way.-SQLBill
There all over the internet.:-P...
January 6, 2016 at 9:58 am
Sean Lange (1/6/2016)
January 6, 2016 at 9:53 am
sql_only (1/6/2016)
Phil Parkin (1/6/2016)
sql_only (1/6/2016)
Phil Parkin (1/6/2016)
sql_only (1/6/2016)
was missing DECIMAL(18,16)...Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).
Yes you're right.
I have had to...
January 6, 2016 at 8:04 am
sql_only (1/6/2016)
Phil Parkin (1/6/2016)
sql_only (1/6/2016)
was missing DECIMAL(18,16)...Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).
Yes you're right.
I have had to settle with 2...
January 6, 2016 at 7:09 am
Hugo Kornelis (1/6/2016)
GilaMonster (1/6/2016)
On the same disk, none at all.
... in most scenarios.
If you have a database that has a very high amount of table allocations and deallocations, you can...
January 6, 2016 at 6:39 am
sql_only (1/6/2016)
was missing DECIMAL(18,16)...
Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).
January 6, 2016 at 6:02 am
bpowers (1/5/2016)
January 5, 2016 at 1:29 pm
antonio_scp125 (1/5/2016)
Every time that a record are insert in the table, the flag New_Player be equal...
January 5, 2016 at 12:27 pm
antonio_scp125 (1/5/2016)
The beginning of the contract
Please bear in mind that I have no idea about your data. I do not know what your contracts are. I don't know what 'players'...
January 5, 2016 at 11:52 am
This construct
t.ticket_date BETWEEN @SearchFromTicketDate AND @SearchToTicketDate + ' 23:59:59:997')
Should be written like this, to completely avoid any problems with fractions:
t.ticket_date >= @SearchFromTicketDate AND t.ticket_date < (@SearchToTicketDate + 1 day))
January 5, 2016 at 11:24 am
Viewing 15 posts - 7,741 through 7,755 (of 13,877 total)