My guess is full recovery model and no log backups

Please read through this - Managing Transaction Logs[/url]

As I mentioned previously (http://www.sqlservercentral.com/Forums/Topic1407762-391-1.aspx)

You'd have to restore the primary filegroup backup, the the secondary, then all the log backups since the oldest of those 2 backups to bring the...

An index rebuild updates the stats associated with that index as part of the rebuild operation

Because the second query becomes essentially

select a,b,c from MyTable

where CAST(a AS nvarchar(2)) in(N'Ab',N'BC',N'CD')

Revenant (1/18/2013)

---

Brandie Tarvin (1/18/2013)

---

Chad Crawford (1/18/2013)

---

wolfkillj (1/18/2013)

---

MS announced that SQL Server 2012R2 will be released in late 2014...

If you want an explanation, I need to see the plan, not a partially blacked out image of the plan.

bwperrin (1/18/2013)

---

I was hoping it would be a good idea to do the full backup, then immediately after set SINGLE USER, SIMPLE RECOVERY, rebuild indexes, update statistics, then back to...

No it doesn't.

Char(50) always uses 50 bytes, varchar(50) uses as much space as the data in it (plus...

PTPortal.PTPortalUser.PTJOBLOGS has a corruption in its clustered index. Take the DB into single user mode and run DBCC CheckDB(PTPortal, repair_rebuild)

Why don't you open up books online and read over Create Index.

btw,...

Shrinking a full log is...

http://sqlinthewild.co.za/index.php/2009/09/22/estimated-rows-actual-rows-and-execution-count/

Wait analysis

Performance benchmarking

Maybe. Maybe not.

Try it out in a test environment and see. Also, check why the operations are taking so long, what the wait type is that they get.

http://www.sqlservercentral.com/articles/Indexing/68563/

No.

If I have a stored procedure that accepts parameters and build an sql string within the stored procedure, does...