Viewing 15 posts - 2,071 through 2,085 (of 9,725 total)
Jacob Wilkins (1/26/2016)
Brandie Tarvin (1/26/2016)
Final (working) code for those who are interested....
That's going to give incorrect results. For the insert into #alldbstate, you're still joining sys.databases and sys.master_files on the...
January 26, 2016 at 10:32 am
Final (working) code for those who are interested.
------------------------------Data file size----------------------------
IF (SELECT OBJECT_ID('tempdb..#dbsize')) IS NOT NULL
DROP TABLE #dbsize;
CREATE TABLE #dbsize
(Dbname SYSNAME NOT NULL,driveletter CHAR(1) NULL,...
January 26, 2016 at 10:22 am
Other than me setting a VARCHAR column as NOT NULL in #dbfreesize, I did see the difference between using the local file tables (you'd think I would know better) and...
January 26, 2016 at 7:51 am
Eirikur Eiriksson (1/24/2016)
Brandie Tarvin (1/22/2016)
... I have a bit of code that monitors my database growth.Quick question, are you intentionally returning one row for each database file?
😎
Yes, because some...
January 26, 2016 at 7:42 am
I guess my main misunderstanding here is Tom's use of "'safe harbor' farce". I feel as if I'm missing a specific reference.
January 26, 2016 at 7:37 am
TomThomson (1/25/2016)
GilaMonster (1/25/2016)
Bandwidth, latency and data out of the country (for 1 and 3)
I see the same. Plus in the EU it's probably illegal to host the data outside...
January 26, 2016 at 5:35 am
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...
January 22, 2016 at 11:01 am
Luis Cazares (1/22/2016)
Brandie Tarvin (1/22/2016)
Luis Cazares (1/22/2016)
You're effectively not inserting any null values explicitly, but you were...
January 22, 2016 at 10:52 am
Luis Cazares (1/22/2016)
You're effectively not inserting any null values explicitly, but you were missing the column in...
January 22, 2016 at 10:39 am
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...
January 22, 2016 at 10:37 am
Eirikur Eiriksson (1/22/2016)
😎
CREATE TABLE #dbsize
(
Dbname SYSNAME ...
January 22, 2016 at 5:56 am
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...
January 22, 2016 at 4:44 am
Two years from now he or his successor are going to be very irritated about their design.
January 21, 2016 at 6:23 am
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
January 20, 2016 at 12:37 pm
Jacob Wilkins (1/19/2016)
Eirikur Eiriksson (1/19/2016)
GilaMonster (1/19/2016)
January 20, 2016 at 6:32 am
Viewing 15 posts - 2,071 through 2,085 (of 9,725 total)