Viewing 15 posts - 4,906 through 4,920 (of 6,041 total)
WHERE A.Pid = 9
AND ( Isnull(A.ID, 0) <> Isnull(V.ID, 0)
...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2013 at 3:41 pm
Ultimately I think it's easier to stick to as few platforms as possible to allow your staff to build expertise in optimizing their code and configurations for a platform.
It...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2013 at 7:06 am
sjs-36273 (5/14/2013)
GilaMonster (3/4/2012)
kilkenny (2/27/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 14, 2013 at 3:00 pm
jpSQLDude (5/14/2013)
This is a production server, so I can't make *any* changes like installing software, not even Who is Active.
But what I can do...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 14, 2013 at 2:44 pm
Someone previously provided methods to return what sessions are currently accessing the database and what execution plans consume the most read and writes.
Something else that might be useful is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 14, 2013 at 8:03 am
Identify a specific INSERT or UPDATE statement is believed to benefit from this cache flushing. It's possible that the actual I/O isn't slow, but rather the execution plan is stale....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 8, 2013 at 11:45 am
mah_j (5/4/2013)
I want to archive the data of a 400G table,what is the best way of archiving?
My table has a clustered index on 2 fields (int,datetime).We just do select on...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 6, 2013 at 12:32 pm
kellyascent (5/5/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 6, 2013 at 12:01 pm
chrisolivierrsa (5/3/2013)
I am pretty sure if you stop and start the service, it stops the rollback operation, after that, you can drop the table removing the keep history button, since...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 3, 2013 at 7:40 am
Ryan007 (4/30/2013)
We are running one job which runs SELECT query from a view from another linked server. We are getting blocking in the linked server where SELECT query from View...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 2, 2013 at 10:48 am
Jon.Morisi (4/30/2013)
I have a system with a lot of blocking. From the last occurrence I found a statistics update causing a lot of the blocking:
SELECT StatMan([SC0], [SC1], [SC2], [SC3],...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 2, 2013 at 7:43 am
RE: SQL career advice
If your current job is secure, then I'd suggest staying put for at last a few months. Install SQL Server 2012 Developer Edition, and spend your flex...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 2, 2013 at 7:15 am
There are facts and then there is narrative. Politicians, the media, and activists are more concerned with the narrative, because that's what gets their point across to the audience. However,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2013 at 10:55 am
TravisDBA (4/30/2013)
Eric M Russell (4/30/2013)
TravisDBA (4/30/2013)
Eric M Russell (4/30/2013)
mosborne (4/30/2013)
However, without people skills, that high-priced consulting career will remain tantelizingly beyond their reach.
I have only two words in response...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2013 at 9:28 am
TravisDBA (4/30/2013)
Eric M Russell (4/30/2013)
mosborne (4/30/2013)
However, without people skills, that high-priced consulting career will remain tantelizingly beyond their reach.
I have only two words in response to this rather audacious...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2013 at 8:58 am
Viewing 15 posts - 4,906 through 4,920 (of 6,041 total)