ramyours2003 (7/25/2012)

---

Hi ,

can any one answer this

Whenever a client/User requests to a Sql Server what exactly happens internally? which components will handle the requests and how...

Out of curiosity, are inserts "cheaper" in terms of time for a heap versus a clustered index?

To extend the OP's metaphor, it's real easy to toss another book on top...

GSquared (6/7/2012)

So you have to start with 4 per processor, then you can get them in multiples of 2 cores for processors with more than 4 cores.

Thus, if you have...

Thanks for the link to that article! I didn't know that data purity checks were disabled on pre-2005 databases by default.

Update: Looking at some test restores on our to-be-production server...

Hmm,

I think we might consider the SQL 2012 BI edition once we actually get to see a price. We currently don't have Sharepoint or Reporting Services deployed,...

EdVassie (2/20/2012)

---

The only way round this would be to limit the number of cores in use either at the Windows level with a boot switch or with Processor Affinity...

Hmm,

You can't store the results of an OUTPUT clause into a variable, unless it's a table variable that has already been defined. If it's a...

I might be wrong about this, but on a table that has a clustered index, the nonclustered index references back to the clustered index[/url]. If its a heap (no clustered...

Hmm,

Hopefully you have an App.Config file in your project and inside there you should see (in the XML) :

<configuration>

...

<connectionStrings>

<add name="SomeDB"...

eli 35692 (1/12/2012)

---

Just noticed it's the tempdb.mdf files with the high read/write not my database file. I'm not creating an temp object that should pose a problem that I know...

nadav (12/28/2011)

---

Hi jim...

i am joining the same view only for the favour of my example-

If i understand you correctly, in any way i will have to create the views...

You would have to do the same thing for the views you are selecting against, since SSMS will not convert a query like yours automatically into a single SQL statement...

Sorry if I'm misunderstanding you, but I think you just want to see if you can generate the SQL used to create the view? In which case you can in...