jharvey6 76850 (8/30/2016)

---

I have a small data table that store XML files of a certain standard design.

There are three columns [Index_ID] and IDENTITY seeded index, InsertDate, and XML_File of XML...

Ed Wagner (8/31/2016)

---

Eirikur Eiriksson (8/31/2016)

---

Grant Fritchey (8/25/2016)

---

Eirikur Eiriksson (8/25/2016)

---

Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for...

Grant Fritchey (8/25/2016)

---

The Metropolitan Museum...

Steve Thompson-454462 (8/26/2016)

---

Grant Fritchey (8/25/2016)

---

The...

rodickwillision (8/31/2016)

---

To repair corrupt or damaged SQL server database, download an excellent tool Kernel for SQL Database Recovery Tool. The tool also recovers all tables, stored procedure, functions, views, rules,...

Quick suggestion, shift both the start and end time back 3 milliseconds when the end time is 00:00:00

😎

USE TEEST;

GO

SET NOCOUNT ON;

-- Calculating the difference in minutes between two time stamps

--...

jamesforest (8/29/2016)

---

I have trying to pinpoint a table update via fn_Dump_DBlog. I narrowed the update to a 5 minute window but cannot seem to associate any updates with a...

Post moved to the other thread

😎

Can you elaborate further on this problem as without more details and information it is...

Quick solution

😎

USE TEEST;

GO

SET NOCOUNT ON;

Declare @MyXML XML = '<root>

<person>

<type>student</type>

<idnumber>123</idnumber>

</person>

<person>

<type>employee</type>

...

Pivot-156509 (8/29/2016)

---

Hi all, I have the prove that SQL Server sometimes generate the same identity value.

I insert a row in a table and log the identity that was generated using...

Grant Fritchey (8/25/2016)

---

The Metropolitan Museum...

Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?

😎

Drew, have you tested your code with a full reorder of the set? I haven't had the chance but somehow I'm thinking it will return the original order as...

Sean Lange (8/22/2016)

---

I have always been accused of being a little over the top about making sure we have backups of everything in place in case we need to rollback...