I googled over this and found that PowerView can consume this data but what about the data which is already stored in the form of characters and this needs to...

Thanks for your opinion. Before I google it, is it a tool which can interpret this and gives an option...

shahgols (5/1/2014)

---

Yes Sean, you do need more patience, nowhere did I say that I didn't spend any time on this myself. In fact, I have spent 2 days on...

EdVassie (2/24/2014)

---

Most people say that best practice is to have a dedicated DBA administration machine that you do RDP on to, and use SSMS on that machine to do your...

Aliases are created on the client side. And in case of a cluster, we use SQL Server network name so irrespective of which node it runs, it is always accessible.

We...

When 2008 server came out, someone senior to me asked me if the server prompt you to be sure if you( intentionally or unintentionally) click on shut down button:-D. Yes...

Looks like the problem got resolved and you are relieved. However, as a friend posted that we can used trace to capture scans, I think it is a better practice...

GilaMonster (2/13/2014)

---

chandan_jha18 (2/13/2014)

---

I had read this in one of the articles from Paul Randal's blog and found this mention in other places too where during the backup times, to read...

GilaMonster (2/13/2014)

---

Backups don't run through the buffer pool so...

First as suggested by Gail and others, you need to limit your instances to a max memory or sometimes even you will find difficult to login to the OS if...

The...

GilaMonster (2/12/2014)

---

chandan_jha18 (2/12/2014)

---

While this may be a good practice for most of the databases(I have witnessed a lot of similar ones), having an ever increasing key as clustered indexes might...

MyDoggieJessie (2/12/2014)

---

There could be a lot going on...If WRITELOG is your top metric here, I'd have to ask if all your log files from these busy DBs are all writing...

I sincerely apologize to have trimmed a few counters by mistake from the list I provided. Following are top 15 results ordered by their counts:

WRITELOG

LOGMGR_QUEUE

PAGELATCH_EX

CXPACKET

SLEEP_TASK

BACKUPIO

OLEDB

SLEEP_BPOOL_FLUSH

PAGEIOLATCH_SH

LATCH_EX

BACKUPBUFFER

PAGEIOLATCH_EX

SOS_SCHEDULER_YIELD

PREEMPTIVE_OS_AUTHENTICATIONOPS

PAGELATCH_SH

The above are the top 15...

Grant Fritchey (1/7/2014)

---

chandan_jha18 (1/7/2014)

---

Thanks John and Gail. Now I understood it more clearly after relating to the practical lab results and theory. The clustered index column is present in all...