Viewing 15 posts - 16 through 30 (of 105 total)
Nice article Ed,
However, the first example with the Stored Procedure, I'd like it more the other way around, CREATE if it does not exist and then ALTER. That way...
November 17, 2015 at 1:37 am
Carlo Romagnano (11/4/2015)
Because of lacking of batch separator "GO".
If you run the script no procedure is...
November 9, 2015 at 8:41 am
raulggonzalez (3/24/2015)eric.notheisen (3/23/2015)Published in March 2015 -Needs closingDoes it mean the article is no longer required?
eric.notheisen (3/23/2015)Published in March 2015 -Needs closing
Does it mean the article is no longer required?
Hello again, I found this one http://www.sqlservercentral.com/articles/Replication/122402/ by yourself, so I guess...
March 24, 2015 at 5:07 am
I must have skipped this, because I didn't see published anything on that topic this...
March 24, 2015 at 4:17 am
Hany Helmy (3/11/2015)
raulggonzalez (3/10/2015)Sean Lange (3/10/2015)
Sean Lange (3/10/2015)
Thanx 4 sharing the script, but if u have a common SQL login that is being used by an application accessed by many users, then...
March 11, 2015 at 3:13 am
Ed Wagner (3/10/2015)
Sean Lange (3/10/2015)raulggonzalez (3/10/2015)Sean Lange (3/10/2015)
I knew of the function to return the login for the current connection, but I thought it was like GETDATE() where you just...
March 10, 2015 at 1:38 pm
March 10, 2015 at 12:07 pm
Ken Grissom-138180 (3/4/2015)
But that raises a question for me.
If we are not to use the TRUSTWORTHY with SA access what about the MSDB? Since Microsoft has...
March 4, 2015 at 1:43 pm
RK Mandava (2/24/2015)good question,here is nice article about that..http://www.brentozar.com/archive/2015/02/dropping-offline-database-sql-server/
RK Mandava (2/24/2015)
here is nice article about that..
read it too, so this was a piece of cake.
February 24, 2015 at 8:58 am
INCREDIBLEmouse (6/5/2014)I see the "myth" is busted for Full model.Is it still un-busted for the other models?
Is it still un-busted for the other models?
Truncate is still a logged operation in the other models.
The myth has been...
February 20, 2015 at 8:43 am
Koen Verbeeck (2/16/2015)Easy question, thanks.Some resources might be appreciated.
Koen Verbeeck (2/16/2015)
Some resources might be appreciated.
February 16, 2015 at 9:00 am
I've run into this problem before, it'd be nice to get all the concepts together. If there's no much rush I can do it.
February 3, 2015 at 4:12 am
Sean Pearce (1/30/2015)https://msdn.microsoft.com/en-us/library/ms179882.aspxSELECT £SELECT $SELECT ¥SELECT €SELECT ?SELECT ?SELECT ?SELECT ?SELECT ?
Sean Pearce (1/30/2015)
That is exactly the point, money and smallmoney data types accept a number of currency symbols and it's good...
January 30, 2015 at 3:45 am
h.tobisch (1/29/2015)this article is a rare example for what i expect of a well-written article.exposure at the beginning, conclusion, references, some reasonable reasoning in the main part.congratulations.
exposure at the beginning, conclusion, references, some reasonable reasoning in the main part.
Thanks!, Since this is...
January 29, 2015 at 1:55 am
DrKiller (12/23/2014)wow what a complex way of doing it.I'm usually just doing this 🙂DECLARE @tmpString VARCHAR(MAX)SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM HeaderSELECT @tmpString
I'm usually just doing this 🙂
DECLARE @tmpString VARCHAR(MAX)
SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header
You opened Pandora's...
December 23, 2014 at 7:56 am