DAP 93723 (8/12/2016)

---

Thanks for all your feedback.

So If I install a new instance of 2012 Standard on the same machine, it's NOT going to affect ANY aspect of existing 2008...

The OP will have to come back with answers to my questions, otherwise we're only guessing, probably an object restore from a backup would be the way to go here...

First...

Not if done correctly, done many times larger files this way.

😎

Quick thought, use XQuery in SQL Server and wildcard name spaces, ie. *:element

😎

Quick questions, are you...

SQL!$@w$0ME (8/8/2016)

---

Hi Folks,

I have a requirement to build a test SQL 2016 box. We need to utilize polybase feature.

* Any suggestions on selecting the right edition of SQL 2016...

This is because of an implicit conversion from CHAR to INT, simply add an explicit conversion on the INT column in the case statement.

😎

DROP TABLE #test;

CREATE TABLE #test (

...

Have a look at this code, DigitsOnlyEE and AlphaNumericOnly By Alan Burstein[/url]

😎

Just curious, how do you determine that this is an interview question?

😎

rajemessage 14195 (8/6/2016)

---

hi,

in sql server 2016 json has been introduced, i wanted to know

, should we change to jsaon and leave xml.

because we are keeping configuration in xml in...

rajemessage 14195 (8/6/2016)

---

hi,

which one is good way of putting nolock

other think is

Omitting the WITH keyword is a deprecated feature: This feature will be removed in a future version of Microsoft...

Does ring a bell, isn't there a solution/Project wide security settings? (don't have BIDS/SSDT on the mobile)

😎

Quick question, is it the same execution plan or is there a new one? DPA should have this information if you run analysis on the procedure.

😎

Nice input Brandy, appreciate it:-) Maybe the OP can enlighten us on the issue?

😎