Viewing 15 posts - 1,306 through 1,320 (of 2,462 total)
lallu_jaya (9/20/2010)
Do you suggest Covered index on all the following columns?
Do we have covering index in sql 2000 ? :unsure:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 15, 2010 at 10:03 pm
Derrick Smith (9/15/2010)
It shows that the indexes are not fragmented.
I am sorry , but which value showed it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 15, 2010 at 9:33 pm
Viewing 15 posts - 1,306 through 1,320 (of 2,462 total)