Please post ...

1- Available indexes

2- Predicate a.k.a "where clause" of offending queries.

Please note that my example has query and view in database "A" while base tables of the view are...

UMG Developer (9/27/2010)

---

Depends on what you are trying to do. DISTINCT is just an automatic GROUP BY on every column in the SELECT clause, so if that is what you...

vinothraj (9/23/2010)

---

Select

EmployeeNumber,

EmployeeName

From

dbSecond.dbo.EmployeeTable

I want to create a index...

Hard to say, we do not know what are you trying to achieve 🙂

As Dave said you...

Digs (9/28/2010)

---

TITLE: Microsoft SQL Server Management Studio

------------------------------

Drop failed for Table 'dbo.DIM_Splits'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Table&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Lock request time out...

You are welcome.

For ER approach to data modeling please take a...

That was close 😀

y.loewidt (9/25/2010)

---

I would like to write a log table for this application but i am unsure of what are the needs of a log table, in other words, what do...

GabyYYZ (9/28/2010)

---

We currently have a SQL 2008 Enterprise instance chugging along no problem. We recently upgraded it from SQL 2005 to 2008, and the application associated with it tripled...

Would you mind in starting by...

What shall we do when we bump into this row?

Insert #AcctActivity Values (3, 1, 'ESN1022', '9/22/10', 'Samsung1', 'PP3000')

ESN# has changed once again for same customer, does a new before/after image...

well... you can't have bacon without killing the pig meaning, you can't have it...

RichardDouglas (9/23/2010)

---

I'm just trying to gause what others are doing with regards to their data warehouse when it comes to statistics.

Do you use automatically created statistics or do you...

saravanansankarank (9/23/2010)

---

Assume I have a customer data stored in the customer table for various clients, suddenly one client wants to segregate their customer data from this table. Can anyone help...