Viewing 15 posts - 28,096 through 28,110 (of 39,804 total)
I'll paraphrase my buddy, Andy, who reminded me of his core tenet a week ago.
Go with the defaults until you have a reason not to.
Normalizing should be a default.
June 25, 2008 at 9:47 am
Great comments and like many of you, I fell into this job. I was a network admin, a CNE in a Novell environment and we got a SQL Server. It...
June 25, 2008 at 9:46 am
Just got back from 3 days of "vacation" at Scout camp with my two little kids. After some bad food, lots of sun, and sleeping on the ground, I need...
June 25, 2008 at 9:32 am
I think this is a great idea, and it's similar to one I've used to email myself DBA reports every day.
xp_sendmail has worked fine for me for years. And very...
June 25, 2008 at 9:05 am
If you read the internals books or dig into BOL, there are pages inside SQL Server that create a map for all allocations. Just as pages have a map of...
June 22, 2008 at 9:45 am
Check out xp_smtp from Gert Drapers. This might do what you need.
June 22, 2008 at 9:36 am
I thought I had read in a blog about changing this with newer servers that have multiple cores. There was some ratio of worker threads to cores that you could...
June 22, 2008 at 9:34 am
Hey, that's me. Missing the obvious, pointing out the obscure. 😉
June 22, 2008 at 9:19 am
The nice thing is that deprecated features last for a couple versions. DTS was announced as deprecation in 2005, it's stil there in 2008.
I'm not sure why features get deprecated....
June 22, 2008 at 9:18 am
You're welcome and glad you liked it.
Some great comments in here.
June 21, 2008 at 5:18 pm
Can you give an example, or a few? It's not clear what you mean.
You also might want to check out datepart, which can get you different parts of a date,...
June 21, 2008 at 5:18 pm
Also, dividing the database among servers might not work. It depends on your application.
You probably should hire a consultant to evaluate performance and help you improve the speed at which...
June 21, 2008 at 2:22 pm
Keep in mind if you did move to database snapshots that the snapshots are point in time and don't keep up with changes to the primary.
June 21, 2008 at 2:21 pm
It's possible that they are. the reason is that read aheads, scans of indexes or heaps, etc., don't take place in contiguous order, at least not outside 10MB. Any extents...
June 21, 2008 at 2:20 pm
Did you follow instructions here? http://support.microsoft.com/kb/224071
June 21, 2008 at 2:16 pm
Viewing 15 posts - 28,096 through 28,110 (of 39,804 total)