Viewing 15 posts - 181 through 195 (of 337 total)
Lowell (8/12/2011)
One of the things I love about SQLServerCentral is that when you ask a...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 14, 2011 at 1:28 am
Just replace the IN clause with NOT IN clause.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 12, 2011 at 3:25 am
Check whether the TCP\IP protocol is enabled.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 12, 2011 at 1:52 am
See whether this helps
http://support.microsoft.com/kb/975752/en-us?sd=rss&spid=13165
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 12, 2011 at 1:24 am
Cannot think of a scenario where Resource database gets corrupted except when you are installing a service pack which errors out and corrupts the database
The best thing you can do...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 12, 2011 at 12:32 am
Thanks.
But I was thinking of a scenario where there are 10 users and all these 10 users have different set of permissions where in by no 2 users have the...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 12, 2011 at 12:12 am
Grant Fritchey (8/4/2011)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 4, 2011 at 6:07 am
ALZDBA (8/2/2011)
search ssc for "lost sa password". Those threads will get you started.e.g. http://www.sqlservercentral.com/Forums/Topic1054427-146-1.aspx
Unfortunately none of the posts on ssc were helpful.
One that helped was this
But somehow it works only...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 2, 2011 at 3:22 am
GilaMonster (8/2/2011)
Sachin Nandanwar (8/2/2011)
Try detaching and then attaching the database.
No. Please no. Worst thing possible.
Unless by some miraculous chance the database was cleanly shut it will not reattach. You should...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 2, 2011 at 3:18 am
Try detaching and then attaching the database.
Try the steps posted here
http://www.sqlservice.se/allmant/dont-panic-the-log-for-database-name_here-is-not-available/
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 2, 2011 at 12:15 am
Note sure how exactly your table structure & sample data looks like.Based on your description I have guessed the structure and expected output.
Declare @t table(Activities varchar(10),Labor varchar(10),Fabrication varchar(10),Transport varchar(10),Distribution varchar(10))
insert...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 5, 2011 at 7:32 am
Max memory settings controls only the max size of buffer pool(paged memory).
So in short the memory of 234752KB comes from 28 GB max setting.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 5, 2011 at 6:47 am
What does this return ? It will tell you why the log file is not shrinking .
select log_reuse_wait_desc
from sys.databases
where database_id = db_id()
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 29, 2011 at 3:14 am
Read this :-
http://www.mssqlcity.com/Articles/Adm/manage_users_permissions.htm
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 13, 2011 at 4:41 am
hi, sachin nandawar!!!
i'm sorry, the time that i stay without post!! I was having problems with my work!
with relation the book - SQL Server 2008 Internals, this link: http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243 you...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 12, 2011 at 1:31 am
Viewing 15 posts - 181 through 195 (of 337 total)