Viewing 15 posts - 2,056 through 2,070 (of 9,725 total)
Stuart Davies (2/4/2016)
BL0B_EATER (2/4/2016)
ChrisM@Work (2/4/2016)
Luis Cazares (2/3/2016)
This got me by surprise. I'm not searching for jobs, but it got my attention because it was totally unexpected (but possibly logical).
Stuart's BS...
February 4, 2016 at 4:47 am
Jo Pattyn (2/3/2016)
I guess its Azure now.Thanks for your input Brandie, got a possible workaround.
Glad I helped, even though I'm not sure what brilliant thing I'm sure I said. 😀
I...
February 4, 2016 at 4:45 am
Luis Cazares (2/3/2016)
Brandie Tarvin (2/3/2016)
Luis Cazares (2/3/2016)
Brandie Tarvin (2/3/2016)
SQLian (2/3/2016)
delete [FROM] Customers
where CustID NOT...
February 3, 2016 at 9:59 am
Luis Cazares (2/3/2016)
Brandie Tarvin (2/3/2016)
SQLian (2/3/2016)
delete [FROM] Customers
where CustID NOT in (
...
February 3, 2016 at 9:50 am
Hugo Kornelis (2/3/2016)
John Mitchell-245523 (2/3/2016)
Having said that, I don't understand why you're getting a result for that fourth stored procedure.
My guess is that the comments in that procedure contain a...
February 3, 2016 at 6:39 am
GilaMonster (2/3/2016)
Brandie Tarvin (2/3/2016)
But when I tried escaping the underscores in my code, I got no results at all.
WHERE Column LIKE '%/_%' ESCAPE '/'
That would find anything with an _...
February 3, 2016 at 5:49 am
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
Viewing 15 posts - 2,056 through 2,070 (of 9,725 total)