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...

Data Reconciliation can involve things like identifying the uniqueness, completeness, and validity of records. That logic may not be part of the injest, but rather a process that analyzes and...

I read the 2nd edition of this book several years back. It's not about how to use BI tools at all, but rather more about how to apply data mining...

As a result of updates, heap (nonclustered) tables can accumulate a type of fragmentation called "Forwarded Records". If the updated row incrases in length and SQL Server can't fit it...

Regarding the issue of how to implement a rollback when deploying DDL/DML scripts, I'd prefer to deploy major changes (altering or bulk updating large tables) at an off hour with...