1,703 reputation
319
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years
seen Apr 16 at 16:06
coder & programmer of many defunct languages...

Nov
15
comment Limit connection rights on SQL Server
Unfortunately, Host_Name() is not secure and can be easily spoofed by just about anyone. It's particularly easy to do from Excel. Your @IPAddress would be a lot more reliable for this purpose.
Nov
5
comment What permissions are necessary for truncating a table?
TRUNCATE TABLE is DDL, not DML.
Oct
19
awarded  Benefactor
Oct
19
awarded  Scholar
Oct
19
accepted What is Required to use Oracle Performance Manager to monitor SQL Server?
Oct
17
suggested suggested edit on SQL Azure not using available memory
Oct
15
comment What is Required to use Oracle Performance Manager to monitor SQL Server?
@gsiems Thanks, I'll give it a look.
Oct
13
awarded  Student
Oct
13
awarded  Promoter
Oct
11
comment Are de-normalised tables preferred in any aspect of a project?
@JonofAllTrades Yeah that is weird. There's nothing wrong with this answer other than the y-z key-switch. Which is obviously a typo problem and easily fixed.
Oct
11
comment Disk usage spikes: good, bad or indifferent?
This is normal. Almost every SQL Server I've worked on that did not have serious problems looked like this. I'm pretty sure that this is checkpointing as @TomTom says.
Oct
11
asked What is Required to use Oracle Performance Manager to monitor SQL Server?
Oct
6
revised How to DROP multiple tables from databases?
corrected "delete" to "drop"
Oct
6
suggested suggested edit on How to DROP multiple tables from databases?
Oct
1
comment If a transaction is “committed” , is it then saved for sure?
@Giosco: It cannot. "committed" means that it is in the database's log file. The only way to lose it after that is to either 1) lose the log file before it is also saved to the data file, or 2) lose both the log file and the data file, or 3) human error. Note that (3) is usually the likeliest.
Sep
19
comment Dynamic Joining Across Databases
Unless the number of different possible databases is small, Dynamic SQL is probably your best bet.
Sep
18
answered How to know the user doing a delete action on an audit table, when using a shared login?
Sep
18
comment How to know the user doing a delete action on an audit table, when using a shared login?
Fair enough, I should have read your question more thoroughly. I think I have an answer for this, but I may not be able to post it until late tonight.
Sep
9
comment Plan cache memory: parameterized SQL vs stored procedures
The number one reason that I prefer stored procedures is their security control and options that are far superior to any other approach that I know of with SQL Server.
Jul
13
comment Check existence with EXISTS outperform COUNT! … Not?
Heh, you know, I have t-shirt with my username on it, but the first four letters crossed out ("<strike>RBAR</strike>RYYOUNG").