Viewing 15 posts - 4,066 through 4,080 (of 7,168 total)
RBarryYoung (5/14/2012)
opc.three (5/14/2012)
RBarryYoung (5/14/2012)
May 14, 2012 at 1:43 pm
RBarryYoung (5/14/2012)
Jeff Moden (5/13/2012)
You can also do this by right-clicking on the database, selecting "properties", and then follow your nose.
Really??? Jeff, I must be dense, because the initial "Owner"...
May 14, 2012 at 1:39 pm
RBarryYoung (5/14/2012)
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?
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...
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...
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...
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...
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....
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...
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...
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....
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...
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...
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...
May 12, 2012 at 3:59 pm
Viewing 15 posts - 4,066 through 4,080 (of 7,168 total)