I will add that you should not rely on "autogrowth" to manage your database growing/sizing. "autogrowth" should be used as a last resort for growing your database so the...

[USER\SQLEXPRESS]

Is that really the instance name? I would verify that first.

Is she trying to connect remotely, or logged into the box? Has she tried to connect locally on...

I wrote this routine to be used only in the DEV environment and scheduled it as a job. It will grant execute for functions and sprocs based on the...

Depending on your organizational structure, I would also mention that it really isn't their decision to make; it's more of a business decision.

Does the business know of

1. the existence...

McAfee Enterprise runs fine on our servers.

512 GB of RAM

We use the exclusions mentioned above and do not have contention with the memory scan.

Steve

http://support.microsoft.com/kb/283878

http://databases.about.com/od/specificproducts/a/normalization.htm

Universities devote a few weeks a semester of a database class to normalization, so it will take you some time to learn and practice. At least...

I'm glad it's working for you. It's difficult making changes when systems are rolled into production and working.

I would add that it probably is a best practice to...

I have a (4) two node AlwaysOn clusters, it takes a minute to get your head around it and I still struggle a little however your asking about disks. I...

No, only 1 quorum per cluster.

My jobs are set up just about exactly as you have set up your jobs. I think it's the best solution and ran this by a MS Specialist who...

More homework questions, I imagine.

I have upgraded/migrated at least 300 databases from SQL 2000 to SQL 2005 and SQL 2005 to SQL2012 and never experienced the issue that you mentioned.

My technique is to take...

We are using "Always On" and only take backups on one server; actually the primary server.

There isn't a need to take backups of both servers because if the Primary server...

swwg69 (9/5/2013)

---

The hardest part for a non-trivial database is making sure the tables are built in the correct order to maintain RI. You can script out the table structures...

UltraEdit is awesome! It works great on large files making work a bit more simpler.

I wanted to add, that I use it to verify TDE (transparent data encryption), too.

Steve