Viewing 15 posts - 16 through 30 (of 74 total)
Thanks for the article, and for getting us thinking about code performance and readability.
I was struck by something you said:
By doing everything in a single statement,...
March 20, 2018 at 2:53 am
FYI, I have set up a GitHub repository for SQLVer at https://github.com/DavidRueter/SQLVer
Please use the GitHub repository, as the SourceForge repository is being deprecated.<br
January 17, 2017 at 11:30 am
BTW is that "IF @@OPTIONS IS NULL" trick documented anywhere along with FMTONLY ON? If not, how did you discover it?
To my knowledge, @@OPTIONS = NULL is not explicitly documented,...
June 25, 2015 at 1:40 pm
Do not use this feature. This feature has been replaced by sp_describe_first_result_set (Transact-SQL), sp_describe_undeclared_parameters (Transact-SQL), sys.dm_exec_describe_first_result_set (Transact-SQL), and sys.dm_exec_describe_first_result_set_for_object (Transact-SQL).
But don't you see...it is the Microsoft tools such as...
June 25, 2015 at 9:44 am
I agree with Erik's Erland's suggestion #3 too. Having the user create the stored procedure in a different schema sounds to be the way to go. I'll...
April 2, 2015 at 1:07 pm
Thanks, Eric. So it sounds like there is not a way to have ownership of created objects automatically assigned to the user that creates them. That's too bad...and...
April 2, 2015 at 12:15 pm
I do have some code to watch for and log changes to SQLAgent job definitions: that works well, though it requires creation of a sqlver schema in the system...
January 22, 2015 at 7:39 pm
Great! If it is OK with you, I'll see about using your approach in SQLVer: I'm happy to have all the help and improvements I can get.
Thanks again.
January 22, 2015 at 9:29 am
Richard, thanks for the comment. Just to clarify, sqlver.sputilPrintString does in fact print the entire string. The issue is that as does the code you posted, multiple PRINT...
January 22, 2015 at 9:21 am
🙂 You can of course remove the PRINT statement if you want SQlVer to run in "stealth" mode.
January 22, 2015 at 8:25 am
If you run into errors when creating spShowSlowQueries, please try commenting out the creation of spShowSlowQueries.
While useful, that procedure isn't really needed for the core version tracking functionality.
January 22, 2015 at 8:14 am
Ah, good points: Yes, SQLVer at present doesn't track renames: that is something I need to fix. Originally (in SQL 2005) renames did not fire a DDL...
January 22, 2015 at 8:11 am
Hi, all. One other neat feature that SQLVer provides is a quick and easy way to search through stored procedure and function source code for a specified string. ...
January 21, 2015 at 10:30 pm
FYI, I actually have two variants of SQLDOM--one that creates permanent objects in the database (i.e the "persist" version), and one that creates only temporary objects.
The article really deals with...
December 31, 2014 at 12:44 pm
for the row DEID 8
the OpenTagStartPos is 82 and the CloseTagEndPos is 53.
Is this a typo?
Yes..a typo. That row actually returns a br for the tag (not a b),...
December 29, 2014 at 1:49 pm
Viewing 15 posts - 16 through 30 (of 74 total)