Viewing 15 posts - 6,241 through 6,255 (of 7,484 total)
mavelzen (2/3/2011)
If you can point me at a resource that tells me how to do a set-based update with a different value for each line...
February 3, 2011 at 9:27 am
EdA ROC (2/3/2011)
February 3, 2011 at 8:24 am
Brandie Tarvin (2/3/2011)
GSquared (2/3/2011)
So, yeah, let them use Excel as a database, so long as they understand the issues with concurrency, contention, integrity, reliability, recoverability, et al.
I have highlighted the...
February 3, 2011 at 7:44 am
Hugo Kornelis (2/3/2011)
Great question!I'm surprised (and, frankly, disappointed) about the large percentage of incorrect answers, though.
yes, it's a good questiopn. And yes, that half of the answers are incorrect...
February 3, 2011 at 7:38 am
Koen (da-zero) (2/2/2011)
Did I interprete the following line wrong?
Because the events occur in this order, you can dynamically redirect a configuration by using the /SET command-line option to change...
February 2, 2011 at 11:56 am
I can't see from the information provided whether the query will actually deliver a value for all the columns in each row - I'm pretty sure it won't, but a...
February 2, 2011 at 11:49 am
Judging by your sample data, 20k rows will need a buffer of a bit less than 9 Mbytes; that's something I would normally regard as perfectly acceptable for a client-side...
February 2, 2011 at 11:21 am
EdA ROC (2/2/2011)
Can you make this any easier? 🙂I wonder why I couldn't find anything when I Googled - I spent almost 3 hours searching.
Thanks so much.
Maybe...
February 2, 2011 at 10:36 am
Koen (da-zero) (2/2/2011)
Carlo Romagnano (2/2/2011)
Koen (da-zero) (2/2/2011)
paul s-306273 (2/2/2011)
So, is the correct answer 'FALSE'?
No, it is TRUE.
You cannot use the /Set or the /Connection option to override single values that...
February 2, 2011 at 10:18 am
Dave Ballantyne (2/2/2011)
questionhacker , is certainly on my 'one to watch' list.http://www.sqlservercentral.com/Forums/Topic1057295-391-1.aspx
I liked your comment about his long term prospects (it seemed pretty accurate) http://www.sqlservercentral.com/Forums/FindPost1057312.aspx
February 2, 2011 at 5:39 am
Brandie Tarvin (2/2/2011)
CELKO (2/1/2011)
February 2, 2011 at 5:34 am
ta.bu.shi.da.yu (2/1/2011)
"Even though neither the science nor politics of climate change is fully established yet..."Have you read the IPCC papers? The science is actually quite firmly established.
There's a pseudo-scientific...
February 2, 2011 at 5:21 am
nandakrishnacherukuri (2/2/2011)
I got the answer with both the options . Is there any option other than Trigger,on update cascade
Trigger without on update cascade - write extra code in the trigger...
February 2, 2011 at 4:46 am
I am thoroughly confused, and must do some more reading.
Here's what MSDN Understanding Integration Services Package Configurations says:
In SQL Server 2008 Integration Services, package configurations are applied twice, before and...
February 2, 2011 at 4:24 am
In sql server management studio, in object explorer, find your job; click properties, click the steps page, click the step that contains the query, click edit. In job step...
February 1, 2011 at 3:42 pm
Viewing 15 posts - 6,241 through 6,255 (of 7,484 total)