It was truly a "near miss":-D

😎

Koen Verbeeck (8/11/2015)

---

Ah well, up to...

0xC34F0xC350 Missed it:pinch::-D

😎

Correction, only 7 posts to go...:-D

😎

Inertia

Koen Verbeeck (8/11/2015)

---

And despite his successes, he...

Few options in SSMS:

1) press ALT + H, Down arrow, Enter

2) Left click on the [HELP] menu and...

I lose!:pinch:

😎

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @Users table(UserID int identity(1,1) primary key,Name varchar(50),Active bit);

declare @CreditCards table(IdCredicard int identity(1,1) primary key, UserID int,CardNo bigint,Active bit,Date_Created datetime);

insert into @Users(Name,Active)

select 'Name1',1 union all

select 'Name2',1...

peter 82125 (8/10/2015)

---

When I first opened Books Online, I chose the option to run the documentation online rather than locally; now I would like to change that to locally. Can...

Further on the subject, what is killing the performance is most certainly the distinct sort and table scans for the xml subquery. Adding an index on InvoiceID, Row_Num and include...

Quick thought, too much information missing, without it one is just guessing!

😎

Post the...

jan.dewettinck (8/9/2015)

---

Thanks for the question

Not sure if the following link provides a better explanation.

https://msdn.microsoft.com/en-us/library/ms187928.aspx

I based my answer on the part about the style which says that the default is...

You are very welcome

😎

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

GO

CREATE TABLE dbo.test (

action_id numeric,

action VARCHAR(20) NOT NULL,

action_by VARCHAR(20) NOT NULL,

action_date VARCHAR(20) NOT NULL

);

INSERT INTO dbo.test (action_id,action, action_by,action_date)

VALUES...