First of all, Phil's query does not only return...

MotivateMan1394 (4/25/2015)

---

Hi

How can I rewrite this in better performance :

select *, ( SELECT TOP 1 Code FROM T2 WHERE T2.Id=T1.Id ...

That is incorrect, it is the partition clause and in this case the...

Quick thought, I think you are over complicating this, consider this code

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 1000;

IF OBJECT_ID(N'dbo.TBL_GENDER_SEEKING') IS NOT NULL DROP TABLE dbo.TBL_GENDER_SEEKING;

;WITH T(N) AS (SELECT N...

Sorry for the delay, work got in the way and of course I got a little carried away too:

Having read the article and already looking into a similar problems,...

Ed Wagner (4/25/2015)

---

Eirikur Eiriksson (4/24/2015)

---

Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance...

gracebite1981 (4/24/2015)

---

Hi All,

I am looking to help on Language translation option in SQL Server 2008 R2

Here is my requirement

I have one database (Table name...

demin99 (4/24/2015)

---

Hi All,Iam able to view showplan when Iam using dbo schema but when I use userdefined schema then I

get an error SHOW PLAN denied on database.

select * from...

Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the query will...

Should have been clearer, the update is the Cumulative update package 5 for SQL...

waeva (4/24/2015)

---

Is there a dbcc flag that will capture all error messages in the log

e.g. when inserting data into a table, a PK violation occurs throwing, Msg 2627

..similar to trace...

Mr. Kapsicum (4/24/2015)

---

Sorry for the delayed response

Version is : Microsoft SQL Server 2014 - 12.0.2000.8 (X64)

Feb 20 2014 20:04:26

Copyright (c) Microsoft Corporation

Enterprise Edition: Core-based Licensing (64-bit) on Windows...

Koen Verbeeck (4/24/2015)

---

I've had people DM me as well with their...

crookj (4/24/2015)

---

Eirikur Eiriksson (4/24/2015)

---

Ed Wagner (4/24/2015)

---

Eirikur Eiriksson (4/23/2015)

---

Ed Wagner (4/23/2015)

---

crookj (4/23/2015)

---

Ed Wagner (4/23/2015)

---

Revenant (4/23/2015)

---

djj (4/23/2015)

---

Eirikur Eiriksson (4/23/2015)

---

Ed Wagner (4/23/2015)

---

djj (4/23/2015)

---

TomThomson (4/22/2015)

---

Eirikur Eiriksson (4/22/2015)

---

djj (4/22/2015)

---

Eirikur Eiriksson (4/21/2015)

---

Pixie...

Gain