Viewing 15 posts - 5,176 through 5,190 (of 6,041 total)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 16, 2012 at 10:01 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 16, 2012 at 7:41 am
Henrico Bekker (4/12/2012)
When I used to interview someone, I would ask one unanswerable question
I've done it as well... "how do you detach a Log Shipped tempdb that is in Read...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 13, 2012 at 7:39 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 13, 2012 at 7:01 am
sqldba_newbie (4/12/2012)
Eric M Russell (4/12/2012)
sqldba_newbie (4/11/2012)
Eric M Russell (4/10/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 12, 2012 at 10:04 am
sqldba_newbie (4/11/2012)
Eric M Russell (4/10/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 12, 2012 at 7:20 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 11, 2012 at 9:23 am
ssssqlguy (4/9/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 10, 2012 at 1:21 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 10, 2012 at 12:40 pm
rummings (4/9/2012)
the higher ups are super stingy with disk space.... we have to squeeze out all we can to run the system.
Before deciding to shrink down the database, do some...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 10, 2012 at 11:52 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 10, 2012 at 7:26 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 9, 2012 at 2:20 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 9, 2012 at 2:05 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 9, 2012 at 9:29 am
aaron.reese (4/3/2012)
...
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 9, 2012 at 7:29 am
Viewing 15 posts - 5,176 through 5,190 (of 6,041 total)