Viewing 15 posts - 2,056 through 2,070 (of 9,715 total)
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Why yes. That's why I...
January 29, 2016 at 5:03 am
Given that there are no instances, I assume there are other things that are not like normal servers.
How does the SAN features (if there are any) work? I'm assuming you...
January 27, 2016 at 6:41 am
Is anyone else having a "dot your Ts and cross your Is" kind of a day?
January 26, 2016 at 11:03 am
Eirikur Eiriksson (1/24/2016)
😎
DECLARE @SQL_STR NVARCHAR(MAX) = N'';
DECLARE @OUTER_SQL NVARCHAR(MAX)...
January 26, 2016 at 10:40 am
Final, final (we hope 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...
January 26, 2016 at 10:37 am
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
Viewing 15 posts - 2,056 through 2,070 (of 9,715 total)