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
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
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
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
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
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
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
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
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
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
Aug 26, 2006
hello all member
View 14 Replies
View Related
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
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
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
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
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
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
Aug 9, 2005
I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally
View 10 Replies
View Related
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
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
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
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
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
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
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
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
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
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
Jan 12, 2001
Does anyone know when Microsoft is due to end support for 6.5?
View 1 Replies
View Related
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
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
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
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
