SQL 7 - What Is Microsoft Thinking ??

Dec 2, 1999

I don't know what Microsoft was trying to accomplish when they redid the way SQL 7 handles indexing, but as far as I'm concerned they failed badly. They just broke SQL Server, IMHO.

As a developer, I do not want to have to study rocket science just to get my queries to run fast. In SQL 6.5, if I wanted quick response on a join query, all I needed was an index on the fields I was joining on, in the join table. It worked, didn't have to mess with Profilers and Index Tuning Wizards, just load and go.

Now in 7, I might as well not bother. It's going to do what it wants to do regardless. Even if I use the Query Index Analyzer, and let it create the index it recommends, it still doesn't work. I'm sitting here watching queries I used to be able to run in seconds take 15, 20 minutes and longer.

It's time for the average guy to stand up to Microsoft's increasingly heavy hand and tell them to let us make the decisions on how we want to use our tools. Since 1995, they've been on a downhill slide as far as I'm concerned. Each new updgrade of VB, SQL Server, etc. is buggier and more of a hassle to work with than each previous version.

Enough's enough.

John M.

View 1 Replies


ADVERTISEMENT

Am I Thinking Right Or Is It A Bug?

Nov 10, 2000

Please read the following statements. I got my expected results when I use the 3rd statement. How come second statement is giving me junk results.
First statement is just opposite of second and third statement,I believe.

First
-----
select table1.column1 from table1,table2 where table1.column1 =
table2.column1

select table1.column1 from table1 where column1 in (select column1
from table2)

Both results are same here.

The result is all the common rows.

Second
------
select table1.column1 from table1,table2 where table.column1 <> table2.column1

Third
------
select table1.column1 from table1 where column1 not in (select column1 from table2)
The result is

View 1 Replies View Related

MSSQL Not Coming Up Thinking It Is Evaluation Copy

Nov 1, 1999

Hi,


Our front-end GUI person changed the system date one month back to avoid the expiration of the Servelet Exec software. After rebooting the system, MSSQL refuses to come up and the errorlog has the following message: "The evaluation period has expired". The version we had was never an evaluation version!


What's making it think that and is there a way to correct the situation?


Any help/suggestions would be greatly appreciated.


Thanks in advance,

Nishi

View 1 Replies View Related

Wishful Thinking: SourceSafe Integration With SQL Server

Mar 14, 2007

Imagine opening SQL Server Management Studio (SSMS), drilling into adatabase, and seeing all objects with little lock symbols in front ofthem. That would be true SS integration.Maybe next version?I know about creating a project in SSMS and managing connections,queries, and misc there, but come on, that seems a far cry from what Ilong for.I searched for 3rd party tools and found SQLSourceSafe and Apex SQLTools. Does anyone have experience with those?-Tom.

View 2 Replies View Related

Thinking About Converting Backup Schedule To Maintenance Plans

Nov 28, 2007

Hi All,

I've just started at a new job that is a little bit of a step up from my old job. At my previous job I was responsible for 5 instances of SQL Server with about 30 databases. My new job has me (and a team of 3 other DBA's) responsible for 100+ instances. The backup schedule and process is a mess. I'm thinking about moving everything to Maintenance Plans (some 2000, some 2005). I've always scheduled individual jobs for each database previously and done index maintenance manually, but I'm kinda leaning toward Maintenance Plans just to simplify everything.

Anyone out there have any input on how and why they chose MP's over scheduling backups db by db? Or anyone out there choose not to use MP's for a particular reason? Input is greatly appreciated.

Manny

View 1 Replies View Related

Microsoft.AnalysisServices.Viewers.DLL Microsoft SQL Server 2005 Datamining Viewer Controls

Jun 21, 2007





Hi

I am trying to use Association Viewer Control in

Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.

"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"


Is there anyone here who use
"Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ?
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

i am using VS2005 Version 8.0.50727.762 (SP.050727-7600)
and SQL Server 2005 SP2

