Viewing 15 posts - 16,096 through 16,110 (of 39,824 total)
You are doing a number of things to render the indexes useless. The <> will tend to force SQL to consider a table scan because it has to look at...
May 10, 2011 at 9:38 pm
Are you looking for something not covered by SQL Agent?
May 10, 2011 at 9:34 pm
Kimberly's advice on the topic is to go for 8GB growths to keep the VLFs down if you have a large log.
What is your log size now? And is it...
May 10, 2011 at 3:39 pm
jcrawf02 (5/10/2011)
bitbucket-25253 (5/10/2011)
jcrawf02You attending or presenting ?
SQLSaturday #75 - Columbus 2011 on Jun 11, 2011
As much as I'd like to try presenting, I'll just be over-committing myself (again), so I'm...
May 10, 2011 at 1:51 pm
To log on as the service account, note which account is running Agent in the configuration manager and then log into the server with that account. You might need a...
May 10, 2011 at 1:50 pm
Jeff Moden (5/10/2011)
Steve Jones - SSC Editor (5/10/2011)
May 10, 2011 at 12:21 pm
Brandie Tarvin (5/10/2011)
Just submitted a QOTD. We'll see how many people tell me I'm wrong and why.
It will be you and me both that are wrong if it goes out...
May 10, 2011 at 11:21 am
Doh! Voted for Paul's Sessions.
May 10, 2011 at 10:58 am
If you are working with AD permissions and groups, you don't need mixed mode. Windows Auth only is sufficient.
May 10, 2011 at 10:53 am
Sorry, on the bootcamps. I haven't done a bootcamp, but I would guess it's an intensive, quick cramming on all the various features/facets of the product. I'd take lots of...
May 10, 2011 at 10:44 am
The MCSE gives you more opportunity, in my mind, if you need a job that might be part DBA, part Sysadmin. But only if you want to get stuck doing...
May 10, 2011 at 10:42 am
Done. I've been thinking about something similar and finally got it implemented.
May 10, 2011 at 10:34 am
The process should be putting packages in a standard location, then assigning windows permissions to the accounts that run the package. If this is the SQL Agent service account, there...
May 10, 2011 at 10:11 am
A few scenarios. I have reached the 2b limit before and needed to reseed data. The table held a rolling 50-100k rows, but lots of inserts every day (and deletes).
You...
May 10, 2011 at 10:09 am
stormsentinelcammy (5/10/2011)
May 10, 2011 at 9:55 am
Viewing 15 posts - 16,096 through 16,110 (of 39,824 total)