Another option I've been using for similar purposes is the dynamic management view sys.dm_db_index_usage_stats, monitoring the changes in user_updates using last_user_update and index_id < 2 to limit the output. The...

mister.magoo (11/7/2016)

---

I have to say though -...

David Burrows (11/7/2016)

---

WITH x (ID,FirstName,LastName,UserName,UserNum) AS (

SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,

ROW_NUMBER() OVER (ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC,LEFT(e.FirstName,t.N)+e.LastName ASC,ID ASC)

FROM #Employee e

JOIN master.dbo.Tally t ON t.N BETWEEN 1 AND LEN(e.FirstName)

WHERE NOT EXISTS (SELECT * FROM...

Here is a solution that works according to the current;-) requirements. It has a limitation of the first name being 30 characters or shorter, don't think that is going to...

It has all the backup file names, error code, error number, did you need any...

Simple "set" based approach

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

create table #mytab (origval varchar(max))

insert #mytab values

('1.2'), --should convert to 1.3...

Then this...

Eric M Russell (11/7/2016)

---

Eirikur Eiriksson (11/7/2016)

---

Eric M Russell (11/4/2016)

---

Or you could leave the columns as is and add page compression, which in this case would probably shrink the table down...

You are very welcome

😎

Another question, how frequently will this be called?

:exclamation: hopefully those are not doing any sql development :exclamation:

😎

Jeff Moden (11/7/2016)

---

Eirikur Eiriksson (11/7/2016)

---

Jeff Moden (11/6/2016)

---

Geez... it would have been SOOOOOOOO simple for them to make the "improvement" so much more worthwhile. I don't know why they even...

I find it easier to log the output of the OH scripts to a table and work from there.

😎

One option is to use XML, here is a simple example

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @PARAXML XML = '<X>1</X><X>2</X><X>3</X><X>4</X><X>5</X>';

SELECT

P.DATA.value('(./text())[1]','INT') AS PARAM_VALUE

FROM @PARAXML.nodes('/X') P(DATA);

Output

PARAM_VALUE

-----------

1

2

3

4

5

Quick question, how many parameter...

David Burrows (11/7/2016)

---

Notwithstanding Eirikur's statement re same first names

WITH x (ID,FirstName,LastName,UserName,RowNum) AS (

SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,

ROW_NUMBER() OVER (PARTITION BY e.ID ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC)

FROM #Employee e

JOIN master.dbo.Tally t ON t.N BETWEEN 1...

Eric M Russell (11/4/2016)

---

Or you could leave the columns as is and add page compression, which in this case would probably shrink the table down to 10% or less of...