Viewing 15 posts - 16 through 30 (of 458 total)
Greg Edwards-268690 (6/4/2013)
SQLRNNR (6/4/2013)
Lowell (6/4/2013)
GabyYYZ (6/4/2013)
SQLRNNR (6/4/2013)
GabyYYZ (6/4/2013)
Back...what I miss?We are busy writing the DR plan for SSC and RedGate. Nothing big.
Ahhh...in our company, we consider naivete and blissful...
June 4, 2013 at 2:29 pm
SQLRNNR (6/4/2013)
GabyYYZ (6/4/2013)
Back...what I miss?We are busy writing the DR plan for SSC and RedGate. Nothing big.
Ahhh...in our company, we consider naivete and blissful ignorance as sound DR practices....
June 4, 2013 at 11:41 am
Jeff Moden (5/15/2013)
June 4, 2013 at 9:36 am
GilaMonster (5/28/2013)
No reason (and dropping the index will invalidate any plans which used it)
Thanks very much!
May 28, 2013 at 11:40 am
GilaMonster (5/28/2013)
Depends.Are those indexes enforcing uniqueness?
Does the period over which those have been tracked cover an entire business cycle (including month end and year end if applicable)?
Oops, for the first...
May 28, 2013 at 10:05 am
Stefan Krzywicki (3/15/2012)
GabyYYZ (3/15/2012)
March 15, 2012 at 9:37 am
Is it too much to ask that a DBA candidate, who says he has 10 years experience with SQL Server, know what a primary key is, or know the difference...
March 15, 2012 at 8:47 am
When operating systems and programs die, they crash. When database servers die, they throw-up, do a swan dive into oblivion, and make you cry like a 5-year-old for the...
November 21, 2011 at 1:12 pm
Ninja's_RGR'us (11/18/2011)
GabyYYZ (11/18/2011)
Note to self: Turn off actual execution plan option before running a million counter loop.Oh WHY?, doesn't it crashe somewhere :-D.
I saw what I had done, killed...
November 18, 2011 at 9:34 am
Note to self: Turn off actual execution plan option before running a million counter loop.
November 18, 2011 at 9:27 am
Database Administrator, or DBA (n): 1. A person responsible for administering software that manages data people don't know what to do with. 2. An expletive used by various departments...
October 3, 2011 at 9:29 am
Stefan Krzywicki (9/11/2011)
CELKO (9/11/2011)
While temp tables in the Sybase/SQL Server model can be indexed, constrained, etc. nobody does.Speak for yourself. I do and I know others who do.
Ditto...I've also...
September 14, 2011 at 8:13 am
anthony.green (8/19/2011)
we had a similar situation with biztalk where it issued a dtc connection, became -2 and killing...
August 23, 2011 at 9:06 am
Jayanth_Kurup (8/17/2011)
http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspxNice Read on the issue your trying to fix
Hi Jayanth, I'm afraid this may be necessary if the code fix for .NET doesn't help.
Currently we get anywhere from 0...
August 17, 2011 at 9:07 am
Viewing 15 posts - 16 through 30 (of 458 total)