Post full error...

Always On Failover Cluster Instances are supported but not Always on Availability Groups. Only Enterprise...

info.sqldbamail (4/29/2016)

---

Hi Everyone,

I am having a problem with a wait type in SQL Server i.e. CMEMTHREAD can anyone explain and give a solution for this.

I have only one tempdb datafile...

TheSQLGuru (4/29/2016)

---

Sorry, don't have time to go into cmemthread waits.

But CTFP of 5 is universally too low on modern SQL Servers. Without additional information I would go with 15 for...

ramana3327 (4/30/2016)

---

Hello experts,

We are facing the issue backups are failing and not able to find the cause

We have SQL Server 2014 running and has Reporting Services running which is...

Are you still getting this error or it got resolved on next try?

Thanks MadAdmin and Mike.

Will check with work loads and then will proceed with index creation.

Is there anyway I can get those details?

david mclaughlin (4/22/2016)

---

I have an error - "You do not have permission to use the bulk load statement",

so i open up SSMS and add it:-

grant ADMINISTER BULK OPERATIONS TO [domain\AD...

Alan.B (4/24/2016)

---

I would take a look at this book: Performance Tuning With SQL Server Dynamic Management Views. It will help you put together scripts you can use to determine which...

Phil Parkin (4/21/2016)

---

VastSQL (4/21/2016)

---

Thanks Phil.

Do we need to consider these column which are more read intensive?

I had the same doubt as article mentioned, that instead of creating index just for...

Thanks Phil.

Do we need to consider these column which are more read intensive?

I had the same doubt as article mentioned, that instead of creating index just for FK column ,why...

Robert klimes (4/18/2016)

---

By AlwaysOn, do you mean availability groups? Alwayson includes both failover clusters and availability groups.

Since system center comes with SQL Server Standard license and that is the...

What script or package you are running? What it is supposed to do?

When this error occurred ? When is the last day your DBCC CHECKDB completed without error. Hope you have clean backup.

What you can do is copy the database to Test...

Thanks Jeff & Perry.