Viewing 15 posts - 46 through 60 (of 87 total)
Thanks for the explaination. I talked to a net programming buddy of mine here, and he said to always use the col index, so I'll have to show him your...
February 14, 2011 at 11:28 am
GilaMonster (2/12/2011)
amenjonathan (2/11/2011)
Personally if something is faster and there's virtually no complexity difference, I use the faster version. Why waste where there is no need is...
February 14, 2011 at 9:25 am
Tom.Thomson (2/11/2011)
amenjonathan (2/11/2011)
1. If a column is added...
February 14, 2011 at 9:18 am
I didn't have time to read all the posts but here are a couple more I didn't see in the first couple pages:
1. If a column is added to the...
February 11, 2011 at 5:42 pm
I also use SELECT NULL.
Personally if something is faster and there's virtually no complexity difference, I use the faster version. Why waste where there is no need is my motto.
February 11, 2011 at 1:48 pm
I've never embellished or lied in an interview or on my resume, but I'm definitely done being intimidated by job requirements on postings. So many times they list everything and...
February 8, 2011 at 1:18 pm
Plus if you change the log backups to once per hour, you will not need as much space and should be able to shrink the log at that point.
February 7, 2011 at 9:31 am
Ah thanks for the correction Ken.
So the log will truncate at the first backup after the Full back. Why it doesn't do it at the Full seems a bit weird,...
February 4, 2011 at 10:19 am
After a full or log backup, the transaction log will be emptied out, but the log size remains. This is so the database does not need to grow the file...
February 4, 2011 at 9:50 am
Instead of NULL, create an 'Undefined' record holding key 0. Makes life much easier. In my warehouse I have set up the keys to start at IDENTITY(0,1) for this reason....
February 4, 2011 at 9:09 am
The time change is the exact reason I perform GETDATE() at the beginning of any proc it's needed in. That and IMO it's best practice to increase performance any where...
February 4, 2011 at 9:02 am
Just wanted to post back to this thread that I finished my blog post on handling hierarchies in slowly changing dimensions. If I've misquoted anyone (especially Gus) please let me...
January 28, 2011 at 1:23 pm
Agree with others. Better way to solve this is have dev, test, and prod environments. DBAs do code review after developers have submitted code for test. No developer should...
January 25, 2011 at 9:07 am
mishaluba (12/14/2010)
January 13, 2011 at 10:02 am
Viewing 15 posts - 46 through 60 (of 87 total)