DBA24 (1/17/2013)

---

Hello All,

I have a primary key on a column that is a unique identifier (width 32 char) and it is nonclustered. There are a lot of inserts, updates and...

For that, I would use a function with PATINDEX to retain only the desired chars.

If performance is not an issue, you can use a scalar function.

I can give you a...

Better yet, forget the dopey "cluster first by identity" and cluster the table the best way: that is THE most important thing for performance.

Based on what you've posted, it seems...

As Lowell states, they're not really orphaned.

Extended properties that aren't explicitly subordinated to a db object apply to the db itself.

That is, if you add extended properties w/o specifying a...

All I can see from what you've posted so far is the check for:

activeclient > 0

in the subquery (patient count) but not in the outer query (attendance count).

It seems possible...

The "sqlcmd" utility does recognize "GO", as well as many other things, including invoking OS cmds.

I think you should be able to use "sqlcmd" to run the scripts.

opc.three (1/14/2013)

---

YSLGuru (1/14/2013)

---

opc.three (1/12/2013)

---

AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has been...

Yes, I would change the specific SQL user login to match the person's name, if all/part of the name itself is being used as part of the login.

Use roles, where...

CDC requires a unique index. That makes sense given what it has to be able to do.

I think by default it uses the PK as the unique index, but...

If the log is on the same drive, don't purge any data until you've given the log more space!

If the log is out of space, and particularly if it getting...

Any chance that either or both "TransferToCostCenter" and "TransferFromCostCenter" are NULL?

Not equal won't work on NULL; you'll have to explicitly allow for NULL in the comparison.

For example:

WHERE ...

...

If the computation "size / 1024 / 1024" yielded 96 gbsize,

the correct computation of "size / 128 / 1024" would yield 8 times that, or:

~768gb

That is not the right computation to get gb. "size" is the number/count of 8K pages. So, to get gb from size, you...

The person's login id is often some combination of last name and first name, so you need to change the name there.

However, internally you should assign each person/user a unique...

You can definitely shrink the log file "live". SQL simply won't do it if it would cause a loss of data.

The tricky part is finding the right size to...