That sounds like a good approach. I've now done the data import on a test backup database and I'll write some LINQ and do some testing on the retrieval...

The table will not grow beyond 200k rows. We can't use Clustered Columnstore indexes because it's SQL 2012 Standard.

The current search function is extremely slow (of the order of 20-30 seconds), for reasons mainly to do with poor data design, cruft and arcane business logic. It's felt,...

Iulian -207023 (8/1/2016)

---

It should be something like:

Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)

Jun 17 2016 19:14:09

Copyright (c) Microsoft Corporation

Express Edition (64-bit) on Windows NT 6.3 <X64>...

Weird. SELECT @@version does not return SP information, at least not on my machine:

Microsoft SQL Server 2014 - 12.0.4213.0 (X64)

Jun 9 2015 12:06:16

Copyright (c) Microsoft Corporation

Express...

asutorius (7/27/2016)

---

I received the following reply when running that script against AdventureWorks database.

Beginning execution loop

Msg 208, Level 16, State 1, Line 2

Invalid object name 'tbl'.

** An error was encountered during...

John Mitchell-245523 (7/27/2016)

---

Not sure whether you're saying...

I ran the script and then this

SELECT COUNT(*) FROM tbl

Guess what number it returned? (HINT - an integer between 99 and 101)

Carlo Romagnano (6/30/2016)

---

The second option is useless, but it also is correct.

SELECT @p = N'@m varchar(200)="event message", @d datetime=getdate(), @U varchar(10)="Steve" '

I.e. this code returns 1 despite @p...

Yet another borked QotD.

I know. Hilarious, ain't it.

Another borked QotD.

Another borked QotD.

Lynn Pettis (5/4/2016)

---

Wow, you have your own country? Must be...

Ed Wagner (5/4/2016)

---

edwardwill (5/4/2016)

---

It's broken so no,...