Viewing 15 posts - 2,041 through 2,055 (of 9,707 total)
John Mitchell-245523 (2/3/2016)
An underscore is a wildcard for a single character - if you want to find literal underscores then you need to escape them in your search pattern. ...
February 3, 2016 at 5:41 am
SQLian (2/3/2016)
delete Customers
where CustID NOT in (
...
February 3, 2016 at 5:24 am
Jo Pattyn (2/2/2016)
Why can't system databases be restored "with move" like the others?
Example: RESTORE database model with move -> The system database cannot be moved...
February 3, 2016 at 5:13 am
SQLRNNR (2/1/2016)
GilaMonster (1/30/2016)
Ed Wagner (1/29/2016)
Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.
Oh, hell, yes....
February 3, 2016 at 5:11 am
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
Viewing 15 posts - 2,041 through 2,055 (of 9,707 total)