This does not exist natively in SSMS 2005. It does exist in SSMS 2008 - but Microsoft has modified the latest version (RC0) to exclude the capability when accessing...

Sunil (6/20/2008)

---

Hello Guys,

I am working as a DBA in a MNC. Currently i need some help ....

I have very large production environment database so my server response is very slow...

Run a DBCC UPDATEUSAGE for those databases. Then look again.

No problem - glad I could help, at least with one part.

Manu - unless you have specifically allowed for this, COLUMN = NULL will not work. You always should check for nulls using IS [NOT] NULL syntax.

Jeff

Taking what GSquared gave you and adding to it - I think you want this:

CREATE PROCEDURE mr_test_input

@PostingDateF_in DateTime =...

The format is just what I gave you. In your query, replace the date column with:

,CONVERT(char(10), yourdatecolumnhere, 101) AS Request_Date

,CONVERT(char(8), yourdatecolumnhere, 108) AS Request_Time

Jeff

I don't understand how you want to use this as a security view - that is not clear. But, for the date questions, you can use CONVERT to return...

You perform backups of the DB's exactly the same way you would on a non clustered system.

rsheppick (6/20/2008)

---

SELECT Contact.Name, Contact.Phone, Contact.Email ,BundleList.Status as BundleStatus, ProductTypes.Producttype as ProductType,

ProductList.Status as ProductStatus, BundleType.Bundletype as BundleType, ProductList.Version

...

info (6/20/2008)

---

On the SQL propetis i all cpu are selected. I have set the sql server high priority checkbox. I have set teh value 0 to limitation of work threds...

Here is a select statement that will show how to get the information you are looking for. All you need to do is convert this into an UPDATE statement:

...

A single procedure will only use multiple processors when SQL Server believes a parallel plan will produce better results.

What did you set/change to tell SQL Server that multiple cores are...

I would recommend scheduling a time when you can grow your database files. You want to have at least 20% space available in the data file (not the combined...

Also make sure you are in fact running SQL Server Standard and not SQL Server Express (which would limit you to a single processor).

If your application uses a single connection...