sql_jr (12/13/2011)

---

Hi, I have a query I need to optimize. I already added a bunch of relevant indexes, and reduced it from 22 mins to 18 - but...

pallavi.unde (12/13/2011)

---

as per your guidance i m trying to create a view but it give error

script is

create view trialbase as

select distinct count (a.collegeid)as becount,d.name,a.StreamGroupId,b.DegreeId,b.DegreeName,c.CourseName

from college_degreestreamtransition a inner join college_degreemaster b...

okbangas (12/13/2011)

---

In my humble opinion, the only option here is to have the Witness Server on a third host. No matter what server you have the witness running on, if...

Jeff Moden (12/12/2011)

---

Option 4... provided that it ISN'T a production server, learn from your mistakes... let DTA rip and discover the problems it causes. "A Developer must not guess......

hmmm... I learnt something new today. People use CDC & Change Tracking synonymously & I was doing the same. Thanks to both of you to bring this discussion here.

Granting permissions is easy if you understand how it works.

NO user will have any access (except public)...

Please watch your steps...

Custom extensions were detected on the report server

http://msdn.microsoft.com/en-us/library/ee240802.aspx

Your checklist is now mine 😀

It’s right time for planning a database upgrade 😉

Another One.. 😉 Introduction to Backup and Restore Strategies in SQL Server

http://msdn.microsoft.com/en-us/library/ms191239.aspx

imtiazm (12/12/2011)

---

So my question:

1) Can i restore past the point of error in the transaction log file. ignoring the error)

2) Can i restore just before the point of error.

3)...

Remember the production server is still operational, and TL are still being taken, was working from this monring, until we seen we have an error on the tl restore on...

ashanair70 (12/12/2011)

---

We create test database from a backup copy of production database every weekend. I want to find out whether there is a way I can find the last refresh/restore...

Lowell (12/12/2011)

---

i'd recommend forgetting about putting the count in the table.

instead, create a view that is uesed to calculate the count based on a join; then the count is correct...

Memory Pressure Error

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/337aea24-09ff-4354-b67d-8a90f67a13df/