It's up and down. I see varying numbers of posts each day.

I have edited the question. I'll award back points to this time now.

I think I worked for this company 🙂

You should put your comments inside the procedure.

Create procedure MyProc

@param 1 int

as

/*

Name MyProc

Description: what my proc does

Changes:

20090922 sj Created proc

*/

begin

select @param

return

SQL Express by default doesn't allow remote connections. Enable that in the server config or with sp_configure.

What are the log backup sizes? Please use commas and format it a little better.

The log could be bigger than the data, but usually isn't. Likely you had some event...

I'd agree with Google. I find things that so many newbies don't seem to find. Knowing how the product works, and having had to work with Google to get answers...

First, you never execute anything locally. Even the connection to an instance on your local machine is a remote connection to the server service. SSMS isn't SQL Server. Every single...

You are confused. You do not log onto Integration Services. SSIS is a part of the SQL Server instance. It has it's own service, but a sysadmin logs onto the...

I guess I wouldn't be working there. Or I'd have them pay me $5xworking-days-in-a-year more 🙂

They are the exact same codebase, with different features/restrictions.

EE servers are usually larger, so it might appear to run faster, and there might be features that allow things to perform...

I wouldn't expect comments outside of a proc to show up. I might run a lot of stuff in a window, and wouldn't necessarily want other items in a batch...

You'll only be able to get the the point in time since the last transaction log backup if you can back up the tail of the log. That's what's in...

You don't log onto SSIS to access the packages. The packages are typically stored in msdb, though they may be in the file system. The sysadmin can access anything on...

Don't know. That sounds like employment for life! Might be THE place to work.