Hi Jason,

if you are using a C. I. you don't have any more Forwarded Records but Page Splits.

Does your table have additional nonclustered indexes?

Yes: A clustered index will blow your...

Hi Jason1,

before you start creating a clustered index on this table ask yourself (or the devs), WHY they want it.

• Why is a C. I. better than a heap?
• What...

Hey Steve,

maybe the question is a little bit misleading. Do you want to have the next 12 values? (1, 2, 3, 4, ...) or do you want to have the...

I know, I am late to this topic.

But collation is the point here:

DECLARE @s TABLE (Id VARCHAR(3) COLLATE LATIN1_GENERAL_BIN)
INSERT @s (Id)
SELECT N'1.' Id
UNION ALL
SELECT N'1-' Id
UNION ALL
SELECT...

Thank you for the sum up of the new "Operator".

I believe it's beneficial to have this operator available as an ANSI standard in SQL Server. This is especially true when...

Why not creating a NONCLUSTERED Index on the datetime column and "walk in small batches" through the table.

Small chunks of data prevent LOCK ESCALATION and you can run it smoothly...

SELECT r.session_id, s.text
FROM sys.dm_exec_requests AS r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS s
WHERE r.status = 'running';

This will work. The author used the wrong aliases 🙂

BTW: I would not check for...

Hey Leo,

your assumption is correct. This is an indicator of an Clustered Index Creation or Clustered Index REBUILD. This pattern (INSERT INTO MyTable SELECT * FROM MyTable) is an internal...

I am here with Brian Gale. For me it is more a commercial than a technical post.

I would love to see the incoming statements on the database side.

e.g.

Microsoft Certified Master: SQL Server 2008

MVP - Data Platform (2013 - ...)

my blog: http://www.sqlmaster.de (german only!)