Viewing 15 posts - 8,026 through 8,040 (of 11,676 total)
Did you set the Run64BitRuntime property of the project to false?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:34 am
An off-topic question: why don't you load the Excel directly in the database, instead of dumping it in a flat file first?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:33 am
I don't have a quick answer for you - query compiling is not really my strong suit - but I can recommend you this books you can download for free...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:28 am
Wouldn't this be mentioned in the documentation material of double-take?
You can download it from their site.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:25 am
shahid_jambagi (2/9/2012)
thanks a lot for informing me ....:)intention was to benifit others searching such type of questions. hope you got it.
I already got it from the first two replies, which...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:20 am
AAYakovenko (2/8/2012)
Thanks SSChampion.I know about concat over XML.
I want to know the reason for this behavior stranngo.
For some reason, the += acts as a = when you use a function...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:19 am
vijaymadh (2/9/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:16 am
shahid_jambagi (2/8/2012)
log windows is pop up
Server type is by default
server name is by default...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:14 am
Drew Gillson (2/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:13 am
That setting specifies the maximum amount.
It does not garantuee that SQL Server will effictively take that amount of RAM.
Try a combination with the minimum amount of memory.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:09 am
So you post only a part of the query, no details about the server itself and what is running on that server, no table definitions, no information on indexes, no...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:06 am
Linda Robinson (2/8/2012)
If I click on the package and select Execute Package logging works. It doesn't,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 9, 2012 at 12:03 am
Linda Robinson (2/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2012 at 2:36 pm
Eric Mamet (2/8/2012)
Many thanks for your help. It was (and still is) much appreciated.
No problem, glad to help.
I hope everything goes smoothly from now on.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2012 at 1:07 pm
HowardW (2/8/2012)
The most straight forward example would be:
SELECT 1+2-1
That really is straight forward 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2012 at 7:20 am
Viewing 15 posts - 8,026 through 8,040 (of 11,676 total)