Viewing 15 posts - 871 through 885 (of 2,894 total)
...
I should also say, that while I commend you on your ability to quickly build working CLRs, in my opinion if you've got a reasonably close pure SQL solution it's...
November 22, 2012 at 2:08 am
dwain.c (11/21/2012)
Jeff Moden (11/21/2012)
I don't believe that COLLATE will help a STUFF (but I haven't tested it). Logically speaking, it should only help when string comparisons are being made.
I...
November 22, 2012 at 1:51 am
dwain.c (11/21/2012)
Both of the original solutions (yours and Scott's) are subject to the same error! So both must introduce the overhead of the check in the event you want...
November 21, 2012 at 8:51 am
Mark-101232 (11/21/2012)
...Another tweak helps a bit (maybe... assuming I've got this right)
Change
,1, '.' + LEFT(a.email, CHARINDEX('.', a.email)-1) + '@')to
,0, '.' + LEFT(a.email, CHARINDEX('.', a.email)-1))
Nope, it doesn't do much for...
November 21, 2012 at 7:04 am
Alvin Ramard (4/17/2009)
Nicholas Cain (4/17/2009)
It's 3pm on a Friday, your production OLTP environment is down, every hour down costs the company one million dollars. People...
November 21, 2012 at 5:48 am
Steven Willis (11/20/2012)
November 21, 2012 at 5:43 am
How do you execute you stored procedure?
Is it from SSMS or your client application or something else?
November 21, 2012 at 5:38 am
kalyav21 (11/21/2012)
But, I also have a sample like this
{ ActionOption : [ Selection Error ] },{ SubstatusName : [...
November 21, 2012 at 5:35 am
Here we go!
First of all, I would like to mention that SET STATISTICS TIME ON and OFF, is not the best for measuring time execution (J.Moden pointed it sometimes ago...
November 21, 2012 at 5:29 am
select LTRIM(RTRIM(
REPLACE(
REPLACE('{ ActionOption : [ Past Audit Window ] }','{ ActionOption : [','')
...
November 21, 2012 at 4:12 am
CREATE PROC dbo.usp_TwoSelects
AS
BEGIN
SELECT * FROM dbo.Table1
SELECT * FROM dbo.Table2
END
November 21, 2012 at 4:08 am
Both statements will perform exactly the same update, with most likely exactly the the same performance.
However, it's considered to be a good practice to drive your query from the smallest...
November 21, 2012 at 4:05 am
...
...CONVERT(VARCHAR(25), GETDATE(), 22)
...
...
Looks like MS forgot to document this style :w00t:...
November 21, 2012 at 3:40 am
...
Is there a simpler way than
DECLARE @dDate DATETIME = GETDATE()
SELECT CONVERT(VARCHAR, @dDate, 103) + ' ' + LTRIM(STUFF(SUBSTRING(CONVERT(VARCHAR, @dDate, 109), 13, 14), 9, 4, ' '))
Thanks!
P
There is in SQL2012...
Before that,...
November 21, 2012 at 3:34 am
Nikhi123 (11/20/2012)
I have a number of stored procedures used for reporting and whenever we run these reports it slows down the entire database.
Will optimizing the stored procedures improve the performance...
November 21, 2012 at 3:17 am
Viewing 15 posts - 871 through 885 (of 2,894 total)