Viewing 15 posts - 35,851 through 35,865 (of 49,558 total)
SQLNewbster (11/13/2009)
Just so you guys don't go too far off track, I am working in a SQL 2k5 environment, not 2k...
Then why did you post in a SQL 2000 forum?
November 13, 2009 at 1:47 pm
To add to that, object_id is an int, not an nchar(100). You're wasting nearly 200 bytes of space per row with that. (4 bytes vs 200)
November 13, 2009 at 1:04 pm
Jeff Moden (11/13/2009)
Gail, since this is 2k, do you think a partitioned view would help at all here? Or would it just muck things up?
Haven't worked much with them,...
November 13, 2009 at 12:49 pm
John Paul-702936 (11/13/2009)
can you please tell How can i use Forcing index ...
Look up table hints in SQL's Books Online.
Sure you want to do that? Are you 100% certain...
November 13, 2009 at 10:23 am
Then we are going to have to agree to disagree on this. I understand your approach and I've used it before but in general I prefer the one that I...
November 13, 2009 at 10:11 am
CirquedeSQLeil (11/13/2009)
Option 2:
Select OBJECT_NAME(object_id) as TableName,SUM(rows) as NumRows,index_id
From sys.partitions p
Inner Join sys.sysobjects o
on p.object_id = o.id
Where index_id in (0,1)
And o.type = 'U'
Group By object_id,index_id
Order By NumRows Desc
Don't use sysobjects. It's...
November 13, 2009 at 10:10 am
How did you restore? Please post the exact script that you used. Check the SQL error log. Post all errors relating to that DB.
November 13, 2009 at 10:08 am
In SQL 2005 and above, the row count information is in sys.partitions. Filter on index_id IN (0,1) and sum the row count by object id. You have to sum because...
November 13, 2009 at 10:06 am
First things first. Replace those drives (or at least get the DB elsewhere). Playing around on drives that are known to have had problems before is just asking for trouble.
Best...
November 13, 2009 at 10:03 am
It is very hard to max out a modern multi-proc server. Generally, if the queries are well written, disk or memory bottlenecks are hit well before the CPU and so...
November 13, 2009 at 9:46 am
OLDCHAPPY (11/13/2009)
nice article - yours?
Yup. My blog
No backup becasue it's a test server.
Doesn't mean it shouldn't be backed up. Personal opinion: If you can't recreate a DB completely...
November 13, 2009 at 6:58 am
Why no backup?
See this post for a way to hack the database back into the server and get things working. http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/. Don't delete the transaction log, just use the hack...
November 13, 2009 at 5:16 am
Please start a new thread for a new question in future.
There's some connection to the DB that you're trying to restore. Not necessarily yours, but there is one. If you're...
November 13, 2009 at 5:13 am
Danspojken (11/13/2009)
But I want the index to treat these two columns as one...
Why?
If you want to do that, create a calculated column in the table, persist the column and...
November 13, 2009 at 5:12 am
Viewing 15 posts - 35,851 through 35,865 (of 49,558 total)