Viewing 15 posts - 6,451 through 6,465 (of 6,676 total)
The only way I know of to check this for data files is to use the analyze feature of defrag. With a 30GB data file grown in 10MB chunks,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2008 at 9:04 am
No, you don't need to cycle SQL Server.
Ellis, when you perform an upgrade from SQL Server 2000 to 2005, and there are custom objects in the master database - the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2008 at 8:52 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2008 at 8:50 am
Sunil (6/20/2008)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 9:14 pm
Run a DBCC UPDATEUSAGE for those databases. Then look again.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 4:56 pm
No problem - glad I could help, at least with one part.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 4:54 pm
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
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 1:53 pm
Taking what GSquared gave you and adding to it - I think you want this:
CREATE PROCEDURE mr_test_input
@PostingDateF_in DateTime =...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 1:50 pm
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
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 1:33 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 1:09 pm
You perform backups of the DB's exactly the same way you would on a non clustered system.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 1:02 pm
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
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 12:59 pm
info (6/20/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 12:02 pm
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:
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 11:55 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2008 at 11:26 am
Viewing 15 posts - 6,451 through 6,465 (of 6,676 total)