jacroberts (5/6/2010)

---

bphipps-931675 (5/6/2010)

---

But SSMS inherently gives you a save option. All you have to do is save them like any other file to your hard drive. I really...

mike.renwick-894639 (5/6/2010)

---

I kept .dtsx and .rdl files out of this discussion -they already sit very naturally as files in a standard source repository. Obviously there's no point scripting them...

I've been using source control (currently Perforce) for ALL of my database development (tables, FK constraints, functions, stored procedures, views, triggers, etc.). I.e., everything. I also handle new...

I have encountered the exact same requirement where I needed to know what stored procedure was performing the data modification.

The technique that I used was to use CONTEXT_INFO as a...

This is a nice example of why you SHOULD NOT test @@ROWCOUNT at the start of a trigger and exit if the value is zero. Although this technique has...

Using XML as a multi-row data transport...

Read the SQL Server 2008 documentation (Books Online):

Table-Valued Parameters (Database Engine)

http://technet.microsoft.com/en-us/library/bb510489.aspx

Also see MSDN...

Full-text is used to find things based upon search criteria.

What full-text indexing would do would be to tokenize all of the terms (words) and then index them. But NYPD...

"no" is a Stop (noise) word and will not be indexed. Which means that it cannot be searched.

My strong opinion: Eliminate the Stop (noise) words. You'll be better...

A very generic question. As with everything, "it depends".

Search the forums as there are numerous threads and topics related to your problem.

For starters, see the already published articles.

Some links...

SQL Server's full-text subsystem cannot solve your problem for several reasons:

1. The number of "words" would not be accurate as the full-text indexer tokenizes the text into "terms" based upon...

Reminds me of a time back in the mid-70s when we did the first run of checks from the new Accounts Payable system. Back then checks were produced on...

Having also worked with Oracle for 25 years, Oracle has had user-specified database pages (e.g., 2K to 32K) for decades. See DB_BLOCK_SIZE. Rows were never limited to the...

We have encountered the same problem.

You will have to scrub the data stored in all of your text (char, nchar, varchar, nvarchar, etc.) columns to eliminate all invalid XML characters.

Valid...

WayneS (1/24/2010)

---

Edit: I also curious... how much are cascading updates/deletes used in a production environment? Personally, I've never seen it actually used, so I'm curious as to how much it...