I note that some form of index on ID should probably be in place here to help both with concurrency and performance.

1) I would immediately switch to the FREE, AWESOME, FULLY DOCUMENTED ola.hallengren.com maintenance suite for all SQL Server mx activities!!

2) I would probably switch to a job per database to...

Red-Gate VR is awesome and could be a big win here. ApexSQL also has a Recover tool that can re-constitute tables, DML actions and recoveries, etc, buy using database/log...

Steve, I wonder if you don't have too many tempdb files. I have lost track of the number of clients I have come across that cause IO performance problems...

Rushikesh Ashokrao Bakale (3/20/2013)

---

While migrating from SQL server 2000 databases to SQL server 2012 databases , we need to follow one of the below approach .

SQL server 2000>>SQL Server 2005...

kavidha (3/20/2013)

---

Hi Kevin,

Thanks a lot for your reply.

1. No i dont want to use NText...

2. I am not sure about the Single BLOB...so for my scenario, can i use it?...

tafountain (3/20/2013)

---

TheSQLGuru,

I did not intend to spark a debate 🙂 but here are my responses.

This statement...

You MUST read (and follow the guidance from) these and their associated links:

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

I use them myself and advise every client I have to use them as well.

Do you have performance problems on the server? Given that you are using only 1% of CPU, I would be surprised if you did. And if you DO,...

kavidha (3/20/2013)

---

Hi

I am a programmer and need to do the following.

Currently we are using SQL Server 2000 and we are handling lots of resume/cv in .DOC and PDF formats. we...

1) what is estimated and actual row counts from sproc calls?

2) can you post both actual query plans - the one that gets the seek and the one that gets...

Eugene Elutin (3/19/2013)

---

I don't know why OP doesn't, but me...

I don't use it because it's useless! It does not guarantee sequential order after reboot as...

SQL Server 2008R2 build 4266

USE AdventureWorks

go

CREATE VIEW test1 as

SELECT

...

1) if you are worried with space, GUIDs have no place in your system.

2) why aren't you using NEWSEQUENTIALID??

3) Your PK on the parent does a clustered index on the...

1) My suggestion is that you get a professional on board for a few days to completely review and improve your entire maintenance process. Managing...