Taxation

Easy one (but I still ran this in SSMS to be safe 😛 : EXECUTE('SELECT 1');)

I'm pretty confident that what I posted would do the trick provided the OP has or can add a datetime column.

shogunSQL (7/12/2016)

---

Hi,

I have a table like this:

Create table Tbl_Test01

(

Name nvarchar(20),

Item nvarchar(30)

)

;

insert into Tbl_Test01

values

('Car','Honda2016'),

('Car','Honda2017'),

('Car','Honda2018'),

('Tool','Dwwalt2016'),

('Tool','Dwwalt2017'),

('Tool','Dwwalt2018'),

('Tool','Dwwalt2019')

select *

from Tbl_Test01

I'd like to have the value of the column Name show up once and the...

TheSQLGuru (7/12/2016)

---

Alan: your PK breaks inserts of >1 row with the same datetime value, which is going to happen both with multi-row batch inserts as well as concurrent access (due...

patrickmcginnis59 10839 (7/12/2016)

---

Igor Micev (7/12/2016)

---

patrickmcginnis59 10839 (7/12/2016)

---

An ORDER BY clause can be used explicitly in the end as well. In that case the COUNT is not deterministic. See Deterministic and...

Great work Igor, 5 stars!. You did a great job grouping (pun not intended :-P) together the most important aspects of COUNT. Fantastic article and a great resource to point...

Jeff beat me to it. Here's some DDL that shows how to implement what Jeff suggested.

USE tempdb -- a safe place to test this out...

GO

-- (0) Your table...

To get the current max degree of parallelism for a specific instance of SQL Server:

SELECT value_in_use

FROM sys.configurations

WHERE name = 'max degree of parallelism'

attack

den

Ed Wagner (7/8/2016)

---

Very nice work, Alan. I think you explained the concept really well and used some very good examples. I have to tell you that it reminds...

Ok Solomon, I tried to figure this out and failed. Forgive my CLR noobness (I create about 1 CLR/year) and I'm sure this is simple but I'm having a hard...

Marcia J (7/5/2016)

---

I don't know if it's just my machine, but the final code box is empty. I tried Chrome, IE, and IE with compatibility settings. I assume...

Glassdoor.com is very good and reliable. For example - a google search for "glassdoor dba...