Grant Fritchey (3/6/2014)

---

But......

Do SSMS, .net application and VB application are on the same server or on...

Do you do Index Rebuilds and Update Stats in Production ?

--

SQLBuddy

Yeah do SELECT @@VERSION and look in http://sqlserverbuilds.blogspot.com/. Just check if you build that is before the RTM.

--

SQLBuddy

This will be sequential. However you can start them parallely using...

Or just run sp_updatestats to update the stats.

And check for any Blocking, Memory, CPU, Disk utilization on the server. Also check for any waits on the server.

--

SQLBuddy

Windows Logins abide by the login policies of the underlying Operating System. In SQL Server 2005 and later, SQL Server logins can also adhere to the windows login policies if...

sqlbuddy123 (3/6/2014)

---

It doesn't really have anything to do with the number of DBa's. It has to do with the self-sufficiency of the one(s) you already have on staff, and it...

It doesn't really have anything to do with the number of DBa's. It has to do with the self-sufficiency of the one(s) you already have on staff, and it is...

FIshNChipPapers (3/6/2014)

---

Currently there is not an instance to upgrade to SP1; we have to deploy a new database from an SP1 instance from another server so we would be looking...

paulaalkz 9229 (3/5/2014)

---

Hello ! I understand that isolating services reduces the risk that one compromised service can be used to compromise others.

How about when you manage multiple sql servers?...

May be the SP is getting recompiled. Please also capture the execution plan and check it. If you can post it it would be very helpful.

--

SQLBuddy

What's the type of mirroring between A & B ?

--

SQLBuddy

TravisDBA (3/6/2014)

---

As far as work ethic goes, what is the most important work ethic in a DBA? For me, it is self-sufficiency. Nothing is more frustrating than a DBA that...

Try this ..

http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/

--

SQLBuddy