Sean Lange (4/24/2014)

---

That seems to be dealing with the symptom rather than the cause. 😉

Hints should be used as a last resort. The...

How about using the TABLOCK hint?

😎

Nikku (4/24/2014)

---

Hi All,

I have created SSIS package which keeps the track of SysSsisLog table into another table. However I want an option to keep loggin ON or OFF through task/package...

Run Nat start in cmd and check if the instance you are connecting to is there.

😎

Luis Cazares (4/24/2014)

---

Stop working to get something you could easily get by using Identity or SEQUENCE as stated by twin.devil.

You should use a PK (or unique) constraint as well to...

Yes of course, that is why I am interested in seeing how PS would handle this. Often had to implement...

It would be interesting to see the performance of PS when working with sets larger than the 2Gb limits of the XML data type. 😎

jhinch (4/24/2014)

---

I have two tables. Table 1 has column "job", table 2 has column "job" and column "item". In table table 2 there are multiple "items" for each...

SQLCurious (4/24/2014)

---

I have about 1200 sql files in one of my folders. Almost all of these files do data inserts and updates, so they should be run only once. As...

DBA12345 (4/23/2014)

---

I want to update table2 by checking table1.

if trauma has atleast 1 then clm2 in table2 would be 1

if infec has atleast 1 then clm2 in table2 would be...

Hi Matthew,

and thank you for this article.

Few comments, firstly the sp_xml_preparedocument and sp_xml_removedocument have some limitations and quite an overhead, I'm very hesitant recommending / implementing them on a...

In SSMS table content editor, press CTRL+3 and change the sql statement to select * from table_name, then press CTRL+R.

😎

Something along these lines? (ugly but works) 😎

(121 retains the milliseconds while 126 and 127...

Confusing Queries (4/23/2014)

---

Hi All,

I am working on an ASP.net web application which inserts new record into an underlying table. It is actaully a ConfirmationNumber and should be unieque. I have...

Here is an example using AdventureWorks2012

😎

USE AdventureWorks2012;

GO

DECLARE @SOH_XML XML;

SELECT @SOH_XML = (

SELECT

SalesOrderID

,RevisionNumber

,OrderDate

,DueDate

,ShipDate

...