Viewing 15 posts - 1 through 15 (of 31 total)
NOLOCK is a useful evil on high volume systems. In cases where you're looking at generics or structure this can be a very useful tool which can stop deadlocks. It...
April 25, 2015 at 1:05 am
Great article. I do have a very small point in that all phone numbers can't be BIGINT for the reason that there are some international numbers which require the operator...
May 19, 2014 at 11:35 am
It appears that this calculation can't handle repeating decimals (standard rational numbers like .3333 (1/3)). If this is true it will have problems with the algebraic numbers like SQRT(11) et.al....
April 29, 2014 at 11:04 am
Nifty!
As a rule, I need to know where the columns are being used. Since the primary server has over 180000 objects on it of many different types, I need to...
April 23, 2014 at 4:55 pm
Dave Vroman (6/20/2013)
April 16, 2014 at 9:22 am
I'm curious if you might want to fold this script into yours. I've used one like this for years to search for strings in the database objects.
-- Search Stored Procedures...
April 9, 2014 at 1:44 pm
Because I always use aliases, for entirely different reasons having to do with readability and speed of programming, I have never run into this one. What a surprise. Thanks Much.
February 24, 2014 at 2:04 pm
robert.wood-982247 (1/6/2014)
It is a pleasure to read such a clear, well formatted script. Would that all developers laid out their code like this as maintenance would be so much easier.
[p]Agreed...
January 6, 2014 at 12:43 pm
What you're looking for is "Permissions (Database Engine)". The operative word is GRANT permissions. You can "not" grant permissions to do just about anything. You can grant permission to SELECT...
November 6, 2013 at 12:22 pm
Superb. Love it. I added a couple of columns because i'm constantly doing JOINs and PROCEDUREs.
EXEC(
'SELECT b.Name AS ColumnStart,
'','' + b.Name AS ColumnNext,
''['' +...
October 10, 2013 at 4:25 pm
What you're seeing is the CREATE statement which created the SP, not a new CREATE SP.
October 3, 2013 at 1:40 pm
Later version - Same Error. The answer for me was to create a configuration file for the SSIS package. The problem was that Microsoft is being security conscious. Also, I...
July 25, 2013 at 10:34 am
Superb development tool! I'd hate to need to work around this in live code though.
July 8, 2013 at 11:39 am
I didn't do that portion of the requirement. I only got the results. I wrote their encryption package and their encryption interface fully compatible with classic ASP, VB.NET, ASP.NET and...
June 20, 2013 at 10:20 am
[p]Because of PCI compliance, both xp_cmdshell and db_sendmail are disabled on our database servers. I needed to get some of my tasks to send email to me so I used...
June 20, 2013 at 9:28 am
Viewing 15 posts - 1 through 15 (of 31 total)