thanks from now.

Cem Ăśney







View 9 Replies View Related

Microsoft Access Doesn't Support Design Changes To The Version Of Microsoft SQL Server

Jul 23, 2005

Dear All,Access adp on sql-server 2000After upgrating to A2003 updating data with 1 perticular combobox causes theprogram to hangs without any error-msg.Traying to change te combobox recordsource i get this error:This version of Microsoft Access doesn't support design changes to theversion of Microsoft SQL Server your project is connected to. See theMicrosoft Office Update Web site for the latest information and downloads(on the Help menu, click Office on the Web). Your design changes will not besaved.The solution in :http://support.microsoft.com/defaul...kb;en-us;313298tolks about SP 'dt_verstamp007' but I have SP 'dt_verstamp006'What should I do.Is the failure of the combobox also caused by the absence of dt_verstamp007???Filip

View 2 Replies View Related

[Microsoft][ODBC Microsoft Access Driver] System Resource Exceeded

May 22, 2007

odbc_pconnect() [function.odbc-pconnect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded., SQL state S1001 in SQLConnect





we got the error with access 2000 database and PHP as prog. language .



we created dsn for the connection.



reboot solves the problem. but we need another solution better than this.

View 7 Replies View Related

Installing Microsoft Dynamics 10.0 With Microsoft SQL Server 2008 Katmai

Sep 25, 2007



Hi,

I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:

******************************************************************
Your current SQL Server is not a supported version.

Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10

You need to upgrade to SQL Server 8.0 before continuing.

******************************************************************

Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?

Assad

View 7 Replies View Related

Microsoft SQL Server Express And Microsoft Visual Studio...

Mar 17, 2008

I have a query that executes just fine except that it won't recognize varchar(255) ( or any other value within the () ) and if I leave it off like this: varchar, then it executes but it leaves that value as 1 and that is just not very useful for my purposes. This also happens with anything else that requires () to add length such as char(), or nvarchar(), etc... Any ideas?

View 1 Replies View Related

Microsoft Access VS Microsoft SQL Server

Aug 26, 2006

hello all member

View 14 Replies View Related

Microsoft Exchange To Microsoft SQL Server

Jul 23, 2005

I'm not asking a lot. I just want to know if I can connect from anExchange server to a SQl server without having to use Access linkedtables. Surely MS must have had a look at this but I can't findanything out there.Help appreciated.Ginters

View 1 Replies View Related

&#34;Failed To Copy Objects From Microsoft SQL Server To Microsoft SQL Server &#34;

Oct 3, 2001

Hello,

"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server "

I keep getting this when trying to copy stored procs from one db to another on the same server. I am using the DTS wizard. I have been able to copy the tables but I need the sp's too, and there are too many to copy one at a time.

Help!

TIA,
Bruce

View 1 Replies View Related

Difference Between Microsoft Sql Server 2008 And Microsoft Sql Server 2005

Mar 27, 2008



Pls tell me about the adjact difference between sql server 2005 and sql server 2008.
Why to upgrade for Sql Server 2008

View 1 Replies View Related

Microsoft SQL Server Database File (SqlClient) Vs Microsoft SQL Server

Aug 30, 2006

In VS 2005, when we choose database connection, we can choose one of the above. My question is in what situations should we choose MS SQL Server Database File (SqlClient), and when should we choose Microsoft SQL Server?

I want to deploy a standalone desktop application with a backend database. Which backend database should I should and which of the above connection should I choose?

Thanks very much for your information.

View 1 Replies View Related

Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]

Dec 10, 2003

Hi Everybody,


On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.

Thanks,

Arif



Server Error in '/' Application.
--------------------------------------------------------------------------------

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

View 5 Replies View Related

How To Connect ADODB With Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider For Microsoft SQL Server Compact 3.5)

Sep 12, 2007

Hi
We are checking VB 9 (Orcas).

we connected to database created under with sql server 7. with this code

