Are you trying to index a view? The problem may be how the the view was created.

Or just use the native FTP tools available on windows or linux systems. Why bother with downloading 3rd party FTP tools?

tosscrosby (11/5/2010)

---

ALZDBA (11/5/2010)

---

Jack Corbett (11/5/2010)

---

Today my oldest son (9) fell off a swing, landed wrong on his arm and is on the way to the ER with his...

Not having any DDL (create table statements), sample data (series of INSERT INTO statements for the tables), and expected results; is this what you are trying to accomplish?

select

...

If you schedule a t-log backup to run every minute, is that sufficient time to accomplish the backup and not impact processing? Millions of dollars a minute, either there...

Jeff Moden (11/4/2010)

---

Lynn Pettis (11/4/2010)

---

tfifield (11/4/2010)

---

UDF's don't necessarily hurt performance. I write UDF's all the time to do string manipulation type actions. These aren't much slower than built...

sql.monkey (11/4/2010)

---

Youre administering a system where each minute of transaction log contains millions dollars of transactions.

If you lose any of those transactions youre company is liable.

How often do...

Jeff Moden (11/4/2010)

---

Karthik... you and I...

tfifield (11/4/2010)

---

UDF's don't necessarily hurt performance. I write UDF's all the time to do string manipulation type actions. These aren't much slower than built in functions like SUBSTRING()....

A better way, direct from the QotD for Oct 19, 2010:

select

sum(row_count)

from

sys.dm_db_partition_stats

where

(index_id = 0 or index_id = 1);

sysobjects and...

Doctork11 (11/4/2010)

---

What I need is a way to take a statement like

UPDATE TempTable SET PERIOD = '1' WHERE SERVICE IN('A','B')

and if the RESUTLS are ZERO STOP. Any thoughts or...

Gail, Sounds like all future informal conversations will need to include a member of management.

Okay, finally got around to answering questions, and hit this one.

I got stuck on the title and started looking to see if something new had been added to SQL Server...

Okay, finally found it in the documentation. A column defined as a NUMBER is a FLOAT. Okay, that really makes sense, doesn't it.

I forgot about the draft and officiated a high school soccer game. When I got home I was tired and didn't even think about getting on the computer.