Hallo Graham,

as always - it depends 🙂

In my test Environment with 4 cores, 32 GB and SSD the elapsed...

The fragmentation of the Indexes (INT or GUID) is nearby the same...

Hi Patrick,

maybe but this will lead to a wrong answer (as in my case). So - I'm not crazy about the points but the answers are ALL wrong from the...

Hi Steve,

seems to be NONE of the given examples are correct 🙂

USE [mydb]

GO

ALTER DATABASE [mydb]

MODIFY FILE

(

NAME=N'OldName',

NEWNAME=N'NewName_01'

);

GO

I assume that you have forgotten to...

Gosh - failed!

I have to read more carefully the options 🙂

I was focused on the error of the INSERT statement but didn't realize that the result of ERROR_MESSAGE() was asked.

My...

MohamadHamedi (1/7/2015)

---

i have a question.

we know that we stored old data from 20120101 to past.

then when we want to search data,check the order date.

if it is older than 20120101 we...

san1901 (1/6/2015)

---

Just a minor limitation about the CHECK Constraint. The date columns must not have NULLs in them. Otherwise, SQL will go and check both tables.

CHECK constraints reject values =...

Hallo ZZartin,

sorry but I don't understand your "recommendation". What modification do you want to do to the function?

Bob Cullen-434885 (1/6/2015)

---

Great question! Like the previous poster, I also have the potential to use this scenario, as we are keeping way too many records in our "live" tables, but...

As you have mentioned correctly - the statistics will be updated automatically if an index will be rebuild.

BUT...

There are different problems in the systems which forces a different maintenance for...

Hi Nic,

there is no way to reset the CT number!

https://social.msdn.microsoft.com/forums/sqlserver/en-US/2d0657f5-bdea-4385-9f80-1cb16d8554bc/resetting-change-tracking-version

If you need to reset the numbers I would suggest to disable CT and recreate it...

GilaMonster (12/29/2014)

---

Uwe Ricken (12/29/2014)

---

SELECT, INSERT, UPDATE, DELETE are definitely not always single threaded. They can all run in parallel when the optimiser decides that the plan is expensive enough (compared...

Hi Gail,

SELECT, INSERT, UPDATE, DELETE are definitely not always single threaded. They can all run in parallel when the optimiser decides that the plan is expensive enough (compared with the...

Hi all, hopefully you all had a wonderful christmas time and big presents 🙂

Concerning the "checklist" there are to much "it depends" on it as I would prefer to use...

Hey Phil,

why doesn't it meet the requirements / question?

He wants to have the content of the index itself or do I missunderstand the request?

CREATE TABLE dbo.foo

(

idINTNOT NULL,

...