Viewing 14 posts - 1 through 14 (of 14 total)
I've tested DBCC DROPCLEANBUFFERS
and it seems to do exactly what I want.
Cheers.
August 27, 2003 at 5:06 pm
I think, in genral, you can't use a variable anywhere where it would effect the query plan, so col names and tbale names are out.
but if your...
March 26, 2003 at 9:27 pm
quote:
More or less like an illusionist, get them to look at one hand while the other is busy making magic.
February 28, 2003 at 1:41 pm
quote:
Also, consider if you use non-sensical names, the people you punish most are your developers. The main reason we have variables, functions,...
February 28, 2003 at 1:31 pm
quote:
If you do this, you're intentionally limiting the performance of your app, are you not? You're going to place additional load on...
February 28, 2003 at 1:19 am
quote:
Um, please tell me what the name of your product will be or is so I can avoid it like the plague.....no...
February 28, 2003 at 1:00 am
quote:
...using INFORMATION_SCHEDMA view.
I had to do this a while ago and remember it seemed...
February 24, 2003 at 7:08 pm
I've thought about everyones input and have decided to take the following approach:
1)Obfuscate the SQL, removing all semantic clues including:
- Comments
- formating
- meaningful table, column, view names
...
February 24, 2003 at 1:23 am
quote:
Ultimately thou you will find if they want it bad enough they will find a way to get the info.
February 10, 2003 at 6:16 pm
quote:
"exec master.dbo.xp_trace_enumqueuehandles ""SELECT * FROM ::fn_trace_getinfo(default)" to determine if profiler is running.
Gregory Larsen, DBA
February 6, 2003 at 4:09 pm
quote:
If you have exe's that issues SQL commands, profiler still might be a tool someone could use to determine a sequence of...
February 6, 2003 at 3:22 pm
quote:
About the best you can do is use the WITH ENCRYPTION option on the CREATE PROCEDURE statement. However, I know that procs...
February 6, 2003 at 3:12 pm
quote:
If possible can you post the actual rule(s) how it to calculated the checkdigit. I think some posters will be able to...
January 22, 2003 at 4:09 pm
Have you considered using a (different) login account for those adhoc queries that has very limited access? i.e Only select permission on the tables you want to let them query.
A...
January 21, 2003 at 9:43 pm
Viewing 14 posts - 1 through 14 (of 14 total)