Viewing 15 posts - 2,086 through 2,100 (of 2,462 total)
GilaMonster (3/12/2010)
use IN or a lookup table to get matches.
Can you please send me sample query
and why i am gettign key lookup ? , i have made covering index...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 12:47 am
Use Sp_who2 and sp_lock to find out spid which are creating problems
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 7:53 am
Melton (3/10/2010)
http://www.brentozar.com/sql-server-training-videos/t-sql-performance-tuning-for-race-car-drivers/%5B/url%5D
nice video
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 6:44 am
yusufanis (3/11/2010)
Any handy script that you can refer to check sequence of pages which are free & used?
Why you require this ?
but if you want to see how indexes...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 4:52 am
Post your table/index defintions
and also see link below my signature to get faster response on your posts/queries.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 4:30 am
winslet (3/11/2010)
Recommended is 2GB must for OS.
on what basis, you say so ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 4:11 am
dbcc sqlperf(logspace)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 3:29 am
With Static memory allocation once the maximum amount of memory allocated to SQL Server is reached it will never release the memory. Even if another process needs it. If there...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 3:09 am
if possible restart sql server.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2010 at 12:53 am
bjorn.hilde (3/10/2010)
I still need to restart the sql services to let sql server update it's cache.
your are peroidically restarting the services ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 10:45 pm
sharon.bender (3/10/2010)
Bhuvnesh, I'm not sure what your code is trying to achieve, but it doesn't seem to have anything to do with the info I am trying to get.
then post...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 10:43 pm
bjorn.hilde (3/8/2010)
The problem is that after renaming a user SYSTEM_USER still returns the old name. It will give the new (proper) name after restarting the sql-service.
Is this problem get...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 7:39 am
try this approach on serverA mgmt studio
INSERT INTO [serverB].dbname.dbo.serverB_table(object_text,created_date)
SELECT cast(object_text as nvarchar(MAX) ),created_date FROM dbname.dbo.serverA_table
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 7:29 am
this is the approach , you can take
use [TestDB]
GO
GRANT SELECT ON [dbo].tablename TO [loginname]
GO
use [TestDB]
GO
GRANT UPDATE ON [dbo].tablename TO [loginname]
GO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 7:24 am
subbarayudu.net 37258 (3/10/2010)
Any one idea about snap shot and sparse files, please come to this discussion RegardsSubbarayudu
see of it helps you
http://www.sqlservercentral.com/Forums/Topic489120-149-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 7:13 am
Viewing 15 posts - 2,086 through 2,100 (of 2,462 total)