Brandie Tarvin (5/31/2013)

---

SQLRNNR (5/31/2013)

---

Brandie Tarvin (5/30/2013)

---

WayneS (5/29/2013)

---

Personally, my new laptop is 32gb ram, with multiple SSD drives (I have plans for presentations with many VMs running...). I'm still getting stuff...

Which world did you inhabit...

Brandie Tarvin (5/30/2013)

---

WayneS (5/29/2013)

---

Personally, my new laptop is 32gb ram, with multiple SSD drives (I have plans for presentations with many VMs running...). I'm still getting stuff installed on it,...

jvkondapalli (5/29/2013)

---

Jason, Thank you very much for the quick post. I was staring at plan attributes this whole time without knowing its advantage. :Wow:

I started anayzing the SQLs from the...

I will clean that code up a bit and blog about it in the near future.

This is a rough query of what you will need

DECLARE @SetOptions TABLE (

OptionDescVARCHAR(64)

,OptionValueINT PRIMARY KEY CLUSTERED

,OptionNotesVARCHAR(256))

-- http://technet.microsoft.com/en-us/library/ms189472(v=sql.105).aspx

INSERT INTO @SetOptions(OptionDesc,OptionValue,OptionNotes)

VALUES ('ANSI_PADDING',1,'')

,('Parallel Plan',2,'')

,('FORCEPLAN',4,'')

,('CONCAT_NULL_YIELDS_NULL',8,'')

,('ANSI_WARNINGS',16,'')

,('ANSI_NULLS',32,'')

,('QUOTED_IDENTIFIER',64,'')

,('ANSI_NULL_DFLT_ON',128,'')

,('ANSI_NULL_DFLT_OFF',256,'')

,('NoBrowseTable',512,'Indicates that the plan does not use a work table...

Evil Kraig F (5/29/2013)

---

How many mice did the cats eat before the mice...

Is that in reference to a certain baseball number or to the number of posts remaining to hit 40k?

Chad Crawford (5/29/2013)

---

SQLRNNR (5/29/2013)

---

Why yes, yes we do. We are going to take over...

Why yes, yes we do. We are going to take over the world today.

Nice to...

Hugo Kornelis (5/29/2013)

---

I am not surprised that SELECT ... INTO loses the FILESTREAM attribute. However, I was surprised to find that varchar(max) with FILESTREAM would be converted to varbinary(max).

So then...

SQL_Surfer (5/29/2013)

---

Is it a good idea to put index on view? Some of the views are taking longer to execute and I am thinking about putting index on views. But...

Chad Crawford (5/29/2013)

---

Brandie,

If you go to Crucial.com, you can either enter your mfg/model or use their tool to scan your laptop and they will tell you exactly what type...

Grant Fritchey (5/29/2013)

---

If you can, yes.

I've got...

Which script are you referring to?