Viewing 15 posts - 2,491 through 2,505 (of 11,678 total)
I currently have them as well. I hope they dissapear soon.
June 24, 2014 at 12:02 am
If you want to deploy to the SSIS catalog, your project needs to be in the project deployment model.
In that case you cannot deploy using DTUTIL but there are other...
June 24, 2014 at 12:01 am
99% chance that it is a permission issue.
When run in a job, the SSIS package executes under the SQL Server Agent account, unless you specify a proxy.
Make sure that account...
June 23, 2014 at 11:56 pm
SQLRNNR (6/23/2014)
Sean Lange (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
sweet. Seems that the two of us have been racing for the last...
June 23, 2014 at 2:08 pm
Sean Lange (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
sweet. Seems that the two of us have been racing for the last few...
June 23, 2014 at 2:07 pm
😎 13000th point 😎
Also went over 9000 forum posts a while back. :w00t:
June 23, 2014 at 1:12 pm
Another must-read:
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
This book will give you a very solid understanding of the new windowing functions in SQL Server 2012.
June 23, 2014 at 1:11 pm
ChrisM@Work (6/23/2014)
Like your neighbour telling the police you put a chicken bone in the paper recycling bin - whoops, that's Germany, not Belgium - but you get the point.
You sure...
June 23, 2014 at 1:07 pm
chrisn-585491 (6/23/2014)
So, yeah... Sad...
Sad is the word. Sadder still is that at my work a colleague had a bet to guess the background of the author... 🙁
Unfortunately, most of...
June 23, 2014 at 6:47 am
Ed Wagner (6/23/2014)
Koen Verbeeck (6/23/2014)
Ed Wagner (6/19/2014)
Or worse - they store integer values in an nvarchar(8)! Seen it! :w00t: Hated it. :angry:
When importing data from an untyped source...
June 23, 2014 at 5:16 am
EdVassie (6/23/2014)
I somehow think those spammers in some Eastern Europian country will laugh when they receive an invoice
A lot of the companies linked to in the spams had .co.uk addresses....
June 23, 2014 at 4:58 am
Maybe the editorial process could include something like "copy paste a sentence into google and see if something turns up".
It will not catch everything, but at least the pure copy/paste...
June 23, 2014 at 4:12 am
EdVassie (6/23/2014)
I am sure that you are looking at the legal aspects of this, but if you think the spammers might have broken a law please get...
June 23, 2014 at 4:09 am
chalam87 (6/23/2014)
Priority_hashvalue genereate like belowinsert into testtable(priroty1,priroty2,priroty3,Priority_hashvalue) values(@priroty1,@priroty2,@priroty3,hashbytes('md5',(@priroty1+@priroty2+priroty3)))
So it is hardcoded into the table.
Ify you change the data in one of the priority columns, the checksum becomes different than...
June 23, 2014 at 4:06 am
whitesql (6/23/2014)
Yes..all are 32 bit. But still getting that error.
You can perhaps use the ACE OLE DB provider, which is available in 64-bit (and can thus use more memory).
Use the...
June 23, 2014 at 2:28 am
Viewing 15 posts - 2,491 through 2,505 (of 11,678 total)