Okay. This is driving me batty.

New code (with datatypes fixed) works fine ....

------------------------------Data file size----------------------------

IF (SELECT OBJECT_ID('tempdb..#dbsize')) IS NOT NULL

DROP TABLE #dbsize;

CREATE TABLE #dbsize

(Dbname...

Luis Cazares (1/22/2016)

---

Brandie Tarvin (1/22/2016)

---

Luis Cazares (1/22/2016)

---

You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

You're effectively not inserting any null values explicitly, but you were...

Luis Cazares (1/22/2016)

---

You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

You're effectively not inserting any null values explicitly, but you were missing the column in...

I understand what you're saying about the SYSNAME, and I agree I need to fix the code.

But if that's the case, why did fixing only the driveletter column, which is...

Eirikur Eiriksson (1/22/2016)

---

Quick suggestion, change the #dbsize create script

😎

CREATE TABLE #dbsize

(

Dbname SYSNAME ...

Ran into something weird with temp tables this morning / yesterday. I have resolved the problem, but without understanding what the problem really was. Would appreciate some insight if anyone...

Two years from now he or his successor are going to be very irritated about their design.

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for...

Jacob Wilkins (1/19/2016)

---

Eirikur Eiriksson (1/19/2016)

---

GilaMonster (1/19/2016)

---

*sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should have a...

That is flippin' brilliant.

SQLRNNR (1/19/2016)

---

BL0B_EATER (1/19/2016)

---

SQLRNNR (1/19/2016)

---

GilaMonster (1/19/2016)

---

Talking about dressing up a CV, the last time I used an agency (well over 10 years ago), they sent me to an interview. At the...

Hugo Kornelis (1/19/2016)

---

BL0B_EATER (1/19/2016)

---

Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my mentoring /...

And the joyous news of the day is no moving the corporate monitoring dbs over to our new servers because we own the servers so are expected to do our...

BrainDonor (1/18/2016)

---

As the Testing forum doesn't appear to be the busiest area of this site - if anybody here has played with SQL Test I'd appreciate them taking a quick...

GilaMonster (1/14/2016)

---

He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he asks "What's a...