WayneS (4/22/2009)

---

Another thing to think about...

In the other thread, you had mentioned that you'll do a bunch of data retrieval operations through a view.

If the view is coded with a...

EdVassie (4/22/2009)

---

If you have multiple files in your filegroup, then using fragmentation stats to decide if an index needs maintenance will not work.

Fragmentation stats work well with a...

slange (4/22/2009)

---

It shouldn't have any affect. In fact, if you try to insert or update a computed column sql throws an exception. The one potential issue is that if the...

Bob Hovious (4/22/2009)

---

No problem. Here's what I've got. My understanding is that it can't be used for commercial purposes.

Jeff: Who did your awesomely animated NO...

Bob Hovious (4/22/2009)

---

Hey Guru:

I like your Lobo-esque avatar too. I can't remember the exact site where I got this one (which is currently an angled perspective...

Bob Hovious (4/22/2009)

---

I'm from Mississippi, Jeff. Our phone numbers are only 5 digits long....

Jeff Moden (4/22/2009)

---

YSLGuru (4/16/2009)

---

How To Display Phone Number Formatted

How To Apply Mask To Phone Number

Q: How best to display a phone number that is stored raw (without any formatting or...

Jeffrey Williams (4/21/2009)

---

The index rebuilds won't block on the table/index resource - they block on CPU resources. You'll start to see a lot of CXPACKET waits and they will...

Jeffrey Williams (4/21/2009)

---

Be aware that on SQL Server 2005 Standard, index rebuilds will only utilize a single processor. They will never use a parallel plan.

SQL Server 2005 Enterprise Edition...

EdVassie (4/21/2009)

---

There is no inherent need to run these jobs in a single stream or in multiple streams. You just need to be aware of the impact running multiple...

Thanks Gail for replying. I had a feeling this was the case but wanted to hear someone else say the same first.

Rajesh Jonnalagadda (4/17/2009)

---

Hi,

Try this,

DECLARE @Phone NVARCHAR(50)

SET @Phone = '(xxx) xxx-xxxx'

DECLARE

@LoopINT

,@In_LenINT

...

Bob Hovious (4/16/2009)

---

You didn't learn to program in RPG did you? 😀

I've used both SUBSTRING and STUFF. Lately I've stayed with STUFF. You should...

Jack Corbett (4/17/2009)

---

I'd let the UI do the formatting. In the case of a system that I am currently involved in developing that includes international phone numbers you could...

Just curious if the question is badly worded, a dumb question or is this really something no one has any input/thoughts on?

IS there a better forum for this item?