Viewing 15 posts - 13,711 through 13,725 (of 22,213 total)
kmaida (1/3/2011)
Sorry, I feel like a complete novice, but how do I check to see if there's an ALTER DATABASE statement being run on the db thru a job?Thanks!
You can...
January 3, 2011 at 8:57 pm
Yeah, Craig nailed it. The RID is created in order to give the heap table a method of finding records.
There is a way to see the value of the RID,...
January 3, 2011 at 8:52 pm
Steve Jones - SSC Editor (1/3/2011)
January 3, 2011 at 9:23 am
For this type of change, or any other, first, backup the database.
I'd create your new table, blank, with a different name (mytable_new). Then migrate the data into it from the...
January 3, 2011 at 8:55 am
OH!
Silly me.
That's harder. In general, how well did you do on reactive support? How well did you do being proactive, eliminating reactive support calls (meaning, if you ran out of...
January 3, 2011 at 7:08 am
Also if you're just adding single column indexes all over the place, you might be hurting yourself without knowing it. Are you adding the indexes based on the execution plans...
January 3, 2011 at 6:47 am
there is no perfect mechanism for this. It's far too easy to have a proc that is only executed once a year or less that won't show up on any...
January 3, 2011 at 6:43 am
It sounds dangerously like a catch-all query, with 10-50 different parameters, any of which can be passed at any time and you have to write a query that deals with...
January 3, 2011 at 6:40 am
BSavoie (1/2/2011)
Perfect, that looks like exactly what I need. The fact that it exists must mean that it's not THAT bad an idea. 🙂Thanks!
Just be careful about transactions &...
January 3, 2011 at 6:34 am
As fast as possible.
OK, maybe not. Usually it's initially set by the business, not by the DBA's. There's going to be a threshold above which your users begin to complain....
January 3, 2011 at 6:30 am
First thing that comes to mind is that setting the ANSI_PADDING value within the procedure or the function will cause recompiles. So that could affect you. How long does the...
January 3, 2011 at 6:25 am
RBarryYoung (1/1/2011)
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.Congrats Gus! (Man, everyone is passing me!)
BARRY! Great...
January 3, 2011 at 6:13 am
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Excellent job! Congratulations.
December 30, 2010 at 8:33 am
iamsam.sandeep (12/29/2010)
December 30, 2010 at 6:10 am
Viewing 15 posts - 13,711 through 13,725 (of 22,213 total)