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,

...

Hi Faraz,

you can use DBCC IND if you use SQL Server < 2012 or sys.dm_db_database_page_allocation for SQL Server >= 2012.

This will give you a list of allocated pages.

To have a...

+1

I thought beeing in the wrong theater 🙂

gbritton1 (8/27/2014)

---

The question asks, "What happens", yet one of the "correct" answers is that we need to change the variable and replicate lengths. At the risk of being pedantic,...

AAARGH - I'm a scatterbrain.

You are right - it should be 2 not 4!

To early in...

Hi Rishi,

a good (the best) starting point is "SQL Server Internals" from Kalen Delaney. On Page 309 you find a pretty cool explanation of the row structure. Furthermore you will...