SQL Sever Performance Tests
Jul 28, 1998I am currently investigating tools that are available that would enable us to performance test SQL tables/databases- can anyone recommend any?
Thanks
ADVERTISEMENT
View SQL Sever 2005 Express Database On SQL Sever Enterprise Manager
Apr 25, 2006Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"
Thanks
SQL 7.0 Admin Tests
May 19, 1999Has anyone who has taken and passed the SQL 7.0 test for SQL Admin
have any recommendations on the best sources to help pass?
Speed Tests (in Vs. Specified)
Jul 30, 2007Hi Everyone -
We were discussing select speeds the other day,
the question comes in at...
what is faster, a standard query with specifies the search critera
i.e. select * from xyz where a='A' or a='B'
or is the IN a better way to go....
select * from xyz where a in ('A', 'B')
we ran the tests in performance analyzer,
but they were the same results....
maybe i'm smoking the stuff - but i thought the
useage of the IN causes a full table scan for each
of the items in the in clause
please advise
take care
tony
Pre-certification Tests
Apr 23, 2007Anyone know of a site or company that provide good pre-tests for certification?
I don't mind paying for downloadable test either.
Peter Larsson
Helsingborg, Sweden
IT Tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
Feb 17, 2006http://www.testyourabilities.com/it/IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
View 2 Replies View RelatedTransact SQL :: Last X No Of Tests
Jun 3, 2015I have one requirement where i have multiple tests conducted on different dates where i have to calculate last 'x' no of tests
Test Date
Test Seq
Subject
1/12/2014
1
English
[code]....
If i enter @testcount=2 then it should pull the data for only data related to test date 1/12/2014 & 10/06/2014...Above data is only sample data but logic should be dynamic..
Web Tests Of Reports Working For Anyone?
Feb 11, 2007Has anyone been successfull in creating a Web Test with Team System to test a Reporting Services report? I can record the test just fine but I can't run the test without errors being reported. I suspect that the session state has to be parameterized but I have no clue how to do this.
Why is this so hard? Why aren't there samples for this kind of thing? I've been all over the SSRS and Team Test forums and the MSDN site and can't find anything about Reporting Services reports being tested with Team System Web Tests.
How To Modify This Code So That It Also Tests For NULL
Aug 2, 2004Hi,
I'm trying to extend the usage of the code below. This method returns a variable of type SQLParameter and what I want is to accomodate even a check for a null in the parameter. This is a code which I got from one of my co-workers who isn't anymore working here. Any help would be appreciated. I do not want to throw an exception here when a field's type doesn't fall into one of the categories below. The method where this methos is called is the first part of my below code. Any help would be appreciated.
Part 1
private void AddCommandParameters(SqlCommand Comm, string sProcName, ArrayList aParams)
{
string sSQL = "sp_helptext @objname = '" + sProcName + "'";
SqlDataReader dr = this.GetDataReader(sSQL);
int i = 0;
if(dr.Read())
{
while(dr.Read())
{
//CLOSING PARENTHESIS
//When at the closing paren of the stored procedure's variable
//declaration, quit adding parameters.
if(dr[0].ToString().Trim() == ")")
{
break;
}
//ENDING PARENTHESIS
//When at the closing paren of the stored procedure's variable
//declaration, do nothing and skip to next record.
else if(dr[0].ToString().Trim() == "(")
{
//Nada
}
//PARAMETERS
//Add all the parameters listed in the stored procedure's variable
//declaration.
else
{
string [] sParamDef = dr[0].ToString().Trim().Split(Convert.ToChar(" "));
int cs = sParamDef.Length;
string st = sParamDef[0].ToString().Trim();
SQLParameter s = GetSQLParameter(sParamDef[0].ToString().Trim());
Comm.Parameters.Add(sParamDef[0], s.Type, s.Size);
Comm.Parameters[sParamDef[0]].Value = aParams[i];
i++;
}
}
}
else
{
throw(new Exception("Stored Procedure: " + sProcName + " NOT FOUND."));
}
dr.Close();
}
Method being called
private SQLParameter GetSQLParameter(string sVarTypeDec)
{
SQLParameter oParameter;
//VARCHAR
if(sVarTypeDec.IndexOf("varchar") >= 0)
{
int iOpen = sVarTypeDec.IndexOf("(");
int iClose = sVarTypeDec.IndexOf(")");
int iSize = Convert.ToInt16(sVarTypeDec.Substring(iOpen + 1, iClose - iOpen - 1));
oParameter = new SQLParameter(SqlDbType.VarChar, iSize);
}
//CHAR
else if(sVarTypeDec.IndexOf("char") >= 0)
{
int iOpen = sVarTypeDec.IndexOf("(");
int iClose = sVarTypeDec.IndexOf(")");
int iSize = Convert.ToInt16(sVarTypeDec.Substring(iOpen + 1, iClose - iOpen - 1));
oParameter = new SQLParameter(SqlDbType.Char, iSize);
}
//SMALLDATETIME
else if(sVarTypeDec.IndexOf("smalldatetime") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.SmallDateTime, iSize);
}
//DATETIME
else if(sVarTypeDec.IndexOf("datetime") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.DateTime, iSize);
}
//FLOAT
else if(sVarTypeDec.IndexOf("float") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.Float, iSize);
}
//REAL
else if(sVarTypeDec.IndexOf("real") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.Real, iSize);
}
//SMALLMONEY
else if(sVarTypeDec.IndexOf("smallmoney") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.SmallMoney, iSize);
}
//MONEY
else if(sVarTypeDec.IndexOf("money") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.Money, iSize);
}
//BIT
else if(sVarTypeDec.IndexOf("bit") >= 0)
{
int iSize = 1;
oParameter = new SQLParameter(SqlDbType.Bit, iSize);
}
//TINYINT
else if(sVarTypeDec.IndexOf("tinyint") >= 0)
{
int iSize = 1;
oParameter = new SQLParameter(SqlDbType.TinyInt, iSize);
}
//SMALLINT
else if(sVarTypeDec.IndexOf("smallint") >= 0)
{
int iSize = 2;
oParameter = new SQLParameter(SqlDbType.SmallInt, iSize);
}
//BIGINT
else if(sVarTypeDec.IndexOf("bigint") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.BigInt, iSize);
}
//INT
else if(sVarTypeDec.IndexOf("int") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.Int, iSize);
}
else
{
throw(new Exception("Parameter type not supported."));
}
return oParameter;
}
Thanks,
Remote Connection Tests Fine, But Nothing Works On The Page Itself.
Mar 26, 2008If this post belongs somewhere else I appologize. I have spent several days trying to solve this problem with no luck. My site is online. Hosted at NeikoHosting. I can connect to the database remotely when adding a datacontrol. It tests fine. But when running the page it won't connect. Even if I go in and change the Web.Config connection string to a local Data Source provided to me by Neiko, it still won't work. It just won't connect. Here are the two connection strings in the Web.Config, minus my login info: Only the remote string will pass testing. Neither works on the site. <add name="yourchurchmychurchDBConnectionString" connectionString="Data Source=MSSQL2K-A;Initial Catalog=yourchurchmychurchDB;Persist Security Info=True;User ID=me;Password=pwd" providerName="System.Data.SqlClient" />
<add name="yourchurchmychurchDBConnectionString2" connectionString="Data Source=66.103.238.206;Initial Catalog=yourchurchmychurchDB;Persist Security Info=True;User ID=me;Password=pwd" providerName="System.Data.SqlClient" />
Here is the stack trace, if that helps.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
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: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.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:
[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1131233
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.OleDb.OleDbConnection.Open() +37
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.FormView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.FormView.EnsureDataBound() +163
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
So....... HELP!!!!
Thank you!
SQL 2012 :: No Disks Were Found On Which To Perform Cluster Validation Tests
Sep 9, 2014I am getting following errors in my Cluster Validation report when trying to create a Windows Cluster.
I have 2 nodes DB01 and DB02 . Each has 1 public ip, 1 private ip (for heartbeat), 2 private ips for SAN1 and SAN2. The private ip's to SAN are directly connected via Network Adaptor in DB01 and DB02.
Validate Microsoft MPIO-based disks
Description: Validate that disks that use Microsoft Multipath I/O (MPIO) have been configured correctly.
Start: 9/9/2014 1:57:52 PM.
No disks were found on which to perform cluster validation tests.
Stop: 9/9/2014 1:57:53 PM.
[Code] ...
SqlDataSource Set To Stored Procedure, Tests OK In Wizard, Does Not Return Data When Executed
Apr 27, 2007With a Gridview Control, I set the SqlDataSource to be a stored procedure in a Sql Sever database.
Using the wizzard to configure the datasource, the test returns lots of rows. After completing the wizzard, the gridview control does not show the column names in the VS2005 designer. For the gridview column headers the values are Databound Col0, Databound Col1, Databound Col2, ....) This tells me I have a problem.
I tried the same thing with a simpler stored procedure. This test stored procedure does not call anything else, takes several input parameters, returns rows. The column names show in the gridview control as expected.
So I am trying to figure out why the first case of gridview with sqldatasource is not working and the second case works . The stored procedure that is not working with my gridview calls multiple inner stored procedures and has #TEMP tables. My complex stored procedure ends with Select * from #Temp.
Could the calling of other inner stored procedures and use of #temp tables contribute to the problem? If yes then what is the strategy for using a gridview and loading it with the data that the complex stored procedure returns?
SQL Server 2008 :: Linked Server Tests Fine But Query Does Not Work
Apr 16, 2015Using a 32-Bit SQL Server 2008 Express on my LOCAL PC. I downloaded the Advantage 8.1 OLE DB Provider and created a linked server to a REMOTE Advantage 8.1 database server. There is no data dictionary on the Advantage server.
Here is my linked server:
EXEC master.dbo.sp_addlinkedserver @server = N'1xx.1xx.xx.1xx', @srvproduct=N'Advantage', @provider=N'Advantage OLE DB Provider', @datasrc=N'1xx.1xx.xx.1xxeccET', @provstr=N'servertype=ads_local_server;tabletype=ads_cdx;'--tabletype=’ADS_ADT’ (this test works too)
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'1xx.1xx.xx.1xx',@useself=N'False',@locallogin=Null,@rmtuser='adssys',@rmtpassword=Null
Testing the link succeeds with above. Using “ads_REMOTE_server” instead of “ads_local_server” and the test fails. Here is my problem, using the following queries will not work. Perhaps it’s a permissions issue? When I specify my local credentials for the remote server in the linked server it still does not work.
SELECT * FROM OPENQUERY([1xx.1xx.xx.1xx], 'SELECT * FROM ActType')
OLE DB provider "Advantage OLE DB Provider" for linked server "1xx.1xx.xx.1xx" returned message "Error 7200: AQE Error: State = HY000; NativeError = 5004; [Extended Systems][Advantage SQL][ASA] Error 5004: Either ACE could not find the specified file, or you do not have sufficient rights to access the file. Table name: ActType SELECT * FROM ActType".
Msg 7321, Level 16, State 2, Line 2
An error occurred while preparing the query "SELECT * FROM ActType" for execution against OLE DB provider "Advantage OLE DB Provider" for linked server "1xx.1xx.xx.1xx".
Sql Sever
Feb 9, 2008Hello, I'm trying to locate the Sql Server MyCompany database. Does anyone one know where I can get a copy for download? Thanks in advance for your help.GreaseLightning
View 2 Replies View RelatedSQL Sever Name!
Sep 6, 2005Hello,I'm wondering if someone could help me to find the answer for this questionI'm connecting to SQL server database using the server name. When i remove or type the server name in wrong spelling, no errors being catched or even rised!!!!!How can i catch if the server name is incorrect?regards
View 3 Replies View RelatedNeed Help Connecting To Sql Sever
Nov 16, 2003Hi
I am able to connect to an sql server from my server explorer. Can't seem to connect
to an sql server from my code.
this is what i am doing
String strConnection = "server=FRANK;database=Northwind;integrated security=true;";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open
objConnection.Close();
error Login Failure for user FRANK
I know that my server name is FRANK because thats what it says on my Sql Service manager.
And i use that same server name when i connect from my Server Explorer(using Visual Studio.NET) and then i get a listing of the the Databases that are associated with my SQL Server.
I have no problems coonecting to an Access dataBase using OLedbConnection
Sql Sever Connection
Dec 2, 2004I did not use Sql server for 2 weeks and now it shows the red small square on the server icon for SQL Server indication it is stopped. I can not now start it, it says access denies or not exist. Can you please help me to connect to it again as i do not want to re-install and los the databases. I have done nothing to it apart from i change my windows password as the system in the company you have to change it every 3 months, Do you think that might affects?
Please help!!!!!
Upgrade To Sql Sever 7.0
Aug 30, 1999hi, I do have a couple of database and store procedures in 6.5... I want to confirm that I will not run into any problems before I upgrade to 7.0 .
Is the upgrade pain free?
By using the wizard, I will make sure that all upgrade will go right?
any feedback from guys who have already upgraded.. Please give me feeback
Thanks
Ali
Can Not Connect To SQL Sever
Apr 21, 2003After restarting the SQL Sever agents, I can not connect to the server from my desktop via Enterprise manager or analyzer, but everything seems find on the server side. the error message is as follows: "a connection could not be established to [servername]
reason: SQL Server does not exist or access denied ConnectionOpen (Connect())..
I have not attempted to reboot the server yet, I would like to try to resolve the problem withoutout having to do this (last alternative)
setup:
SQL Server 2000 Service pack 3
running on Server 2000.
any help would be appreciated, thank you
SQL Sever 2000 And DB2
May 17, 2002I have a situation where I might want to pull(select) some information from a DB2 database, and possibly push(insert) some data to the same DB2 database. I am sure this is being done in the real world. WHat software, infrastrucure, etc would I need to accomplish this. Is it as simple as using DTS and the proper drivers, or are their better products and solutions. ANy
input appreciated.
SQL Sever 2000
Jun 6, 2004Hi, I have installed SQL 2000 on my system and when I try to start it gives me an error saying 'ordinal 29 cant be found in the dynamic link library odbcbcp.dll.
Please advice!!
SQL Sever Book
Jul 28, 2004Does anybody recomand me good book for sql server administrator and programmer?
View 1 Replies View RelatedSql Mail Sever
May 5, 2004When i try 2 start the sql mail server
i am unable to do so as it throws the following error
MAPI login failure
wat shld i do now??
Sql Sever Job Steps
Dec 3, 2006I am trying to create a SQL Agent job with 3 steps.
I want to delete three tables.
Step 1 ...delete table "X"
Step 2 ...delete table "X"
Step 3 ...delete table "X"
problem is that afer i create the three steps and start the job it never seems to finish the first steps and non of the other steps run, the job looks like is executing and never finishes. I break the job into three jobs each completes fine. I need this to runs one job, any ideas?
perplexed for sure.....
SQL Sever Computer Name
Feb 26, 2007I don't have any errors to share, but I have a question.
What kind of problems (if any) would I encounter if the computer name where SQL Server 2000 or 2005 was installed included special characters? An example would be FNB_(1).
How To Insert A Datetime To Sql Sever
Aug 30, 2006Hi everyone,I need help in inserting a date time string to sql sever. For example, how do you insert textbox1.text="2006-08-30 09:00:00" into a datatable column names starttime (type datetime) in sql sever? How do I covert the format of this string before I do the insert?Thanks.a123.
View 2 Replies View RelatedHow To Insert A Datetime Into Sql Sever
Aug 30, 2006Hi everyone,How do you insert this string value lable1.text="2006-08-30 09:00:00" into a data column like startdate (type: datetime) in sql sever?How do I convert this string value before I insert it into sql sever? Thank you very much.a123.
View 1 Replies View RelatedError In Connect To SQL Sever
Dec 1, 2007I have a problem with the connection to the DB…
I wrote this connection string in the web.config
<add name="dbConnectionString" connectionString="server=(local);database=2C2M;Trusted_connection = True" providerName="System.Data.SqlClient"/>But then when I creat ( SQLdataSource ) and chose this connection , this message is appeared
DataBase schema could not be retrieved for this connection . Please make sure the connection setting are correct and that the database is online. An error has occurred while establishing a connection to the sever . When connection to SQL Server 2005 , this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. ( provider : Named Pipes provider , error : 40 – Could not open connection to SQL Server )
How I can solve this problem ?
Note : I use SQL EXRESS SERVER
Saving To SQL Sever Database Using ASP.net(VB.net)
Feb 6, 2008hi
I have two questions:
1. I want a code to save data typed in a textbox during runtime using SQL server database. The database has a table with several colums where i have to reference the necessary column.
2. Can i use a Gridview to enter data during runtime and save the same data to the database? that is, INSERTING data to the database.
SQL Sever Error: 18452
Jul 23, 2001The error is:
Connection failed:
SQL State '37000'
SQL Sever Error: 18452
[Microsoft][ODBC SQL Sever Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I have verified in Enterprise Manager that the concerened login is using a Windows 2000 Authentication and has the correct grant access permissions set up for the default database. Also switching to SQL Server Authentication or disabling security are not the options available in this case.
How to resolve this please-any help is welcome.
thanks
Sanjeev
MS SQl Sever 2000 Question
May 14, 2003i need write a Feasibility report about MS SQL 2000
Easy of use?
Cost?
Development speed?
Features
Sever Registration Problem In Ent. Mgr.
Oct 18, 2006One of my developers is trying to register a SQLServer server (Win 2000,
SQL 2000) using Enterprise Manager. He receives the message below;
A connection could not be established to sever_name.
Reason: "EXECUTE permission denied on objedt 'sp_MSSQLDMO80_version'.
His login is in an NT group and I added the login the way I've always
done. I even tried adding his login alone. No luck.
He can register other servers, just not this one. He can connect and
run queries on this server using Query Analyzer without issue.
I tried granting explicit execute rights to the sp but the error pops
up again but on a different sp this time.
This is not my server and is under the direct control of another dba
and IT group. I spoke with them and they were clueless about any
security setup/configuration that may have been done.
I'm clueless. If you have a clue please advise.
Thanks in advance.
Running Query From Two Sql Sever
Aug 24, 2004Hi Everybody,
I have two SQL server one in the office and other on remote location. I have some data on SQL in the office and some data on remote location and need to query the data.
how can I do that ?
Thanks for your help in advacne