nazaninahmady_sh (9/3/2016)

---

Hi

I use sharepoint(2013),for this I have SQLServer(2014) in seprate server.Now I have to" update" SQLServer(2014) in server, I want to know that if there is any specific point in...

mah_j (9/3/2016)

---

Hi

I have a table with 11 G data space and 25,000,000 records.3 fields are configured for full text search, they are all nvarchar(4000) and the cataloge size...

Quick thought, add a test for the row in the table header template match, i.e changing

xsl:template match="oh"

to

xsl:template match="oh/q"

will eliminate the header for the "oh" if there are no "q" elements...

Another option is to use either sp_describe_first_result_set or the sys.DM... version of it.

😎

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