Viewing 15 posts - 2,491 through 2,505 (of 11,676 total)
I currently have them as well. I hope they dissapear soon.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 23, 2014 at 2:07 pm
😎 13000th point 😎
Also went over 9000 forum posts a while back. :w00t:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 23, 2014 at 2:28 am
Viewing 15 posts - 2,491 through 2,505 (of 11,676 total)