Viewing 15 posts - 1,261 through 1,275 (of 5,103 total)
isa (6/3/2008)
application, it gives me error, when i opend the...
June 3, 2008 at 8:57 am
Konrad Kubiak (6/3/2008)
is it possible to use mulitple pivot (to aggregate many columns) over the same header column?
I mean sth like:
PIVOT ( Sum(MaxCapacity) FOR Actual1 IN ( [0] ,[1] )...
June 3, 2008 at 8:55 am
You should explore the "ACCESS PROJECT" option ... is very customized to use this kind of things.
June 3, 2008 at 8:49 am
Rog Saber (6/3/2008)
June 3, 2008 at 8:43 am
timothy.merridew (6/3/2008)
For Kerberos and SPN to work, I'd need to change the SQL server from Local System to a domain account wouldn't I?
Yes!
June 3, 2008 at 8:37 am
There was this time in my early DBA days that I swore by the the % on the exec plans ... I then modified a very complex set of queries...
June 3, 2008 at 8:25 am
It goes like this:
Exec dbo.sp_dropsubscription @publication='publication_name', @article='object_to_drop', @subscriber='SUBSCRIBER_SERVER_NAME'
Exec dbo.sp_droparticle @publication='publication_name', @article='object_to_drop',
@force_invalidate_snapshot=1
Exec dbo.sp_refreshsubscriptions 'publication_name'
June 2, 2008 at 3:47 pm
65 .... wow... if it is not a record it must be really close 😀
June 2, 2008 at 3:41 pm
garyreeds (6/2/2008)
hi,I know the db_id=4 n object_id=373576369,index_id=0 which has 96.83% avg_fragmentation_in_percent. So I want to know in which table on which columnname this fragmentation exist
Thanks
Index_id = 0 implies a HEAP...
June 2, 2008 at 9:58 am
June 2, 2008 at 9:30 am
You should consider the use of SYNONYMS of your 'code' DB in your 'data' DBs.
June 2, 2008 at 9:28 am
Those trace flags are definitely undocumented and a google search reveal that they are used for capturing "sql dump info". You should use one of the ones I posted.
June 2, 2008 at 9:24 am
Replication normally does NOTworks with ALIASES for named pull subscriptions.
You must use anonymous subscribers or Push subscription.
June 2, 2008 at 8:57 am
The main problem with those percentages come up fairly frequent when UDFs are used.... be really careful. But I do agree that it is a good "starting" point.
June 2, 2008 at 8:47 am
Viewing 15 posts - 1,261 through 1,275 (of 5,103 total)