Viewing 15 posts - 5,056 through 5,070 (of 6,041 total)
CptCrusty1 (10/18/2012)
Ok... We interviewed 2 candidates that seemed to have plenty of exp. C1 had 17 years of verifiable exp, checked his references, etc. Candidate 2 had FIVE...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 18, 2012 at 9:50 am
SQLRNNR (10/17/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 17, 2012 at 10:13 am
Sqlsavy (10/15/2012)
We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 17, 2012 at 8:53 am
vamsi056 (10/16/2012)
Thanx.. Is there any production DBA, if possible can you/anyone give me a small description regarding all DBA types ..
Accidental DBA: an application or user account that's been granted...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 17, 2012 at 8:40 am
ChrisM@home (10/17/2012)
Eric M Russell (10/15/2012)
select C_RECID, H_RECID from
(
select C.RECID C_RECID, H.RECID H_RECID,
(select count(*)...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 17, 2012 at 7:40 am
Don. (10/13/2012)
Unfortunately neither of those scripts worked as there are multiple identical accountno and lastdate fields. Ideally Id need to filter on the History tables Recid field.
...
...
In my example...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 15, 2012 at 10:26 am
TravisDBA (10/12/2012)
Miles Neale (10/12/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2012 at 2:30 pm
Fortunately where I work we have few corporate or department wide meetings where attendance is required, maybe we'll get that once a month or every three months. There is a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2012 at 7:21 am
Steve Jones - SSC Editor (10/11/2012)
kevin.stevens (10/11/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 11, 2012 at 9:06 am
I guess this infographic (sales pitch actually) makes a few points, but I doubt most of the actual numbers cited.
- The average employee checks their email 36 in an...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 11, 2012 at 7:58 am
Speaking different SQL dialects is no problem for me, I routinely work with about four of them. But beware that Oracle thinks '' is NULL. It may seem like a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2012 at 7:46 am
From SQL Server you can query what accounts and groups are members of roles (particilarly SYSADMIN), but it won't tell you what domain accounts are members of a domain group...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2012 at 9:15 am
SELECT INTO #TEMPTABLE will perform less transaction logging than INSERT INTO #TEMPTABLE, which should be considered when loading 100,000s or millions of rows, but with only 4,000 rows, that aspect...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2012 at 8:41 am
Posers who have recently taken a crash course on SQL Server or memorized answers to questions have trouble putting what little they do know in context. On those occasions where...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2012 at 7:40 am
CptCrusty1 (10/1/2012)
My DBA Vendor indicated that they had to delete indexes before creating primary key's on a table. They created the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2012 at 10:54 am
Viewing 15 posts - 5,056 through 5,070 (of 6,041 total)