Yes i have that URL. He explained that a parallel plan can also be executed by a single processor.

http://sqlblog.com/blogs/paul_white/default.aspx

One of the applications that i was recently looking at had 32 indexes on the indexed view(1 clustered, 31 non clustered) :hehe:.

Last time i pulled report, it had 32000+...

In some cases, query processor may keep two plans, 1) without using parallelism, 2) using parallism and use either of them.

beyond that, i cant think why you are seeing several...

what query are you running to see that?

You either need to run profiler to capture the deadlock graph OR enable trace flag 1222 on your system

dbcc traceon(1222)

This will capture deadlock graph in the SQL Server's errorlog.

You can...

by default query processor generates multiple execution plan for any query that you submit and chooses one of them based on least cost. This is by design and you cannot...

saidapur_satish (11/16/2010)

---

Hi All,

I am using live database & my conpany requesting for MIRRORING database.....

If i start for mirroring the users will access the database or...

If the column is varchar, expanding it wont require additional space unless you update those columns with larger amount of data.

once you alter the table, you can update the table...

you cannot retrieve historical information unless a...

looks like after filetering, you have saved the trace template which is overwritten with your settings.

you can remove the filter and save it again or get the template from some...

sql server is waiting on disk IO which either means there is a disk contention issue or your disk is not able to cope up with the rate of data...

duplicate post. please post your replies here.

http://www.sqlservercentral.com/Forums/Topic1019837-392-1.aspx

Edit - fixed the url.

caladba (11/12/2010)

---

Just out of curiosity...

Lets say the fill factor is set to 80 and I have a non-clustered index without covering columns. When a new record is inserted (with the...

i dont know if this would help but when i was a kid, i had a book that had hundreds of sets of simple mathematical quesions(simple ones). contained only +,-,*,/(more...

Don Stevic (11/12/2010)

---

Ugh. SQL Code hard coded in the application? Do they never learn. A solution I have used in the past, which is kind of bulky,...