Viewing 15 posts - 13,246 through 13,260 (of 22,213 total)
Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT
statements.
But not in JOIN criteria? No, no way. The basic rule for...
February 15, 2011 at 5:39 am
sqldba_icon (2/14/2011)
Grant Fritchey (2/14/2011)
As far as b)...
February 14, 2011 at 3:25 pm
I'm not that familiar with it. Sorry. It really isn't used much.
February 14, 2011 at 3:23 pm
From a performance standpoint, if you're moving more data, it's slower by that amount, but we're talking trivia most of the time. I just try to find out what the...
February 14, 2011 at 1:47 pm
Anna_SQL (2/14/2011)
I downloaded an enterprise version of sql 2008 and I will install it on a testing machine.
This machine will be...
February 14, 2011 at 1:42 pm
For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.
As far as b) goes, if the...
February 14, 2011 at 1:40 pm
Brandie Tarvin (2/14/2011)
Grant Fritchey (2/14/2011)
Roy Ernest (2/14/2011)
GilaMonster (2/14/2011)
Craig Farrell (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and...
February 14, 2011 at 12:48 pm
mw112009 (2/14/2011)
After about 2 hours the result was the same. When I logged in I did not see SSMS running.Why did it shut down on it's own ?
That, I don't...
February 14, 2011 at 12:27 pm
Crud. I mean restore. Sorry.
February 14, 2011 at 12:06 pm
Grant Fritchey (2/14/2011)
mw112009 (2/14/2011)
Question: Can...
February 14, 2011 at 12:06 pm
Roy Ernest (2/14/2011)
GilaMonster (2/14/2011)
Craig Farrell (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and going to work in...
February 14, 2011 at 12:06 pm
Raghavender (2/14/2011)
if you think this will encourage the fake guys, np,...
February 14, 2011 at 12:04 pm
Check the schedule on the job. It is probably disabled as well. Instead of disabling the job, if you disable/renable the schedule on the job I think you'l run into...
February 14, 2011 at 11:10 am
mw112009 (2/14/2011)
Question: Can we run...
February 14, 2011 at 10:32 am
SanDroid (2/14/2011)
Grant Fritchey (2/14/2011)
paul.knibbs (2/14/2011)
February 14, 2011 at 10:31 am
Viewing 15 posts - 13,246 through 13,260 (of 22,213 total)