GilaMonster (9/18/2011)

---

For some general silliness...

CREATE DATABASE [Oops]

ON PRIMARY (

NAME = N'Oops', FILENAME = N'D:\Develop\Databases\Oops.txt:Data'

)

LOG ON (

NAME = N'Oops_log', FILENAME = N'D:\Develop\Databases\Oops.txt:Log'

)

GO

Data files, what data files?...

Yes, it's aligned.

GilaMonster (9/16/2011)

---

ALZDBA (9/16/2011)

---

Tom.Thomson (9/16/2011)

---

I forgot one:

5) risks of using backup log to append a log backup to an existing file containing log backups instead of always creating a new backup...

Brandie Tarvin (9/16/2011)

---

I'm thinking about getting a tablet so I can do email & social networking apps while I am at functions (rather than lugging my laptop around), but also...

A couple of things that were very successful on my resume last year:

Summarize the "good parts version" right at the top. I have a list of 5 or 6...

Jan Van der Eecken (9/16/2011)

---

Totally different topic. Has anyone downloaded and tried out the Windows 8 Developer preview? If yes, what's it look like apart from being a big Windows...

I used to have problems with BIDS freezing up and requiring a reboot, but haven't run into that in several years. Is it possible you have a missing patch/service...

Ninja's_RGR'us (9/16/2011)

---

Brandie Tarvin (9/16/2011)

---

Gianluca Sartori (9/16/2011)

---

WayneS (9/16/2011)

---

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using...

paul.phillips (9/16/2011)

---

Getting back onto the theme of the original post.

If 0.999 recurring = 1, then does 0.00...1 = 0?

The issue I have with 0.999 recurring = 1 is...

jcrawf02 (9/16/2011)

---

In our house, it was more of a "dad cuts into sixteen equal pieces, kids get a piece each, next morning the rest have mysteriously disappeared" kinda game. For...

If you want to automatically rebuild, you'd use Alter Fulltext Catalog (details here: http://msdn.microsoft.com/en-us/library/ms176095.aspx).

Run that as a script in your maintenance job.

I'm not sure why it would require a reboot....

GilaMonster (9/16/2011)

---

I suspect this got lost in all the 'helping Grant abuse SQL' posts...

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...

I can't understand your question.

You have some data in Excel. I get that much. What are you trying to do with it?

Contains is dependent on the full-text index. If the index is up-to-date, it will be faster than Like, often much, much faster. (Of course, full text indexing can...

GilaMonster (9/16/2011)

---

Almost everyone mixes up density (measure of how unique an index is), selectivity (measure of the fraction of total...