I've reproduced the 64/65 split using a small set of 1,000,000 rows with much higher duplication on the key than in your set, roughly 4 times higher. The difference between...

Jason A. Long (9/20/2015)

---

It's simply a renamed version of Jeff Moden's DelimitedSplit8k function. It was renamed to...

Jason A. Long (9/19/2015)

---

I won't call this an elegant solution by any stretch of the imagination, but it's the only "1:00 am" solution that's coming to mind at the moment...

IF...

vijayu (9/20/2015)

---

Hi,

I tried so hard to recreate the error 833, through simulation using different suggested method. But was not successful. Can I manually add it in the error log of...

My suspicion is that this has more to do with the selectivity, that is the number of duplicate key values in the nonclustered index.

😎

What is the output of this query?

SELECT

...

shamshad.ali (9/18/2015)

---

I have two tables for insertion in one transaction scope. Table one have 10 rows. After first table insert statement (not yet committed) if I run select on first...

No, the stats are accumulative, you will have...

vincenzo.capelli (9/19/2015)

---

Hi,

I have this task, I have to copy from one database into a remote all record which contain a specific value into a specific column. (the remote Db destination...

Jeff Moden (9/19/2015)

---

Eirikur Eiriksson (9/17/2015)

---

Using my normal test harness, Kristen's DATETIMEFROMPARTS solution is a clear winner, more than twice faster than the next one. Note that the slowest solutions and...

kevitra (9/18/2015)

---

I made a full text index on the column and basic queries such as:

select * from ourtable where contains(bigcolumn, '\\AReallyLongStringofTextHere') works fine unless there is a space in the...

stanlyn (9/18/2015)

---

Hi,

Why are the user databases that were created in the MSSQLSERVER default instance showing up in the newly created ALPHAONE instance? I'm successfully logging into the alphaone database...

WayneS (9/18/2015)

---

Sean Lange (9/17/2015)

---

I can't change the table at all. It will violate our support contract. Not to mention it would be possible to get trashed with an update at...

BSavoie (9/18/2015)

---

Is there a better way to handle this sort of thing? It just doesn't feel right putting a SELECT in the WHERE, but it does exactly what I...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON

IF OBJECT_ID(N'tempdb..#temp') IS NOT NULL DROP TABLE #temp;

create table #temp (Cabstamp varchar(10), account varchar(10),document varchar(15), origin varchar(2), debit numeric(10,2), credit numeric(10,2), datalc datetime)

insert into #temp (Cabstamp,account,Document,...

tomisoft (9/18/2015)

---

Hello,

I have a view which I'm trying to optimize.

Here's original one:

ALTER VIEW [dbo].[V_Smeny_D]

AS

SELECT s.ARBPLNR, s.DATUM, master.dbo.spt_values.number AS smena, DATEADD(hh, CASE number WHEN 1 THEN 0 WHEN 2 THEN 6...