Viewing 15 posts - 5,341 through 5,355 (of 7,164 total)
Gianluca Sartori (7/27/2011)
Model is the template for a new database, so, if you don't like it in full recovery, change it to simple recovery.No harm: it's your choice.
+1
I do...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 12:22 pm
Ninja's_RGR'us (7/27/2011)
Sqlsavy (7/27/2011)
Microsoft is looking into the issue nowOk, keep us posted. I'd love to hear a happy ending on this one, even if there's little hope left ;-).
Me...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 12:19 pm
dan.forest (7/27/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 12:02 pm
Elliott Whitlow (7/27/2011)
opc.three (7/27/2011)
Even if clients were using different server...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 11:53 am
David Benoit (7/12/2011)
Let me know if you have any problems with the article drop....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 11:37 am
dan.forest (7/27/2011)
I did set up an Alias that specified the individual IP address on port 1433, turned off named pipes on the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 10:51 am
Elliott Whitlow (7/27/2011)
If you mean, how am I connecting, for the oSQL test here's my connection string:
osql -S dbserver\dbinstance -U sql_user -P xxxxxxxxx
Given your config I really can't see...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 10:49 am
That said regarding aliases...it would be a heck of a lot of work to do all this resolution on the client. You may be able to push aliases to clients...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 10:22 am
dan.forest (7/26/2011)
Yes, but using aliases doesn't resolve the issue with all instances needing to listen on the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 10:14 am
Have a look at the attachment. It contains two packages.
capture_float_as_double.dtsx:
Shows how to do the type conversion in SQL on the way out. I am stumped as to why this...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 10:04 am
Another option is to capture the result into a string in SSIS and then setup User::dUserVariable as an expression that will convert your string variable to a double.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 9:45 am
Understood. What is the base type of the T-SQL UDT?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 9:44 am
ringovski (7/26/2011)
Maybe I have to convert them all to strings?
NULL is the universal marker for "undefined" for all data types. Empty string is only valid for character types so the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 9:40 am
What did you mean by this?
Unfortunately, this user variable comes from a 3rd party and in order to get it to work, it has to be a DOUBLE.
Can you post...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 9:32 am
I was hoping to see the plans when run against your live data 🙂
I went ahead and mocked up 1MM rows of test data and your query 1 performs worse...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 27, 2011 at 9:26 am
Viewing 15 posts - 5,341 through 5,355 (of 7,164 total)