fatfingered an enter key; answer is below

one of the things i slapped together is a procedure i can call on demand, which grabs whatever is running via sp_whoisactive every 2 seconds, for speedy adhoc monitoring.

it creates...

when it happens, can you run sp_whoisactive or at least sp_who2 and see if there is blocking? I'd look to one instance locking a core table, and all the other...

i would do it similar to the way Luis is: remove ALL leading zeros by converting to decimal, and then add as many zeros as needed to make it a...

in South Florida, most of the SQL related groups are using meetup to organize and publish when there next event is:

this is my local group, for example:

http://www.meetup.com/South-Florida-SQL-Server-User-Group/; Diana Betancourt...

i think you have to set the 64bitruntime to false, right? otherwise no debugging/no data viewers?

i think this is an application error, that has nothing to do with the data; might have something to do with permissions, though.

how are you going into pwd destination? could...

data on insert is probably going to be an insert trigger on the table itself.

Since database mail...

it depends on what you mean by "monitor"

DDL changes; database scoped trigger, or maybe an extended event

data changes: trigger on the table itself, or maybe an extended event

Access(SELECT )...

i use this to enumerate all the members that belong to groups that have been granted access from AD:

i've found that some groups cannot be enumerated int he cases where...

excuse the neophyte question,...

as far as i know, filezilla, specifically, cannot be called from a command line or automated; it's a GUI tool;

i've used winscp.exe and psftp.exe (putty sftp) with script taskes/command executes;

i...

I've seen something similar, where a csv file was renamed to have an xls extension...so the file was not truely xls, so it could not be opened.

find the original file,...

a maintenance plan tends to use a shot gun approach: rebuild all indexes, regardless of whether they need to be rebuilt or not.

you are probably at that tipping point where...

there are a bunch of settings you can do in MySQL to improve the loading of flat files; back when i loaded that huge Ashley Madison dump for fun, i...