Launch SQL 2005 Database Tuning Advisor

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/b6160e7593b8dda0/052524332db36557?lnk=st&q=%22database+engine+tuning+advisor%22&rnum=2&hl=en#052524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
> Please advise.
> Thanks

Launch SQL 2005 Database Tuning Advisor

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFlags
\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/micr...52524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFla
gs\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
> Please advise.
> Thanks

Latent Semantic Analysis (LSA)

Does SQL 2005 offer any tools to perform Latent Semantic Analysis on large data sets? Say I have millions of daily search queries and I'd like to link queries to one another based on semantic content with a goal of mapping them to larger "categories" . One way of doing this is to compare word frequency and proximity to construct a semantic "weight space". This is the approach generally used in LSA.

Anyone using SQL 2005 for this? Anyone see a way it could be done?

We do have the text mining transforms in Integration Services for determining words and phrases from a corpus of documents. We don't have anything specific to LSA, but if you have categories and run a logistic regression you may be able to pull the coefficients to get the information you need. For an example, see http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1509.aspx. If all else fails, you can write custom algorithms that plug in to the architecture using either C++ or any .NET language.|||

Had a look at the Text Mining tutorial. It appears to me that the term extraction and term lookup transforms destroy the notion of proximity between the words in the phrase (seems to just create a frequency count of terms). I believe proximity is the key to deriving semantic meaning using techniques like LSA. I might be missing something, though. Can you see a way of using the transforms while maintaining this info?

FYI, here are some good LSA (LSI) links:

http://lsi.research.telcordia.com/lsi/papers/JASIS90.pdf

http://en.wikipedia.org/wiki/Latent_semantic_indexing

|||

You're right, the transforms do eliminate any proximity, except that our transforms extract key term and phrases. That is, it will extract "Data Mining" as a single entity rather than necessarity seperating into "Data" and "Mining". You can specify the maximum phrase length in the options for the transform.

I could imagine that you could break up these phrases with a post process and indicate their proximity - I don't know if that would help though - you would still lose the proximity between the phrases an dothe rowrds and phrases.

Last Year Month to Date Function

I have been spoiled by some report writing tools that have intrinsic
functions like Last Year Month-to-date. I'm looking for a way to emulate
this in SQL Server now with my fields that are date/time.

I'm thinking I need to develop a user defined function to accept a date
input parameter, but I don't know where to start.

Help/Examples appreciated.

Thanks,
Frank

*** Sent via Developersdex http://www.developersdex.com ***Hi, Frank

If you have a date and you want to obtain the corresponding date in the
previous year, you can use the DATEADD function, like this:
DATEADD(year, -1, @.TheDate). For more informations, see:
http://msdn.microsoft.com/library/e..._fa-fz_2c1f.asp

Razvan