Lynn Pettis (7/16/2015)

---

Here is another way to accomplish the task with no need to create a sort column in a CTE.

SET NOCOUNT ON;

DECLARE @TEST_NULL_SORT TABLE (AREA VARCHAR(50) NOT NULL, CATEGORY...

Further on Gail's and Steve's replies, don't ponder on how before you can identify and quantify the potential problem. If there are only 10-20 inserts per second, each record would...

Bharatvip (7/15/2015)

---

We are building a new environment and have got a Sql Server with 32 GB memory, 32 core 2.00 GHZ CPU, a Sql 2012 installation. We have about 6...

Depends on few things but one aims as close...

Does not exist in SQL Server but a workaround could be adding a sort column

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TEST_NULL_SORT TABLE (AREA VARCHAR(50) NOT NULL, CATEGORY VARCHAR(50) NULL);

INSERT INTO...

Quick thought, normally I would script out A, do whatever modificarions needed and then run the scripts on B and full rebuild.

😎

Glad you made the right decision,...

Thanks for the heads up Rodders

😎

Firstly, do not use concatenated values in a column, just going to be a pain!

😎

Here is a simple ERD to explain the concept

...

Brandie Tarvin (7/15/2015)

---

I need to find a way to identify SPIDS where queries are connected to certain databases using the 4 dot notation instead of actually being connected to the...

WayneS (7/15/2015)

---

I didn't notice it before, but that's not quite the code that I posted, which is (after modifying to varchar(30) as Steve suggested):

CREATE FUNCTION dbo._tTVFN_tEEst2 (@countryNr INT, @telNr NCHAR(30))

RETURNS...

WayneS (7/15/2015)

---

XML shredding...

Jeff Moden (7/15/2015)

---

Or one version of ANSI Utopia to another. 😀 ANSI and...

...and an utter waste...

This one here is by far the fastest as Wayne's test clearly shows

😎

IF OBJECT_ID(N'dbo._iTVFN_tEEst') IS NOT NULL DROP FUNCTION dbo._iTVFN_tEEst;

GO

CREATE FUNCTION [dbo]._iTVFN_tEEst (@countryNr...