Viewing 15 posts - 5,041 through 5,055 (of 9,400 total)
anthony.green (9/28/2015)
Ed Wagner (9/26/2015)
SQLRNNR (9/26/2015)
Ed Wagner (9/25/2015)
Luis Cazares (9/25/2015)
Ed Wagner (9/25/2015)
BrothersMario
Luigi
Koopa
Bowser
Boom Boom
Shotgun
September 28, 2015 at 5:21 am
For all the reasons Gail stated, high memory consumption is actually a feature, not a flaw. Any time you can avoid going to disk and read pages from memory...
September 27, 2015 at 1:32 pm
jasona.work (9/26/2015)
Ed Wagner (9/25/2015)
September 26, 2015 at 11:12 pm
The title had me intrigued. If there's no time for testing, then it's no time to code. We all encounter emergency situations where people want things done right...
September 26, 2015 at 11:05 pm
I'm curious as well. I always use sys.sql_modules to query procedure and function definition and I've never encountered a case when it's wrong. The columns is an nvarchar(MAX),...
September 26, 2015 at 10:55 pm
SQLRNNR (9/26/2015)
Ed Wagner (9/25/2015)
Luis Cazares (9/25/2015)
Ed Wagner (9/25/2015)
BrothersMario
Luigi
Koopa
Bowser
September 26, 2015 at 10:45 pm
Kristen-173977 (9/26/2015)
WayneS (9/25/2015)
And it doesn't take a period one of those names to mess this up... just a space would do it also.
Very entertaining video of a presentation by Rob...
September 26, 2015 at 8:11 am
Finding everything that calls your SF is going to be difficult. You can use sys.sql_modules for everything in the database, but if you have any code outside the database,...
September 26, 2015 at 7:59 am
If you want a tested solution, please take the time to read the article pietlinden and Jeff mentioned. There's also a link to it in my signature. Please...
September 26, 2015 at 7:48 am
J Livingston SQL (9/25/2015)
GO
-- create a test proc in tempdb
CREATE PROCEDURE usptest
AS
SELECT * FROM #temp
GO
-- following code will not remove proc from SSMS
-- but does prevent it showing in...
September 26, 2015 at 7:37 am
MotivateMan1394 (9/25/2015)
I checked it with server team.
Most likely It's related to new backup server . It has a drive with 2 T.byte size.
Although they say...
September 26, 2015 at 7:32 am
If the point of the OP was to test ISNUMERIC, then ample information and Jeff's article has been provided and I won't offer anything different. The function does what...
September 26, 2015 at 7:23 am
Sean Lange (9/25/2015)
Wayne West (9/25/2015)
Sean Lange (9/17/2015)
... I would rather peel M&Ms in the desert than work with this system.
Sounds like the ERP system used by a previous employer. ...
September 25, 2015 at 7:28 pm
jasona.work (9/25/2015)
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Now I'm going to have to leave it to the wife...
September 25, 2015 at 6:16 pm
SQLRNNR (9/25/2015)
Eirikur Eiriksson (9/25/2015)
SQLRNNR (9/25/2015)
Steve Jones - SSC Editor (9/25/2015)
Personally, as I get older, I don't want a cannon. Hard on the wrists and arms.Just mount it to a turret.
...and...
September 25, 2015 at 6:12 pm
Viewing 15 posts - 5,041 through 5,055 (of 9,400 total)