Public cn As New ADODB.Connection

Public Sub OpenDB()


cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")

End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).

Rgds
Pramod

View 7 Replies View Related

How Can I Connect To Microsoft SQL Server 2005 CTP With Microsoft SQL Server 2005 Express Manager?

Aug 9, 2005

I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally

View 10 Replies View Related

Microsoft SQL Server Developer Edition Vs Microsoft SQL Server Express Edition

Mar 23, 2008

I have just installed sql server 2005 but, now I have two types of server name: Microsoft SQL Server Developer EditionMicrosoft SQL Server Express Edition Which one should I use? Does it matter??thanks.. 

View 1 Replies View Related

Convert Microsoft Word XML To PDF Without Using Microsoft Word

Jan 19, 2007

Hi all,

I work for a financial company where we send out lots of correspondence to clients on a daily and monthly basis. This would typically be something like a financial report, account statements, etc. We've decided to use PDF as the format which these documents must be in when our clients receive them.

Our marketing and sales departments designs the templates of these documents using Microsoft Word. They can save these MS Word documents in the Word XML format (either 2003 or 2007). We want it in XML format, because it is text based, and we can therefore string replace the content to update the template with a client€™s information. In the same token RTF would also do, but the file size when converted to RTF is a problem.

What I am looking for is a way to convert this XML into PDF using something like XSL-FO - i.e. we do not want to use the Word Interopt on our Production Server, firstly it is a little slow and secondly the production server is unmanned and we cannot allow a WinWord.EXE process to not close successfully for some or other reason.

I've tried a number of companies' evaluation software to try and achieve this (converting the WordML to PDF via XSL-FO), but so far no luck.

Does anybody know of a stylesheet out there with which I will be able to achieve this? Or an alternative method of converting MS Word files into PDF without using Word to do it?

Thank you in advance.

Regards

View 4 Replies View Related

Bug In Microsoft ?

Mar 28, 1999

Is there a bug in SQL Server 6.5 that does not permit the increase of
RAM dedicated to SQL Server (above approx. 200MB), without reducing the
procedure cache to 10% ?

View 1 Replies View Related

Microsoft SQL 6.5

Sep 28, 2004

I need to refresh data from a SQL 6.5 environment for QA purposes (hopefully generic solution should work for 7 & 2K). I need to select blocks of data in demand or in an automated fashion.

I would like to know the experiences of anyone who has done this.

View 3 Replies View Related

Microsoft CRM

Jan 16, 2008



Hey guys how you doing ?
Well i wanna Install Microsoft CRM for Sharing Data with Client.
i have installed Windows Small business Server 2003 Service Pack1

Please i need some help to get starting making my server and Starting using the Microsoft CRM

Do i need to Install SQL server after installing Windows Small business Server 2003 Service Pack1 ?

Can anybody give me some help


Thanks guys

View 6 Replies View Related

Thank Microsoft For Many And Nothing

Dec 22, 2005

  Sql server has some very good features but some possibilities are forgotten.

  For instance in DTS2000 there was a possibility to make data transfer packages from  a AS400 ODBC connection (With parameters )  to Sql server tables.

Those parameters were set in a dynamic properties task.

In Sql server I can get variables out of sql tasks and even pass a parameter to an ODBC Sql task. This all works find. However when we try to use the obtained parameters in a dataflow transformation we are left in the cold.

The dataflow function in 2005 has indeed great looks but that is all. Everything I could do in DTS2000 seems not to be possible anymore.

For the query Source component in Data Flow :

ODBC - connection -----> No parameter binding possible (If so it is very wel hidden)

OLEDB connection , Parameter binding should be possible but again there is little or no possibility to make a good connection to the standard AS400 OLEDB provider)

Also other commercial OLEDB providers like HITSW aren't working.

Thank you very much MS for many and nothing. After 2 days of trying i have to develop DTS2000 packages again .

 

Ronny Vergracht

 

