Viewing 15 posts - 721 through 735 (of 931 total)
amenjonathan (2/4/2011)
After a full or log backup, the transaction log will be emptied out, but the log size remains.
Please refer below links for good understanding of full backup and log...
February 4, 2011 at 10:13 am
lganglani (2/4/2011)
My roadblock is at point 3. I can map only one login at a time. I am not able to add logins A & B both to user Editors.
With...
February 4, 2011 at 6:08 am
balaji.ganga 68339 (2/3/2011)
I need to be restored the backup.. it shows the following error.
There is insufficient free space on disk volume
'D:\' to create the database. The database requires 9538633728...
February 4, 2011 at 5:45 am
Excellent question. I didn't want to take a chance before taking the question. To be sure, I referred to this link which gave me an idea to answer correctly.
February 3, 2011 at 11:56 pm
Rudy Panigas (2/3/2011)
mohammed moinudheen (2/3/2011)
The title of this article is really catchy.
Regarding this section: It's All Proactive
You are referring to a SQL Server instance which is running fine right?
I...
February 3, 2011 at 10:28 am
Hi Chris,
Thanks for clarifying and sharing that useful link.
February 3, 2011 at 3:24 am
Regarding getting row counts there was an article in SQL Server Central recentlly.
http://www.sqlservercentral.com/articles/T-SQL/67624/
On your question regarding access to view meta data, please refer below link. It has all the details.
From...
February 3, 2011 at 1:56 am
Rudy,
The title of this article is really catchy.
Regarding this section: It's All Proactive
You are referring to a SQL Server instance which is running fine right?
I am assuming you are...
February 3, 2011 at 1:07 am
I have faced this situation in SQL Server 2000.
Processes didn't show up in sp_who2 but showed up in sysprocesses. I eventually killed the processes in saw in
sysprocesses and...
February 2, 2011 at 11:38 pm
Thanks for the question. I was the first to take this today. 🙂 Got 2 points.
February 2, 2011 at 8:45 pm
Robert Davis (2/1/2011)
February 2, 2011 at 10:16 am
Try this link.
http://www.sql-server-performance.com/articles/per/Obtaining_Index_Usage_Information_p1.aspx
February 2, 2011 at 5:55 am
You can refer to the 2 links below which would help you to understand which system objects to query in msdb.
February 2, 2011 at 5:44 am
Viewing 15 posts - 721 through 735 (of 931 total)