Viewing 15 posts - 6,451 through 6,465 (of 6,678 total)
If you create a schema called 'db', then create a synonym for a table in your other database as:
CREATE SYNONYM db.Test FOR linkedserver.Database.dbo.Test;
You can then query it using:
SELECT * FROM...
June 21, 2008 at 3:51 pm
Another thing you can do, and should do is:
ALTER DATABASE SET PAGE_VERIFY CHECKSUM;
Then, include the checksum option in your backups:
BACKUP DATABASE ... WITH CHECKSUM;
Not only with the backup create a...
June 21, 2008 at 1:31 pm
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,...
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...
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...
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...
June 20, 2008 at 9:14 pm
Run a DBCC UPDATEUSAGE for those databases. Then look again.
June 20, 2008 at 4:56 pm
No problem - glad I could help, at least with one part.
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
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 =...
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
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...
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.
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
...
June 20, 2008 at 12:59 pm
info (6/20/2008)
June 20, 2008 at 12:02 pm
Viewing 15 posts - 6,451 through 6,465 (of 6,678 total)