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...

rishi-445055 (8/25/2014)

---

Hi,

So if we make Code Nullable should not the query become non-sargeable, thereby meaning it does not use the Index ix_CCode, but making the column as Null still uses...

sql-lover (7/5/2014)

I won't waste my time arguing with you. Your statements clearly shows you have zero working experience.[/QUOTE]

OK - you got me 🙂

sql-lover (7/5/2014)Moreover, based on your posts on this...

sql-lover (7/1/2014)

---

utterly rubbish!

There is no difference between Unique Index and Unique Constraint, besides the obvious syntax of course.[/QUOTE]

I don't know your knowledge but such an ignorance of ANSI defintions is...