Viewing 15 posts - 2,686 through 2,700 (of 3,221 total)
This appears to be a duplicate of:
http://www.sqlservercentral.com/Forums/Topic630261-357-1.aspx
Posted at 8:58 PM
January 5, 2009 at 7:26 pm
From 2008 Books On Line (BOL). Click on the link and read table after table of features in each edition.
January 5, 2009 at 7:22 pm
Here are two (2) excellent articles by Jeff Moden which will explain how to perform what you need along with detailed sample code:
January 4, 2009 at 11:16 am
Have you tried this format:
SELECT Name --Column being searched
FROM Production.Product -- Table being searched
WHERE...
January 3, 2009 at 3:21 pm
For a over view of DB statistics please read
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/919158f2-38d0-4f68-82ab-e1633bd0d308.htm
To determine the statistics for a particular table or view use:
To display a report on the indexes of an object, execute sp_helpindex...
January 1, 2009 at 4:03 pm
May I suggest reading this article:
http://www.sqldbatips.com/showarticle.asp?ID=27
In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the...
December 31, 2008 at 10:49 am
Read the following in Books On Line (BOL)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/996c72fc-b1ab-4c96-bd12-946be9c18f84.htm
Pay particular attention to the option in the CONTAINS function description:
Using CONTAINS with weighted_term
The following example searches for all product names containing the...
December 26, 2008 at 3:05 pm
As Steve said:
Arguing that you'll be able to better return the money to retirees later shouldn't be allowed either. The reason is that if you fail, it's no skin off...
December 26, 2008 at 2:05 pm
I guess you can say "It depends" ... on the size of the image data.
To answer in greater detail start reading Books On Line at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2af9a880-98ae-4b14-92ce-74d2459d7f97.htm
December 25, 2008 at 9:35 am
This may help with data import/export to Excel 2007
http://www.support.microsoft.com/ph/2523
Here is an extract from the above link.
Office 2007 files have a new format and therefore are not supported by the Jet...
December 24, 2008 at 7:59 pm
DavidB
I guess the thing that bothers me the most in all of this is that many of the people that reply to these posts do so in a way that...
December 24, 2008 at 9:20 am
From Books On Line (BOL)
If the query includes an ORDER BY clause, the first expression rows, or expression percent of rows, ordered by the ORDER BY clause are returned....
December 23, 2008 at 11:34 am
Jeff's
Ya gotta love it when the ops cooperate.
Learn from them as well as love it ! ! !
December 22, 2008 at 5:52 pm
Terrific and thanks I am sure many many users of this site will benefit from your work.
Again THANKS
December 22, 2008 at 4:43 pm
Best way I know of to broadcast this to frequenter users of this forum.
Please read what I consider to be an important post ... last message on page 2 by...
December 22, 2008 at 4:41 pm
Viewing 15 posts - 2,686 through 2,700 (of 3,221 total)