Viewing 15 posts - 1,306 through 1,320 (of 2,463 total)
Sharon Kumar (9/18/2010)
please provide me trouble shooting steps,please help me out on this issue..
thanks
we can spend years on this topic. So refer this article it will give you...
September 20, 2010 at 4:56 am
lallu_jaya (9/20/2010)
Do you suggest Covered index on all the following columns?
Do we have covering index in sql 2000 ? :unsure:
September 20, 2010 at 4:53 am
Pankaj,
Refer below link, you will get better idea about this http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/c7c55964-eb9a-4fa2-829c-f75e8a455189
September 20, 2010 at 4:42 am
Tara-1044200 (9/17/2010)
i am using DENY INSERT,UPDATE which requires either sysadmin or security admin role on the server.
INSERT/UPDATE in stored proc ??? confusing stuff for me :unsure:. my...
September 20, 2010 at 4:22 am
pankaj.kuchaliya (9/20/2010)
I fire the query "select * from sys.dm_db_missing_index_details " , i see there are lots of indexes.
You should not blinding trust this information. this is not helpful or...
September 20, 2010 at 4:08 am
Jeff Moden (9/19/2010)
Bhuvnesh (9/19/2010)
WayneS (9/17/2010)
Select top 5 'MY DATABASE TABLE: ' = name
from sysobjects
where xtype = 'u'
order by...
September 19, 2010 at 11:24 pm
WayneS (9/17/2010)
Probably not what you're looking for, but how's this?
Select top 5 'MY DATABASE TABLE: ' = namefrom sysobjects
where xtype = 'u'
order by 1 desc
Thanks wayne...
September 19, 2010 at 10:46 pm
JF1081 (9/16/2010)
I want to do is simply back it up to a local drive and overwrite it on a nightly basis.
instead take backup with datetime suffix and delete the old...
September 17, 2010 at 1:45 am
CirquedeSQLeil (9/16/2010)
Another option is to use SSIS and kick off the job through SSIS - use connection managers for each different server and kick off the jobs from there.
Where...
September 17, 2010 at 1:40 am
See declare @t table ( id int )
insert into @t
select 1
union
select 2
union
select null
select *, isnull(id, '') as new from @t
September 17, 2010 at 1:37 am
laddu4700 (9/16/2010)
I am getting empty space by using below query. Please correct me if I am wrong.
USE MYDB;
GO
select UserName, ISNULL(NULL, '') AS 'UserID'
FROM...
September 17, 2010 at 1:35 am
if you are using same drive for all database ( tempdb also ) then you can do some shrinking on other DBs (like tempdb), for the time being it will...
September 16, 2010 at 3:49 am
GilaMonster (9/16/2010)
Bhuvnesh (9/15/2010)
GilaMonster (9/13/2010)
Defrag only works on the leaf level of the index (level 0) .
Then what about the intermediate level ?
Defrag (Alter index Reorganise) does not touch anything other...
September 16, 2010 at 1:30 am
Derrick Smith (9/15/2010)
the only time it's not relevant is on a heap table.
is thats the case with Heap table then i got your point...thanks
September 15, 2010 at 10:30 pm
Derrick Smith (9/15/2010)
Bhuvnesh (9/15/2010)
Derrick Smith (9/15/2010)
It shows that the indexes are not fragmented.I am sorry , but which value showed it ?
Well DBCC SHOWCONTIG isn't really the best tool...
September 15, 2010 at 10:03 pm
Viewing 15 posts - 1,306 through 1,320 (of 2,463 total)