View 5 Replies View Related

Microsoft Sql Database (*.mdf) Using Help ?

Sep 14, 2006

HiI use visual std. 2005 and I create a asp.net web page after >add item> sql database > I added my project *.mdf  file when I make project my project is runnig with visual studio 2005 but I sent my hostting (internet server ) I cant use this mdf file . Are we register this mdf file sqlserver ?   can we use this mdf file like access file (mdb ) . What kind of thing I do to  use this mdf file . Thanks

View 4 Replies View Related

About Microsoft Certification

Jun 26, 2007

hi.
iam learing Ms server 2005 i want is there any MicrosoftSoft certification for Microsoft Sql server 2005 alone
 

View 2 Replies View Related

Microsoft Sql Server Smo

Aug 24, 2007

Im trying to use
Microsoft.SqlServer.Management.Smo
to load a dropdown of available sql server databases.
On my computer it works fine but when i try and run the application on my virtual it throws and unhandled exception that it couldn't load SMO assembly. I know this is because 2005 isn't installed on my virtual but i want to be able to catch this error and just ignore it and load a blank dropdown. I tried putting try catch blocks around the load but it still errors. I then tried instead of importing it i tried to reference smo by using the whole name inside of my try catch block.
 Does anyone know how to catch this errorTry
' Create a new connection to the selected server name

Dim srvConn As New Microsoft.SqlServer.Management.Common.ServerConnection(txtServerName.Text)
Dim srvSql As Microsoft.SqlServer.Management.Smo.Server

' Log in using SQL authentication instead of Windows authentication
srvConn.LoginSecure = False
' Give the login username
srvConn.Login = txtUserID.Text
' Give the login password
srvConn.Password = txtPassword.Text
' Create a new SQL Server object using the connection we created
srvSql = New Microsoft.SqlServer.Management.Smo.Server(srvConn)
' Loop through the databases list
For Each dbServer As Microsoft.SqlServer.Management.Smo.Database In srvSql.Databases
' Add database to combobox
txtDatabase.Items.Add(dbServer.Name)
Next
Catch ex As Exception
MsgBox(ex.Message)
End Try 

View 2 Replies View Related

Microsoft UPDATE BUG When Only One Row?

Mar 30, 2001

The update statement is failing with Timeout expired when there is only one row to update, otherwise if there are multiple rows to update it does not update the first row but updates the rest!!!??

Update cm_event_notification Set processed = '3/29/01 10:41:01 AM' Where dn = '{2E738808-23B4-11D5-B49A-00508BD934F8}'

View 1 Replies View Related

Microsoft Support For 6.5

Jan 12, 2001

Does anyone know when Microsoft is due to end support for 6.5?

View 1 Replies View Related

Microsoft Query

Aug 3, 2002

Hello

I have win2k with service pack3 and i cannot configurate Microsoft Query to work with Sql Server.

I chose the Sql Server driver i press connect and than appear a box Server and I write server name and dont work. Why?

View 1 Replies View Related

.MDF With MIcrosoft Excel.........

Jan 2, 2006

Is there a way to get external data in excel from a backup of a mdf off of the SQL Server??????? :confused:

View 3 Replies View Related

Microsoft SQL File I/O

Jan 30, 2004

Does anyone know how to do file I/O in T-SQL. When I say that I mean, I would like to get information from a '.dat' file, parse through it, grab information, then store the information in a database.(also what are the limitations if any to file i/o manipulation in T-SQL) After that is done I need to rename the '.dat' file, and cut and then paste it into an archive directory. Before I say fuck it and do it in C++, is it possible to do this in T-SQL (Microsoft SQL Server 2000).

Thank You
..Neo

View 9 Replies View Related

Help: Need Microsoft SQL Client

Feb 28, 2006

Hey guys,

I'm in need of a Microsoft SQL client, pref. one that supports all MS SQL servers, and easy to use is a big plus

Cheers guys

-fragged

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved