Tac11 (2/1/2015)

---

Thanks for you reply. But i didn't catch you. All three outputs have same table name, same index name and index type, but different fragment level and different page...

... Mark one off, 27 days on the calendar to go. 27 days on the calendar to go, 27 days to go, ...

Look carefully at the output of the data, you will see that there may be multiple index levels. The function, sys.dm_db_index_physical_stats, when run with the DETAIL option shows the...

xsevensinzx (1/31/2015)

---

Well, that escalated quickly! :hehe:

I read your epic post(s), so I figured I would chime in too.

Jeff Moden (1/31/2015)

---

The real question behind every question that an interviewer asks is...

Jeff Moden (1/31/2015)

---

yoshii (1/31/2015)

---

not sure where's this thinking of "reading interview questions = cheating a job" coming from. there're billions of people on earth. there are people trying to cheat...

... Mark one off, 28 days on the calendar to go. 28 days on the calendar to go, 28 days to go, ...

I have an idea, show us what you have tried.

Not enough information to really do anything. Not sure how to get from your sample to the sample output.

rjdpa2 (1/30/2015)

---

Hello... I need some help building a query. I have a table with 4 columns and need to try and put the times together. There are some inconsistancies with...

Jeff Moden (1/30/2015)

---

Heh... agreed. There's a lot to be said for all of that and not suggesting a move. Just suggesting that you'd make a better DBA than...

Well,...

Is there a part of me that would like to move up into a more management level position, possibly. Problem is I enjoy working with MS SQL Server and...

Data scripts don't work either:

Msg 547, Level 16, State 0, Line 2

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ARTICLE_CONCERNER_FAMILLE_". The conflict occurred in database "Sandbox4", table "dbo.FAMILLE_ARTICLE", column...

I just ran the script to create your tables and the code failed:

Msg 1767, Level 16, State 0, Line 2

Foreign key 'FK_SOUS_SIT_RENFERMER_SITE' references invalid table 'dbo.SITE'.

Msg 1750, Level 16, State...

You do realize that the people that help here are unpaid volunteers doing this when we have time between our lives and work to provide back to the...