Tejesh (2/2/2015)

---

hi all,

i am an oracle dba but recently my manager gave me about 100 excel files which have lakhs of data about clients and this data may add upto...

A little internet searching turns up good resources for your question. Here are some places to check.I list Aaron's website because I remembered seeing posts from him that discuss...

Andre,

You could give each agency their own database on one SQL Instance. I believe that your web app could use an Application Role inside each database to sign on....

lmarkum (2/2/2015)

---

SmilingLily (2/2/2015)

---

Hi Imarkum - Thank you for the reply. I appreciate it. I tried setting it up and

I had below errors

Make sure Agent Service for 'MasteServerName' Is running

Access...

SmilingLily (2/2/2015)

---

Hi Imarkum - Thank you for the reply. I appreciate it. I tried setting it up and

I had below errors

Make sure Agent Service for 'MasteServerName' Is running

Access Denied...

Beyond the excellent suggestions already provided, you might investigate having some tools on hand to run at a moments notice to discover what is happening on your server. Once...

I like what Michael has said. I would add that it might be good to go over to sqlskills.com and search the blogs there for transaction log maintenance. ...

rkrpat (1/31/2015)

---

Hi All,

I would like to know is it a good practice to have a SQL Server Agent Job for each database with below Steps

1. DBCC Checkdb

2. SP_Updatestats

3. Backup_Database_full

4....

I am not sure that your query actually shows a problem with TempDB. If you want to use wait stats to troubleshoot SQL Server I would start by reading...

If you have the Enterprise Edition on this site and it is alt least SQL Server 2008, then you could configure the Resource Governor to assist with the situation. ...

SmilingLily (1/30/2015)

---

I am using SqlServer 2008.

I have a Sql Server Job that checks Disk Space and emails admins if the space is less than 15%

Instead of adding that Job to...

I would not advise to bring them all down and patch them and then bring them back up. A big reason to do a rolling patch process is to...

What I am seeing online is the suggestion that maybe you need to make the query timeout value larger in the agent profile. This plays into the next question...

Joy Smith San (1/29/2015)

---

Hi,

We have a SQL Server 2008 installed on one server. It has 2 CPUs and 8 GB Ram (6 GB allocated to SQL)

DBs are small and is...

I can't speak to the subscription status issue but the below link is from the Microsoft REPLTalk blog. see option 2. I found this by doing an internet...