The Dixie Flatline (12/15/2009)

---

The Thread ebbs and flows, Bru. 🙂

Barry (aka MISTER 10K) made an heroic effort to participate in the final sprint down the stretch and everyone...

Are you doing an exercise aimed at creating deadlocks? That's the result you'll get.

The original transaction can't complete till Trigger A completes. Trigger A can't complete till Trigger...

jayoub1 (12/15/2009)

---

Q: nothing running at all? Even just running reindex on the database will cause log file growth and if you have growth factor at default 10% its going to...

Doing it the right way (parent-child) has more benefits than just being "right". It will also query more easily, be easier to update, allow you to control for referential...

One of the most important roles in any group dynamic is keeping the people involved locked onto a target or purpose or goal of some sort.

The odd part is, everyone...

The log file won't grow without some sort of activity. That activity could be automated maintenance plans, could be something running that nobody told you about, could be from...

Barry:

I've spent more years as a manager/exec than as a DBA (though that changes next year, when I will catch up with myself, as it were).

As such, I've seen the...

You're welcome.

When you have a chance (make it soon), look up Numbers and Tally tables on this site, and via Google/Bing/whatever. They're very, very useful.

As far as turning the text file timestamp into a real timestamp, take a look at this, see if it'll do what you need:

declare @TS char(8);

select @TS = '10141045';

select

dateadd(month,...

jayoub1 (12/14/2009)

---

I have SQL 2005 running on a Windows Server 2003 and I have a question about Buffer Cache Hit Ratio and Page Life Expectancy

First: What does Buffer Cache hit...

Try this in your test/dev database:

create table dbo.Numbers (

Number int primary key);

go

insert into dbo.Numbers (Number)

select top 10001 row_number() over (order by t1.object_id) - 1

from sys.columns t1

cross join sys.columns t2;

go

create procedure...

Even in cases where the data type precedence won't cause a problem, I find the Coalesce version below much easier to read, understand, and maintain, than...

BaldingLoopMan (12/14/2009)

---

actually u can use isnull in all situations if u wanted to. A coalesce is a nested isnull.

coalesce(custname, last, first) = isnull( isnull( custname, last ), first )

Therefore...

That doesn't look like T-SQL. Not sure what it is, but I doubt it's from an MS SQL database.

Thanks for the compliment in the article, Steve.

There are a lot of weird ideas out there on performance in T-SQL, but the single biggest factor in most of the questions...