Viewing 15 posts - 331 through 345 (of 860 total)
wannabe dba (4/3/2009)
Is it possible to have different database instances within the same SQL Server instance?If so will each dattabasehave a buffer pool of 1GB allocated to it?
That's right as...
April 4, 2009 at 11:56 am
waqarlaghari (4/3/2009)
any brother know that what is difference between Outer Join and Left Outer Join..
What is it that you didn't understand? Could you be more specific please?
I am waiting for...
April 4, 2009 at 11:49 am
john scott miller (4/3/2009)
Does it strike anyone as ironic that the sql server central sites search performace stinks so badly?
Nope not at all. It actually returns in less than 2...
April 4, 2009 at 11:42 am
Mike Levan (4/4/2009)
Is there any easy way to attach database files (more than 100) after dettaching it in the process of moving filed between the drives.
have you had a look...
April 4, 2009 at 11:38 am
randhirdadwal (4/3/2009)
.mdf and .ldf gets deleted. Services were stopped and .mdf and .ldf gets deleted.
True, if you want to delete the files the server/instance should be shut down. I...
April 4, 2009 at 6:57 am
randhirdadwal (4/3/2009)
Is it possible to keep tempdb on a separate disk?
Yes, technically you should place tempdb on its own disk without mixing up with the OS files.
You should also create...
April 4, 2009 at 6:47 am
Glad it's resolved even though I wasn't able to help you much. thanks for sharing with us.
April 4, 2009 at 6:22 am
If you want to return all the databases in 2005 query sys.databases view.
Change the compatibility mode to 90.
April 3, 2009 at 6:55 pm
What permissions does the user have and why did you put TRUSTWORTHY ON, any specific reason behind that?
From BOL:
Because a database that is attached to an instance of SQL Server...
April 3, 2009 at 2:06 pm
sturner (4/3/2009)
April 3, 2009 at 1:44 pm
arun.sas (3/28/2009)
i have the following error
Server: Msg 2514, Level 16, State 1, Line 1
Table error: Data type 987 (type '987') does not match between 'SYSCOLUMNS' and 'SYSTYPES'.
Server: Msg 2514, Level...
April 3, 2009 at 1:30 pm
On top of these sugggestions, I would like to add.
If many worker threads are at Runnable state it means that there is a bottleneck on CPU. Use this query to...
April 3, 2009 at 7:10 am
CH&HU (3/4/2009)
it is Express edition.Think it is disabled for Express Edition.
No Express editions doesn,t add SQL Agent, you wouldn't be able to run it. If you want to schedule the...
April 3, 2009 at 6:57 am
-- Cranfield (4/3/2009)
turns out a data load kicked in while I was BCPing OUT so the BCP waited for that to finish. Never knew BCP was...
April 3, 2009 at 6:52 am
shivaram challa (4/2/2009)
April 3, 2009 at 6:49 am
Viewing 15 posts - 331 through 345 (of 860 total)