Viewing 15 posts - 38,236 through 38,250 (of 49,571 total)
Query sysindexes and see if these are statistics or indexes
select OBJECT_NAME(id), name, CASE INDEXPROPERTY(id, name, 'IsStatistics') WHEN 1 THEN 'Statistics' WHEN 0 THEN 'Index' END as Type
from sysindexes
WHERE id =...
June 24, 2009 at 1:39 am
neerav.saini (6/24/2009)
ON internet i was able to trace information regarding number instance and sizing except attribute listCAN ANYONE SEND ME LINK OR POST LINK TO GET ATTRIBUTE
What attribute? I don't...
June 24, 2009 at 1:27 am
Please post in the appropriate forum in future. The article discussion forums are for discussion of published articles.
Other than looking at the tables, relationships, stored procs (if any) and any...
June 24, 2009 at 1:24 am
What does this return?
select name, type_desc from sys.indexes where name = 'PK__Employees__1D4655FB'
If it does return nonclustered, then to make it a clustered index you'll have to drop the primary key...
June 24, 2009 at 1:19 am
Along the lines of that rather strange comment on SimpleTalk a week or so back (asking for BioTech books iirc), I thought this might provide a few laughs.
June 24, 2009 at 12:58 am
Google for stored procedure decryption for SQL 2005. There are several tools, maybe one or two free, most are not free.
June 24, 2009 at 12:47 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic740742-146-1.aspx
June 24, 2009 at 12:44 am
Do you have an earlier backup that is usable?
You've got an irreparable error there. There is no way to fix that. You have only two options. Restore a clean backup...
June 24, 2009 at 12:43 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic740627-338-1.aspx
June 23, 2009 at 4:15 pm
Florian Reischl (6/23/2009)
@roy: You just have to come to Germany.
How far are you from Berlin? There's a very, very, very, very small chance that I may be in that area...
June 23, 2009 at 3:38 pm
Just make sure that you rebuild your indexes afterwards.
See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
June 23, 2009 at 3:32 pm
will (6/23/2009)
June 23, 2009 at 3:19 pm
Florian Reischl (6/23/2009)
GilaMonster (6/23/2009)
He offered $5.:laugh:!
Did you answer this?
I replied with my actual hourly rate (which seems lot to US people because of the exchange rate). Never heard back.
June 23, 2009 at 3:07 pm
No.
Leave them the size they are now. Monitor using DBCC SQLPERF(LogSpace) and you'll be able to see file size and space used. Keep an eye on that and see...
June 23, 2009 at 3:02 pm
WayneS (6/23/2009)
Well, I let him know a solution is available, but... well, see for yourself... http://www.sqlservercentral.com/Forums/FindPost740549.aspx
LoL.
I had a guy contact me via PM a while back about a procedure (apparently...
June 23, 2009 at 2:54 pm
Viewing 15 posts - 38,236 through 38,250 (of 49,571 total)