jasona.work (6/10/2015)

---

So, yesterday afternoon I get out to my car to head home, and there's a bloody 16+ inch long crack in the windshield. Goes from the edge of...

Things to look at:

What jobs/processes are running before/during the time out?

How is the user connecting? Remotely from home or another location? RDP from the same location? Direct...

Could be someone "doing something they shouldn't". We caught someone on a dev server dropping logins and other things because "they didn't think they were needed anymore". The...

briancampbellmcad (5/18/2015)

---

This is not something I will be doing on a regular basis as I am just filling in for a DBA on sick-leave. I just need to get irate...

You are quite skilled as a DBA/Developer/whatever and that is what the job requirement stated. However, we really need someone that can maintain computers. How do you feel...

Depends. This is where you need to set up a test database/tables and try all your methods out. You can us smaller amounts of data for testing, but...

This will get you started....

Using SSMS, find the database you want to import the spreadsheet into. Right click on the database and choose: Tasks>Import Data. Follow the wizard...

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

Does the table have a FOR INSERT trigger on it? If so, the trigger has to fire for every row. Disable the trigger while the load is being...

My thoughts....if the user has permissions to connect to the database and has db_datareader/db_datawriter; the next things I would check are:

1. the permissions on the table itself. have they...

With all of these statements...

ISNULL(NO_OF_SAMPLE_DAYS,'NO Backup Job Ran'), '',

td = ISNULL(BackupSizeMB,'NO Data Found'), '',

td = ISNULL(TotalDBSpaceMB,'NO Data Found'), '',

td = ISNULL(DataGrowth,'NO Data Found'), '',

td = ISNULL(LogGrowth,'NO Data Found'), '',

Take the...

It really sounds like the corruption happened during the scrubbing.

If I understand correctly:

You backed up/restored the database from SS2000 to SS2005.

That should have done an upgrade of the database.

Then...

I would also add validation to your procedure. For example, what if you run this:

EXEC MasterInsertUpdateDelete @firstname = 'John', @lastname = 'Smith', @city = 'Denver', @StatementType = 'Delete'

Your...

jonathan.crawford (4/28/2015)

---

SQLBill (4/27/2015)

---

Lynn Pettis (4/24/2015)

---

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make it,...

I think it's silly....why would I want another install of SQL Server on one of my SQL Server boxes? Either allow it to be 'centralized' and/or give me an...