dpt,

I have suggestion to run the performance dash board and find the missing indexes create all the missing indexes and test it in ur testing envorinment.

If it's good go ahead.

sivark1 (12/15/2009)

---

Thanks for your valuble sugessions to all,

During the search in this forum i found one of the solution (Tsql script to move the (x no.of) all ...

Did u see the posted link?

Hi...

go google:-P

jagadeesanpv (12/14/2009)

---

Hi Experts,

I have recently installed Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) on Windows Server 2008

I am getting the following SQL log frequently

Setting database option COMPATIBILITY_LEVEL...

Hi,

See The Discussion

Then why u r posting in 2005 forum.

--Please post the 2000 related question in 2000 forum

Hi,

How u r rebuild the indexes through maintenance plan ?

How to verify that an index has been rebuilt. Is there any updated time so that we can come know...

Hi,

Please can u send me the actual execution plan

the "select into" selects from tables in one database into tables in another database. Did something change in SQL 2008 that would...

haichells (12/11/2009)

---

Hi,

I am trying to execute some script in a list of dbs. i wrote a generic script to change the db which is not working. Please find below the...

Hi ,

Look the MS Article about tail of log backup

Also read the gail's article

Managing Transaction Logs[/url]

Edited:Post the correct URL

DECLARE @cmdstr varchar(200)

Declare @path varchar (100)

set @path = 'D:\ppc_auctions.txt'

SET @cmdstr = 'bcp "select sku,auction_type_id from auctions where status_id = 2" queryout ' + @path + ' -t"," -c -T'

print @cmdstr

EXEC...

Hi,

Try the following example

DECLARE @cmdstr varchar(100)

SET @cmdstr = 'bcp "select name,id from sys.sysobjects where id >200" queryout "D:\ppc_auctions.txt" -t"," -c -T'

print @cmdstr

EXEC master..xp_cmdshell @CMDstr

--Don't break the select statement (Write in...

sp_updatestats and dbcc updateusage

They are completely unrelated and do totally different things.

sp_updatestats runs a statistics update (using UPDATE STATISTICS) across all the statistics in the database where the underlying table...