Start your reading here:

http://technet.microsoft.com/en-us/library/cc721270(SQL.100).aspx

Then continue here:

http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx

For additional information go to:

http://technet.microsoft.com/en-us/ms376608.aspx

and in the search block enter "server 2008 enhancements" and you will get a list of 57,000 yes 57 thousand articles...

Basically the same QOD as a prior one in (so as not to give the answer away) too short a time period .... where by the way 77% answered...

In addition to using energy consumption reduction efforts .. how about using arrays of solar panels to turn sunlight into electricity mounted of the roofs of the data centers, the...

Before purchasing any expensive item .. such as a desktop computer, complete with monitor, keyboard and...

Use

http://technet.microsoft.com/en-us/default

Input in the search block:

"create a msi package"

You will get a listing of 99,950 ways to do so using various techniques and software ... including items such as dot.net.

Stefan Krzywicki (1/28/2011)

---

Brandie Tarvin (1/28/2011)

---

The ..... Thread ..... is ..... extremely ..... slow

.

.

.

.

.

....of ....late. ....What's ...wrong ...with ...everyone's ....posting ....skills?

..or ...are ...we ...all ...really ....that ....bizzzzzzz .......

Presume this is the error message returned:

Msg 102, Level 15, State 1,

Incorrect syntax near '>'.

Change that portion of your select statement from:

IF @BalanceMax=0 OR @BalanceMax IS NULL OR @BalanaceMin...

I suggest reading this blog post by Steve Jones

http://www.google.com/reader/view/?tab=my#stream/feed%2Fhttp%3A%2F%2Ffeeds.feedburner.com%2FSqlMusings

You will have to scroll down quite aways, for the title

"Common SQL Server Mistakes – Multi Row DML Triggers" dated Sept...

Jeff Moden (1/27/2011)

---

bitbucket-25253 (1/27/2011)

---

Jeff thanks again, going to be adding it to my tool box. Now wondering if that tool box should be renamed as "ToolboxbyJeffModen"

Yes I know...

Lots of unanswered questions

1. Do the users separate case numbers with commas?

2. Do the users separate case numbers input with one or more spaces?

3. Do valid case...

Use BOL (Books On Line) the help file for SQL Server.. MERGE statement

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using...

Jeff thanks again, going to be adding it to my tool box. Now wondering if that tool box should be renamed as "ToolboxbyJeffModen"

Yes I know the articles are...

Help us to help you.

Please post table definition(s), the T-SQL statement, sample data and the desired results using the sample data. For ease in doing this please click on...

To help others help you with a tested solution, please post table definitions, sample data (suitably altered to hide sensitive information), required results.

For an easy method to do...

Have you considered doing something like this:

SELECT EntryId, Entry, Description

INTO #T

FROM logentries

The INTO statement will create the temporary table.