91 reputation
3
bio website
location
age
visits member for 2 years, 3 months
seen Oct 2 at 16:56

Apr
25
comment Parking Lot table for employees
@miracle173, as an example, a left outer join could be used to join a "numbers table" (for the 20 parking rows) to the parking lot table as described by Max and Justin above. This might be one unusual way to do it Sql Fiddle.
May
24
comment Exporting database Oracle 7.3 on Windows NT 3.51
Wow, it's been about 18 years since I've been near a server like that. Is this syntax more helpful? EXP73.EXE USERNAME/PASSWORD@INSTANCE FILE=OUTFILE.DMP FULL=Y LOG=LOGFILE.LOG
Jan
11
comment WSUS for SQL server patching
Two interesting answers, adding to Aaron's answer: I wouldn't use WSUS for updating a SQL Server that is rev-locked by a 3rd party vendor application thus breaking the app's support agreement, or for updating a server with the WSUS database on it. However, I would consider it for a small db server in a dmz.
Sep
21
comment How do I monitor which Windows user is logging in as SA?
Great point Aaron, and sys.dm_exec_sessions is four times faster than master..sysprocesses (19 msec instead of 77 msec), I've edited the snmp trap query above.