Before killing the process that had been running for 7 hours, did you check see if it was was in a blocked state, what was blocking it, and wether it...

In the past most data orginated in a database because it was deemed important enough by users that they entered it manually (patient charts, student records, inventory, etc.).

Today, the...

Henrico Bekker (4/12/2012)

---

I've done it as well... "how do you detach a Log Shipped tempdb that is in Read...

Who wouldn't want six weeks of vacation, the option to work remotely from home every day, a personal assistant, and a $120,000 salary?

However, if applicants were to write a description...

sqldba_newbie (4/12/2012)

---

Eric M Russell (4/12/2012)

---

sqldba_newbie (4/11/2012)

---

Eric M Russell (4/10/2012)

---

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating...

sqldba_newbie (4/11/2012)

---

Eric M Russell (4/10/2012)

---

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating or grabbing a copy...

I would not be anywhere near as knowledgeable, not at the level I am today, were it not for participating in discussion forums like SQLServerCentral. There are other non-IT things...

ssssqlguy (4/9/2012)

---

You can do what karamaswamy above mentioned; or you can also create an indexed view against these tables (assuming their schema is the same). This way, your queries...

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating or grabbing a copy of the 3 remote...

Before deciding to shrink down the database, do some...

As a DBA who has just inherited a database with a lot of objects and little production control process in place, another thing you'll want to do is confirm that...

You may have already been looking at something like this, but the following will query table usage statistics:

select

t.name

,user_seeks

,user_scans

,user_lookups

,user_updates

,last_user_seek

,last_user_scan

,last_user_lookup

,last_user_update

from

sys.dm_db_index_usage_stats i JOIN

sys.tables t ON (t.object_id = i.object_id)

order by ( user_seeks + user_scans...

In addition to checking database scripts into source control, any deployment to QA or Production should be tracked in a change tracking system like TFS or Mercury Quality Center. That...

A login can inherit membership in the SYSADMIN role by membership in a windows domain group. You can confirm if a login account has been explicitly granted (or has inherited...

aaron.reese (4/3/2012)

---

The columns of interest are AccountID,UpdateDate, SubBal-A, SubBal-B,...SubBal-K

...

Currently the table has an index on AccountID only and an index on UpdateDate only.

both indexes are non-clustered

...

The estimated query plan indicates...