Viewing 15 posts - 4,066 through 4,080 (of 7,164 total)
RBarryYoung (5/14/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 1:29 pm
Ooof, I suspect that will be awfully slow when applied to a non-trivial amount of data. Have you tested it on a table with more than a few thousand rows?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 1:17 pm
Eric M Russell (5/14/2012)
rafael_si (5/14/2012)
Hello Eric,Since my business key do not duplicate, the identity column is not necessary, is it?
No, it's not necessary. Having LoadDateTime + ID would just...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 1:13 pm
durring the server trace i could not find any differences in the T-SQL being executed between the create database script vs SSMS Create DB Wizard.
Thank goodness. I think that was...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 1:06 pm
WebTechie38 (5/14/2012)
1) How do you break out of a foreach loop container?
The Foreach Loop Container handles that for us. It breaks when you reach the end of whatever collection...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 12:56 pm
What exactly are you trying to accomplish by having a procedure generate code so you can execute it on the same server? In your example all your servers are the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 12:45 pm
Eric Mamet (5/13/2012)
Ddi someone get fired after designing this?Just kidding! 😀
Thanks for the info
It's a pretty common pattern going back a long ways. ODBC uses "ordinal parameters" as well....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 12:05 pm
bitbucket-25253 (5/14/2012)
opc.three (5/14/2012)
bitbucket-25253 (5/12/2012)
opc.three (5/11/2012)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 11:43 am
SQLDBA360 (5/14/2012)
you can also use sp_changedbowner but remember to 'use database_name' first!
sp_changedbowner is deprecated
The recommendation is to use ALTER AUTHORIZATION in T-SQL code although the SSMS team does not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 11:13 am
bitbucket-25253 (5/12/2012)
opc.three (5/11/2012)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run some tests....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 9:50 am
pradeep.mohan (5/13/2012)
In control tab in BIDS i used only 3 Execute SQL task (Insert,update,delete) based on that DML operations happening to destination table.(Without using Data flow task)
The Execute SQL Task...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 9:41 am
capn.hector (5/14/2012)
opc.three (5/11/2012)
capn.hector (5/11/2012)
opc.three (5/11/2012)
Could be. I did not think SHRINKFILE was sunject to the 'initial size' issue though.
i believe only when used with CREATE DATABASE. all the DB's...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 14, 2012 at 9:31 am
injungchang (5/11/2012)
Thanks, currently I implemented extended events. But, i'd like to see I can use SQL 2008R2 audit feature that is available in enterprise edition.
I will recommend using EE in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 12, 2012 at 3:59 pm
riya_dave (5/12/2012)
opc.three.i dotn except any answer from you.so dont bother even to see my thread
riya_dave, please accept my apology. I have obviously said something that you did not appreciate, and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 12, 2012 at 3:36 pm
Thank you for the vote of trust. Unlike the author(s?) of the CLR String Splitter, who no doubt spent a non-trivial amount of time developing, testing and tuning their object,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 12, 2012 at 3:26 pm
Viewing 15 posts - 4,066 through 4,080 (of 7,164 total)