1,829 reputation
320
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years, 3 months
seen yesterday
coder & programmer of many defunct languages...

Dec
12
suggested suggested edit on TDP setup for SQL Server databases
Dec
11
comment How to design a table that each rows have 5K boolean attributes?
how commonly will all/each attributes be used (set) within each row? If a fairly large percentage of the attributes are not used (or alternatively, not set) most of the time, you may be better off with a sparser approach (like EAV, as mentioned above).
Dec
2
comment SQL Server Standard High Availability (HA) with two nodes
Log Shipping is another option.
Nov
27
comment Display a List of used Table and Column
Weird, this sounds almost exactly like something that I implemented for a customer a couple of years ago. The numbers are dead on.
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.