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...
M&M
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...
M&M
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...
M&M
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.
M&M
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...
M&M
February 3, 2011 at 10:28 am
Hi Chris,
Thanks for clarifying and sharing that useful link.
M&M
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...
M&M
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...
M&M
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...
M&M
February 2, 2011 at 11:38 pm
Thanks for the question. I was the first to take this today. 🙂 Got 2 points.
M&M
February 2, 2011 at 8:45 pm
Robert Davis (2/1/2011)
M&M
February 2, 2011 at 10:16 am
Try this link.
http://www.sql-server-performance.com/articles/per/Obtaining_Index_Usage_Information_p1.aspx
M&M
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.
http://www.mssqltips.com/tip.asp?tip=1724
http://www.mssqltips.com/tip.asp?tip=1860
M&M
February 2, 2011 at 5:44 am
Viewing 15 posts - 721 through 735 (of 931 total)