Viewing 15 posts - 7,081 through 7,095 (of 7,608 total)
ocolakoglu (2/8/2011)
HiWhen i use change data capture can i log hostname,username information?
You can use any columns from the original table you want ... but that's it.
So to capture that...
November 19, 2012 at 3:23 pm
fluffydeadangel (11/19/2012)
my simple goal is to create a two part job that will reindex only the items that need it ...
select 'ALTER INDEX ALL ON dbo.' ... 'FILLFACTOR = 80'...
November 19, 2012 at 3:20 pm
Other than the final ORDER BY, I think the query below will do it.
Personally, I wouldn't rewrite your existing query any more than you have to to make it do...
November 19, 2012 at 3:06 pm
I too think nested REPLACEs would probably be fastest.
You could do a simple function, but I'm not sure that would perform as well, let alone better ... but, really, with...
November 16, 2012 at 5:21 pm
No, normally you never change an identity/key value in a warehouse once it's been assigned. I can't imagine anything that would require that to be done, so it's very...
November 16, 2012 at 4:59 pm
No, normally you never change an identity/key value in a warehouse once it's been assigned. I can't imagine what would require that to be done.
November 16, 2012 at 4:58 pm
The TRY block will be fully parsed and begin execution before the CATCH block is processed, so, yes, all variables in the TRY block will be made available to the...
November 16, 2012 at 4:55 pm
Bobby Glover (11/9/2012)
November 9, 2012 at 2:35 pm
To be safe, you probably want to add the length of the clustering key to the column to be ALTERed.
So, for example, if the clus key is 4...
November 9, 2012 at 1:03 pm
ScottPletcher (11/8/2012)
AndrewSQLDBA (11/8/2012)
I just saw some of the data as only 3 digits. So 499 would need to be converted to 499.00 etc.....
There may also be...
November 9, 2012 at 8:44 am
Hmm, it's not clear to me what "fields" 2 and 3 contain, so I'll assume field2 has the "4Q" and field3 has "12".
Just in case field1 is indexed, or it...
November 8, 2012 at 5:19 pm
AndrewSQLDBA (11/8/2012)
I just saw some of the data as only 3 digits. So 499 would need to be converted to 499.00 etc.....
There may also be a...
November 8, 2012 at 5:07 pm
It depends. Often it's faster just to keep the desired rows rather than delete all the undesired. That is, copy the good rows to another table, trunc the...
November 8, 2012 at 5:01 pm
There could definitely be some lag.
You can issue DBCC UPDATEUSAGE to force the row count to be updated before you use it.
November 8, 2012 at 4:54 pm
You're not changing the physical length of the column, so it shouldn't be too bad.
My guess is that logging the change is taking the time.
Try it again in test but...
November 8, 2012 at 4:52 pm
Viewing 15 posts - 7,081 through 7,095 (of 7,608 total)