After reading all posts, I see everyone is doing what is right for their environment. Personally I would only work for a company that strives for clarity and purity...

Since UploadID is an identity, I assume deleted rows won't be reinserted so pages will generally become empty instead of split.

Personally I wouldn't care about fragmentation on such a tiny...

Having read the entire article and all responses, I'm wondering if people benefited at all or just managed to strengthen their ego positions. I think a much more intelligent...

Thanks everyone, the sys.columns does hold the TVF returned columns; not sure how I missed that except I was also working with TVPs at the same time which don't make...

Eirikur Eiriksson (5/11/2015)

---

Bill Talada (5/11/2015)

---

Regular functions store the return value as parameter zero in sys.parameters but I can't find the TVF table definition for the following sample function. Is...

Ken Davis (5/11/2015)

---

The CI on the big 5-month archive table is highly fragmented. Background info: this was implemented with a terrible clustering key - a random GUID. About...

Since I'm incredibly lazy, I'll borrow some code from Old Hand and insert a shortcut:

--Let's get some sample data to work with

CREATE TABLE SampleData (

EmployeeID CHAR(3),

Computers char(1),

Phone int,

Ipad int

)

INSERT INTO...

There will always be unexpected weird stuff that slows down a server:

Apps going CPU crazy with pooled connections, resetting dozens per second.

Someone stealing all CPU by zipping files on the...

If you want separate columns for first name and last name:

SELECT

ci.ClientID,

Person.query('.') AS Person,

Person.value('FirstName[1]','varchar(20)') AS First_Name,

Person.value('LastName[1]','varchar(20)') AS Last_Name

FROM

ClientInfo ci

CROSS APPLY

Info_untyped.nodes('/People/Person') AS People(Person)

;

I wrote an article...

These are two of my favorite products. SqlCodeGuard correctly parses all objects and applies best practice rules to each one. It helped me find 20,000 deprecated features and...

DECLARE @dt datetime;

SET @dt = '20150102';

SELECT DATEPART(week,@dt) - CASE WHEN DATEPART(WEEKDAY,@dt) < 7 THEN 1 ELSE 0 end;

I had the error until I did this workaround for a unix line ending.

I couldn't do a bulk insert directly with just a linefeed. I had to do it...

Hmm, I'd try starting with varchar(100) globally and adjust a few upwards. I'm thinking 244 * 6000 is over 1 MB and causing the problem.

I've gotten the message plenty...

Another case of the ignorance of Central Planning. Details are important and they always get lost by the time they make it to a central head quarters. Authority...