Quick suggestion

😎

DECLARE @SAMPLE_XML XML = N'<obj xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:vim25" versionId="5.5" xsi:type="ArrayOfHostSystemIdentificationInfo">

<HostSystemIdentificationInfo xsi:type="HostSystemIdentificationInfo">

<identifierValue> unknown</identifierValue>

<identifierType>

<label>Asset Tag</label>

<summary>Asset tag of the system</summary>

<key>AssetTag</key>

</identifierType>

</HostSystemIdentificationInfo>

<HostSystemIdentificationInfo xsi:type="HostSystemIdentificationInfo">

<identifierValue>PSF:</identifierValue>

<identifierType>

<label>OEM specific string</label>

<summary>OEM specific string</summary>

<key>OemSpecificString</key>

</identifierType>

</HostSystemIdentificationInfo>

<HostSystemIdentificationInfo xsi:type="HostSystemIdentificationInfo">

<identifierValue>Product ID: 654081-B21</identifierValue>

<identifierType>

<label>OEM specific string</label>

<summary>OEM specific string</summary>

<key>OemSpecificString</key>

</identifierType>

</HostSystemIdentificationInfo>

<HostSystemIdentificationInfo...

Merrier

caddywonkus (5/7/2015)

---

Scenario: a stored procedure is executed in database ABC. The procedure includes a MERGE statement with objects in the ABC and DEF databases. A Windows login is executing the...

With your short and concise style, it could fit into an article:-D

😎

No,...

How about different types of db recovery?

😎

____ KD (5/7/2015)

---

Thank you for all the replies.

The code was working in SQL query.

I wanted to drop the table because the table schema may change so I only...

mxy (5/7/2015)

---

I have SSD storage of size 1TB, if I partition into multiple disks for tempdb, data, logs does it improve performance or not. I mean keeping in single...

Quick thought, open all scripts in SSMS and do Find and Replace in All open documents

😎

Overruns

No worries, enjoy!

😎

Try copy the single row from the second query and paste it to a text editor, the full statement should be there.

😎

Since you don't need historical quantities, you can just summarize the current status

😎

SELECT

WM.ItemID

,SUM(WM.Quantity) AS CURRENT_QTY

FROM @WhareHouseMovement WM

GROUP BY WM.ItemID;

What does this query return?

😎

SELECT 'grant execute on ' +

...

Came across this few years back, caused some strange behaviour and took some effort to find the cause. Workaround was to call T-SQL GETDATE() once at the start of the...