Hi

Try this

SELECT

DB.name,

SUM(CASE WHEN type = 0 THEN MF.size * 8 / 1024.0 /1024.0 ELSE 0 END) AS DataFileSizeGB,

SUM(CASE...

Hi

Try queries like this one for example

--For today

DECLARE @date_start datetime

SELECT @date_start = CONVERT(datetime, CONVERT(date, GETDATE()))

DECLARE @date_end datetime

SELECT @date_end = DATEADD(millisecond, -3, CONVERT(datetime, CONVERT(date, GETDATE()+1))) --SQL server datetime rounds up on...

GilaMonster (6/2/2014)

---

Igor Micev (6/2/2014)

---

Sometimes when you run the same query again it uses less physical reads,...

Sometimes when you run the same query again it uses less physical reads, since the retrieved...

You should investigate on how the TempDB is being used. You should be able to make a kind of capacity planning for it.

For example if you're doing heavy operations into...

Hi,

Data that you posted is not the right statistics data. It's some statistics of the IO (set statistics IO on).

Can you run this set (do it on test)

dbcc dropcleanbuffers

dbcc freeproccache

dbcc...

Eirikur Eiriksson (6/1/2014)

---

Igor Micev (6/1/2014)

---

Confusion!?

2312 - http://support.microsoft.com/kb/2801413

Use when running SQL Server 2014 with database compatibility level 110, which is the compatibility level for SQL Server 2012. Trace flag 2312 forces...

Confusion!?

2312 - http://support.microsoft.com/kb/2801413

Use when running SQL Server 2014 with database compatibility level 110, which is the compatibility level for SQL Server 2012. Trace flag 2312 forces the query optimizer to...

vinpes (6/1/2014)

---

Hi Lowell,

thanks for your reply.

Indeed it is the application that has to assign the purchase order number, the solution you suggest is to create a table with Identity and...

Easy one like for Friday 🙂

SQLRNNR (5/23/2014)

---

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned....

+1

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that...

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says you can't...

Megistal (5/21/2014)

---

I totally agree with Sean Pearce

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says you can't...