You can for SQL Server to use a particular index by using 'Index Hints'

For e.g. Select * from Tab_Name WITH (INDEX(Index_lala))

WHERE ColName = 'yoyo'

Sql server might not be using Index...

bkana (5/1/2009)

---

Hello ,

I have to remove certain data from fields in a column called "ExpirationDate" I need to "empty out" the fields that have '12/31/2008' in the field.

There are...

bkana (5/1/2009)

---

Thanks Mayank,

That worked on my test view, going to run a backup and run it against my working view. While I run the backup could you explain a little...

See if the below works to get all the dates that you are looking for.

select * from ContactsTest where substring(cast(ExpirationDate as varchar),1,11) = 'Dec 31 2008'

If yes then, you...

Hello "INFO01", I was following this post and was curious how things r going with ur corrupted Database. Thanks

Hey Gail,

What client tool r u using to run ur Oracle create scripts? SQL Plus work sheet, Toad or SQL scratch Pad. I just ran ur scripts in SQL Plus...

Use the below to get -1

ALTER PROCEDURE [dbo].[InnerSproc]

AS

BEGIN

RAISERROR ('ErrorMessage', 12, 12)

END

Not all errors are trapped by TR/CATCH block. Like compile errors(Syntax errors), Process terminated by KILL command, broken client...

The below article takes u step by step towards moving data to a different file group and answers your question about how your data will start moving to new file...

If there are too many changes in those tables then may be u can consider having fill factor of 75 to 80, any number that best suites ur purpose.

moramoga (4/27/2009)

---

Mayank Khatri (4/27/2009)

---

Run Below:

SELECT p.name, SUM(s.cost) AS Software, SUM(cast(isnull(m.cost,0)as int)) AS Material,

SUM(t.cost) AS Travel, SUM(h.cost) AS Hardware

FROM THardware AS h

LEFT OUTER JOIN TProject ...

Run Below:

SELECT p.name, SUM(s.cost) AS Software, SUM(cast(isnull(m.cost,0)as int)) AS Material,

SUM(t.cost) AS Travel, SUM(h.cost) AS Hardware

FROM THardware AS h

LEFT OUTER JOIN TProject AS p ON...

Yes

Excuse me for not understanding the problem correctly, if thats the case then why is that u cant just checks the job and which S.P is being executed bu the...

Do u mean All S.P. scheduled to run in ur SQL Server agent?

How big is ur database? If u have taken full backups of this database, did u take on same drive? The reason I am asking is I had the same...