MS SQL Server :: 2005 Memory Management Questions

Questions About Memory Based Bulk Copy Operation(InsertRow Count,array Insert Directly,set Memory Based Bulk Copy Option)
Hi~, I have 3 questions about memory based bulk copy.

1. What is the limitation count of IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit(true)?
For example, how much insert row at below sample?(the max value of nCount)
for(i=0 ; i<nCount ; i++)
{
    pIFastLoad->InsertRow(hAccessor, (void*)(&BulkData));
}

2. In above code sample, isn't there method of inserting prepared array at once directly(BulkData array, not for loop)

3. In OLE DB memory based bulk copy, what is the equivalent of below's T-SQL bulk copy option ?
BULK INSERT database_name.schema_name.table_name FROM 'data_file' WITH (ROWS_PER_BATCH = rows_per_batch, TABLOCK);

-------------------------------------------------------
My solution is like this. Is it correct?

// CoCreateInstance(...);
// Data source
// Create session

m_TableID.uName.pwszName = m_wszTableName;
m_TableID.eKind = DBKIND_NAME;

DBPROP rgProps[1];
DBPROPSET PropSet[1];

rgProps[0].dwOptions  = DBPROPOPTIONS_REQUIRED;
rgProps[0].colid   = DB_NULLID;
rgProps[0].vValue.vt  = VT_BSTR;
rgProps[0].dwPropertyID  = SSPROP_FASTLOADOPTIONS;
rgProps[0].vValue.bstrVal = L"ROWS_PER_BATCH = 10000,TABLOCK";

PropSet[0].rgProperties  = rgProps;
PropSet[0].cProperties  = 1;
PropSet[0].guidPropertySet = DBPROPSET_SQLSERVERROWSET;

if(m_pIOpenRowset)
{
  if(FAILED(m_pIOpenRowset->OpenRowset(NULL,&m_TableID,NULL,IID_IRowsetFastLoad,1,PropSet,(LPUNKNOWN*)&m_pIRowsetFastLoad)))
  {
   return FALSE;
  }
}
else
{
  return FALSE;
}

View Replies !

SQL CLR Memory Management
Hello,

I have a few questions about the behavior of the CLR host within SQL Server 2005. We are using a UDT (call it MyDateTime) created in C# that represents the COM FILETIME type, in order to have single millisecond resolution. MyDateTime values are stored in the database as binary(8), with the UDT itself being used primarily for display and reporting purposes. I am running performance tests using a prototype (written in C# as well) that runs 20 threads which repeatedly call a stored procedure, which accepts two MyDateTime's, and queries a table based on those MyDateTime's binary string representation. After a certain amount of time (depending on the particular system's resources), threads will start to be aborted. Most of the time the reason is "SQL Exception: .NET Framework execution was aborted by escalation policy because of out of memory." Sometimes, eventually the appdomain will be unloaded, and if I restart the prototype, the process starts over. Sometimes, I will have to restart the server before any more CLR processing can occur (no automatic appdomain unload). While the prototype is running, I'll check the MEMORYCLERK_SQLCLR rows in sys.dm_os_memory_clerks, and see the columns for pages and virtual memory ever increasing, until a threshold is hit (on my system, approximately 225 megs of virtual memory committed), resulting in all 20 threads being aborted, one by one, within 30-45 seconds. During that time some of the remaining threads will still have successful calls, while others are aborted.

I understand the necessity for the CLR in SQL Server to monitor and abort threads, in order to preserve the database server itself, as well as the importance of exception handling client-side, but unless the UDT code itself has a leak in it (I'm fairly confident it doesn't), this behavior confuses me. X amount of stored procedure calls (on my system, approximately 65,000 within an hour) can occur before SQL Server runs out of memory, and will constantly abort any thread trying to use the UDT, until it decides to unload the appdomain? Is it entirely up to the client to catch any threadaborts and retry those transactions, and is there any way to facilitate or predict if/when the appdomain is going to unload? Am I missing something about how garbage collection is functioning within SQL Server, or the CLR itself? Even simple CLR code slowly eats up the memory and causes the same results, if enough transactions are made. Does a long running or high transaction system have to anticipate a regular intervention by the escalation policy?

Any insight you could give me would be greatly appreciated. Have a good day.

-Dan

P.S. I'm running the September CTP of SQL Server and the Release Candidate of Visual Studio, based on our current development requirements--I will upgrade when I can.

View Replies !

Project Management Interview Questions June 5th, 2006
All answers to the below interview questions are athttp://www.geocities.com/dotnetinterviews/oryou can download the complete answer zip file fromhttp://www.questpond.com/ProjectMan...ewQuestions.zipWhat is project management?Is spending in IT projects constant through out the project?Who is a stakeholder ?Can you explain project life cycle ?Twist :- How many phases are there in software project ?Are risk constant through out the project ?Can you explain different software development life cycles ?What is triple constraint triangle in project management ?What is a project baselines ?What is effort variance?How is normally a project management plan document organized ?How do you estimate a project?What is CAR (Causal Analysis and Resolution)?What is DAR (Decision Analysis and Resolution) ?What is a fish bone diagram ?Twist:- What is Ishikawa diagram ?What is pareto principleTwist :- What is 80/20 principle ?How do you handle change request?What is internal change request?What is difference between SITP and UTP in testing ?What is the software you have used for project management?What are the metrics followed in project management?Twist: - What metrics will you look at in order to see the project ismoving successfully?You have people in your team who do not meet there deadlines or do notperform what are theactions you will take ?Twist :- Two of your resources have conflicts between them how wouldyou sort it out ?What is black box testing and White box testing?What's the difference between Unit testing, Assembly testing andRegression testing?What is V model in testing?How do you start a project?How did you do resource allocations?How will you do code reviews ?What is CMMI?What are the five levels in CMMI?What is continuous and staged representation?Can you explain the process areas?What is SIX sigma?What is DMAIC and DMADV ?What are the various roles in Six Sigma implementation?What are function points?Twist: - Define Elementary process in FPA?What are the different types of elementary process in FPA?What are the different elements in Functions points?Can you explain in GSC and VAF in function points?What are unadjusted function points and how is it calculated?Can you explain steps in function points?What is the FP per day in your current company?Twist :- What is your company's productivity factor ?Do you know Use Case points?What is COCOMO I, COCOMOII and COCOMOIII?What is SMC approach of estimation?How do you estimate maintenance project and change requests?--- Free PDF's for interview questions1000 Interview Questions for .NET and SQL Serverhttp://www.geocities.com/dotnetinterviews/Project Management Interview questions must to read for all aspiringproject managershttp://www.questpond.com/ProjectMan...ewQuestions.zipFull Address book application in C# with technical specification ,estimation and test caseshttp://www.questpond.com/AddressbookProject.zip60 Web services Interview questionshttp://www.questpond.com/WebServicesAndRemoting.zip20 SQL Server 2005 Database optimization Interview questionshttp://www.questpond.com/DatabaseOptimization.zip30 Basic .NET Framework interview questionshttp://www.questpond.com/FrameWorkS...ewQuestions.zip40 .NET Interop and COM Interview questionshttp://www.questpond.com/Interopdot...ewQuestions.zip30 ASP.NET Caching Interview questionshttp://www.questpond.com/CachingInterviewQestions.zipDo not know how estimations are done here's a complete book on ithttp://www.questpond.com/HowtoPrepa...eQuotations.zipFull free download of interview questions fromhttp://www.questpond.comHelp the community to make job search easier mail your questions toJoin Bytes!Looking for a onsite job mail your resumes atJoin Bytes!

View Replies !

Memory Management In A Clustered SQL2000 Environment
Does anyone have any experience with Memory Management in a Clustered SQL2000 Environment so that they can answer a few concerns that I have ?

My main issue is with the allocation of memory when Failover occurs and providing enough memory to support the failed over Virtual Servers (SQl named instances).

If anyone has any experience on this please let me know and I will tell you all my troubles !!

Cheers

View Replies !

SQL Dynamic Memory Management And Low Free Buffers/
We are just beginning to use a third party tool to monitor our SQL Servers. One very active server seems to have a few occassions where the Free buffer goes very low (under 10)however, it seems to quickly resolve back to a couple of hundred free buffers. This occurs both during times with heavy user activity and times with little user activity but high sql agent maintenance activity. Other memory numbers and the Buffer cache hit ratio seem fine. Any ideas? Is this normal when SQL Dynamically manages memory?

View Replies !

Speed, Memory Usage Question For Photo Management
Hi all, quick question. A while back I developed a website that allowed upload of photos. At the time, I used ASP and VBasic-behind and wrote code to store and retrieve all photos in an SQL database in binary format. I am looking at a new project, very similar, and was wondering if anybody had any idea how this method might compare to simply storing the image files on the server and using the database to simply point to their location. I am wondering how the two methods compare spped wise and hard drive space they may consume. Does anybody have any idea on a direct comparison?? Any benchmark tests anybody has seen or ran?
Thanks all,
Chris

View Replies !

While Opening Management Studio I Am Getting Error--Attempted To Read Or Protected Memory.

Hi,
I am getting error while opening the Data Base Engine in Sql server Management Studio.
We applied SP2. and restarted the server but no luck.
Error Message:Attempted to read or protected memory. This is often an indication that other memory is corrupt(mscorlib).

View Replies !

Questions About Bulk Copy Insert Using 'Memory Based Bulk Copy Operations'
Hi~,

Before implementing memory based bulk copy insert with IRowsetFastLoad interface of SQL Server 2005 OLE DB provider, I want to know some considerations.

- performance : compared with T-SQL's "BULK INSERT ..." and bcp utility

- SQL Server's resource usage : when running memory based bulk copy, server resource's influence

- server side action(behavior) : when server is busy, delayed-update means IRowsetFastLoad::Commit(true) method can insert right after?

- row-count : The rowcount limitation can be inserted by IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit

- any other guide lines

View Replies !

2005 Database Will Be Created In Both Management Studio Express And App_Data Folder Of VS 2005?
I have not created SQL Server 2005 database before. When installing a sample SQL Server 2005 Express
database using a Configure.exe file from the Microsoft Press Book 'ADOnet 2.0', I can see the database in the App_Data folder of the Solution Explorer on VS 2005, as well as Management Studio Express. But for the MS Press book 'ASPnet 2.0', the web site created from the virtual directory of sample code showed an ASPNETDB database in the App_Data folder, but no ASPNETDB database in the SQL Server Management Studio Express.

Is this the way how SQL Server 2005 will work -- the database can be displayed in both the Management Studio and App_Data, as the ADONET 2.0 database showed, or just in the App_Data folder, as the ASPNET 2.0 databae showed?

TIA,
Jeffrey

View Replies !

How To Upgrade From SQLServer Management Studio Express 2005 To SQL Developer 2005
I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible. Keeping my databases and such.

Any recommendations on the best way to do this would be greatly appreciated.

thanks!

View Replies !

SQL Server 2005 Management Studio Only Can Connect To 2005 Mobile Edition?
hi,

I have some SQL CE database .sdf file on my handheld, and I was trying to connect to that file via SQL Server 2005 Management Studio, and it does not work. I am wondering if there is any good tool that I can use on desktop to connect to sqlce .sdf database file on my handheld?

Thanks.

View Replies !

SQL 2005 Mirroring Questions
Hi guys,
I have read many articles on the matter and I have probably used up all my printer's ink in doing so, however, some questions still remain.
1) What happens if I have to reboot the mirror.. security update, etc.? Obviously the session is broken during reboot, but would I have to do another backup of the principal and resync everything?
2) I know it is not best practice but at this point I have no choice, however, I wanted to get your guys feedback on having two instances of SQL2005 on my development box. One for the mirroring of the production and the second for development. The two instances would live on their own drive... not partitioned and have adequate memory and space.
What would I have to look forward with this?
3) Lastly, I am still uncertain if mirroring is approved for production. Is it?

Thanks for your help.

View Replies !

SQL 2005 Encryption Questions
Hello,I have been researching the use of symmetic and asymmetic encryption inSQL 2005 and I am pretty excited to give it a try. Through examples, Ican encrypt the data, but I cant figure out what to do next...What I want:1. our social security field to be encrypted so that only the person(s)that need it can decrypt it.2. prevent DBA's from decrypting the data themselfs3. Simple way to encrypt the data on the table (maybe a trigger?)I thought I would use asymmetric keys, this way I can embed the publickey into my data warehouse process to encrypt the data.I thought I would prompt the user for the private key when the reportruns, that way I wont store the key on the server.This would be a place to start.Someone in the office said that we can store the keys in Activedirectory, so maybe I could make this seemless to the user running thereport?I've found a lot of great articles that got me started, but I amneeding the next stepAny Ideas would be apprecitated!TIARoblinks to articles I have found handy:http://www.databasejournal.com/feat...int.php/3483931http://www.devx.com/dbzone/Article/29232/0/page/3http://www.sqlservercentral.com/col...rintversion.asp

View Replies !

Several 2005 Security Questions
I am an Oracle DBA who inherited SQL Server administration. I have been to some 2005 training and I've been supporting several DB's for a while now but I still have some nagging security questions and would appreciate some help.

1) I needed to grant execute on a specific procedure but when I drilled down, I found that it already had execute in the EFFECTIVE PERMISSIONS. I would like to know how to tell where it got this permission from. I did some digging and found that execute appears to have been granted to the schema itself. I didn't know you could do that. Would this result in the effective permission that I observed?

2) I am trying to audit the permissions on existing principles. In Management Studio I drilled down and found permissions under Security and under Server Properties. There are also more permissions under Database Properties and Security and still more assigned at the specific object level. Where can I go or what can I query to see ALL the permissions a principle has been granted across the entire server?

3) If I grant a principle CONTROL to a schema does that also automatically confer DDL rights to said schema or would additional privs be required to perform DDL?

Thanks in advance,
Roger Westbrook

View Replies !

SQL 2005 - Syntax Questions
What is the proper syntax to return records that appear in 1 table but NOT the other table? I have 2 tables that should contain the same records(based on shipping report number), so my join will use this field. How can I only return the data where the shipping report number appears in only 1 of the tables though>?

View Replies !

SQL Server 2005 Questions
Hello,

We are currently running a corporate client with Windows 2000 and .Net 1.1. We are running a number of SQL Server 2000 applications and are now thinking of upgrading to SQL Server 2005 as part of a data consolidation exercise. I am concerned on a number of points:

Can I connect to SQL Server 2005 using old ADO connectors? We have about 40 Excel VBA solutions, and we dont want to upgrade to SQL Server 2005 if we will be unable to connect to the data source. We cannot upgrade any new versions of MDAC or upgrade the .NET framework so this is a concern.

Do we need .NET 2.0 or Visual Studio 2005 to connect and work with SQL Server 2005? If so, this will be a problem as we cannot upgrade any client beyond .NET 1.1, and only have VS 2003 as a scripted application we can install for any development.

Has anyone have any experience of the KPI capabilities of SQL 2005? We are bordering on committing to a Business Objects BI platform, and having worked with BO Dashboard Manager and Performance Manager for 4 months (it was horrible), I am not relishing the prospect and would like to propose SQL 2005 as an alternative.

Many, many thanks

Indy

View Replies !

Sql Server 2005 Query Questions
I recently upgraded to sql server 2005 for developing on my local system and cant seem to find the option that automatically sets the drop procedure at the top and the usernames on the bottom of a procedure that I script as new. I used to do it in the old query analyzer so Im sure its in there somewhere. Thanks in advance for any help.RyanOC

View Replies !

Collation Questions SQL Server 2005 SP2
A few collation questions on SQL Server 2005 SP2, which I'll call SQLS.The default collation for SQLS is apparently SQL_Latin1_General_CP1_CI_AS.I wish to use a variation of this, SQL_Latin1_General_CP1_CS_AIcollation, but there is no such collation returned fromfn_helpcollations(). Also, if I try to use this collation ina CREATE DATABASE stmt, SQLS yells about it.I see that there is a Latin1_General_CS_AI. What effects are therein using this collation? The SQL_* collations are SQL collations,while non-SQL_* collations are Windows collations, yes? SQLS runsonly on Windows, so am I safe in using Latin1_General_CS_AI? Whatdoes the CP1 in the SQL collation signify? Am I asking for trouble?------------------------------------Assuming that I set Latin1_General_CS_AI (or any other case-sensitivecollation) at the database level, I believe my DDL/DML for that databasealso becomes case-sensitive. How can I specify that I want ONLY my dataaccess to be case-sensitive, and not my DDL/DML? I don't want to haveto remember to type "select * from MyCamelCase" when "mycamelcase"should work.Any help appreciated.A new SQLS DBA..aj

View Replies !

SQL 2005 Install Questions - CD Has Different Options Then DVD
I printed out several pages of documentation regarding the install of 2005. When I tried performing the installation from CD I double-click splash.hta, as indicated in "How to: Install SQL Server 2005 (Setup)". Under Install I see two options:

Server components, tools, Books Online, and samples
Run the SQL Native Client Installation Wizard

The documentation indicates I should be clicking on "Run the SQL Server Installation Wizard", which is not an option. If I select "Run the SQL Native Client..." it appears to be only installing the client and does not follow the remainder of the instructions. I can't find any information on Microsoft's site on how to perform an install from CD.

I'm guessing I should be using the DVD, but has anyone else noticed the "How to" documentation is a little off and have you found any other documentation that is more accurate?

Thanks, Dave

View Replies !

Questions On LogFiles: SQL Express 2005
Note: Please refer to my previous message to see the current VS2005 C# code I am using to create my database.

This database will be used for short term operations. In otherwords, a user will create the database, generate a lot of data that will be created using:

SqlBulkCopy bcp;

Then, there will be 'activity'... updates, queries, deletes, etc for a few days and then the user will at a minimum remove all of the data and at some future point in time, will recreate the data and do the process all over.

In otherwords, I am not concerned about backups or transaction logging or recovery or any of these 'normal' issues of using a SQL database.

That said, how do I use SMO to keep the LDF limited in size and as small as possible (assuming I can't turn of the tranaction log to begin with).

2nd question is...I read soething about being able to log ONLY the exection of a Bulk Copy operation. How do I specify that? This is my SQLBulkCopy code.

SqlBulkCopy bcp;

SqlCommand sqlCmd = new SqlCommand();

sqlCmd.Connection = m_dbFiles.conMain;

bcp = new SqlBulkCopy(sqlCmd.Connection);

bcp.DestinationTableName = "tblMyTable";

bcp.WriteToServer(datatable);

View Replies !

A Few Questions On Locking In Sql Server 2005
Hi pardon my ignorance but I wonder if someone could answer a few questions for me.

I am writing a program which will be used by perhaps upto 100 users at a time. The program sits on any number of PCs and loads user specific data to a given PC according to who has logged on to windows on that PC.

A number of data items loaded from the user table have to be unique as they are usernames for other systems that my program simplifies access to.

So when a user logs on to my program for the first time a row is created for them in the user table (indexed by a GUID and their unique network name). The other unique fields are left blank and the user is given an opportunity to fill these details in.

Before writing these details to the user's row in the 'users table' the program loads the whole user table down and checks that these items are unique before committing them to that user's row in the table.

The problem of course is that if between the program downloading the user table into a local datatable, checking the values are unique and then actually writing them someone else writes the same data into their row then 2 users end up with the same data - which shouldn't be allowed. i.e. 2 users can't have the same user name for the other software.

How can I solve this problem with locking? Once the user table is downloaded and in a locel datatable presumably the table is no longer locked so another user could write data to the table.

I acutally think this is going to be a pretty rare occourance but I still want to try to cover all eventualities.

I suspect the problem is the way my program is going about the checking.

Should I use an SQL insert statement like??

If exists(SELECT username from users where username=@username)
BEGIN
RAISEERROR("Username already exists")
END
ELSE
BEGIN
INSERT etc

If so I guess this will simplify my code. Is this the correct thing to do? And then just trap the errors that arise if a duplicate does arise?

Also some more general questions.

1)I presume 2 users simultaneously looking up data from 2 different rows in a table doesn't lock the table so one search fails? I use the code below having set up a command to run a stored procedure to search for a user by their network name.

Dim lclRowRet As SqlDataReader

lclRowRet = LoadUserCommand.ExecuteReader(CommandBehavior.SingleRow)

lclRowRet.Read()

2) I presume writing data to my user table a row at a time will also not cause a lock. I create a command object with all the row values in and then do a command.executenonquery()

As a rule I close all my connections as soon as I'm done with them.

Many thanks for your help in advance.

nik

View Replies !

2 Questions (SQL 2000 To 2005 Database Conversion)
I have a db in SQL server 2000 developer edition. I am using Visual Studio 2005 standard, and also VWD Express. I would like to just access the database that is in SQL server 2000 so I can get on with developing the site, but VS2005 refuses to recognize the instance. It recognizes 2005 instances right away.The services are all running, the network protocols are enabled, uid's/pw all of that is correct. I am getting the "named pipes" error (the named pipes protocol is enabled).Any suggestions? I'd really rather just work with the db as-is in SQL 2000. But I can't get it to connect. I can connect to it if I export it to SQL 2005, (on the same development machine) but can't get the stored procs over to the 2005 db. So my web app is not finding the stored procs and won't run.Do I need to uninstall SQL 2005 from this box if I want to use SQL 2000?Thanks,--Donnie

View Replies !

Sql Server 2005 Questions Regarding Editing Views
Previously in Sql Server 2000, we would be in enterprise manager, you'ddouble click on a view, and a nice little dialog box opened with the t-sqlstatetments, there was also a check sql syntax and apply and cancel buttons.Not exactly query anaylizer, just a quick lightweight dialog box. Is thisfeature still around? Seems like I have to go into the query anaylizer likemode to edit a view now. I am a total newbie to version 2005. Are there anyoptions I can set to make it behave the old way? All feedback isappreciated.TIA,~CK

View Replies !

Few Simple (silly) Questions On SQL 2005 && CLR Integration.
Hi all,

I need few clarifications from you experts regarding SQL server 2005 & CLR integration ( my questions might be simple and silly, please bear with me).

A web service should be invoked from the SQL Server , Is CLR stored procedure only way to do that ?
Does SQL Server uses the CLR only when the CLR support is enabled ? OR SQL Server itself runs on top of the CLR no matter it is enabled or not ?
What are the major disadvantages of using CLR stored procedures instead of T-SQL?

Thanks in advance,

DBLearner

View Replies !

Basic Questions On SQL Server 2005 Encryption
I just started reading about encryption and I have few questions.

1. How does inserts and updates from application gets encrypted and saved in the database. I tried it from the query analyzer it works fine. But how does it work from the application. Do we need to use keys in application code or do I need to change the code in the objects that are referred by the application?

2. I read lot about key management and finally what I understand is we got to back the keys using BACKUP command and save them some where. Also save the passwords that are being used during key creation, Is that what is called key management or Is there anything I am missing?

View Replies !

Where Do I Post Reporting Services 2005 Questions
Where do I post Reporting Services 2005 Questions

Thank you,

View Replies !

Questions About Sql Server 2005 Timeseries Algorithm
First of all I would like to politely greet everybody as I'm new on that forum and new to Data Mining in fact.

To introduce myself I can say I'm a student of Computer Science and I'm trying to use Time Series algorithm for weather analysis. I know that forecasting weather is a hopeless task even for the fastest computers in the world but what I'm trying to do is a kind of aposteriori analysis of historical data to notice some dependencies or characteristic weather behavior on a specified region and perhaps make some short time predictions.

I tried Time Series Algorithm although I have some doubts about methodological justification of this choice (if You have any critical comments please share them with me). But my main questions are about the usage of the algorithm itself:

I've read the documentation and a tutorial on this page for historical predictions but I still don't know what exactly are HistoricalModelCount and HistoricalModelGap. I know that my historical predictions are bounded by a €“ HistoricalModelCount*HistoricalModelGap*, but it's a rather operational knowledge... The explanation is always clouded with an €œinternal model€? phrase. Can You point me to a document where I can find some more detailed information? (What is the form of the model? How is it built? etc.)

Periodicity Hint. How should I treat these optional values? Are they other possible periods of data? I have data about weather measurements made every six hours for thirteen years** so is it a good choice to set this parameter to {365*4,4} (The first goes for a year and the second for a day)?

This is a technical question and I'm really ashamed of myself that I bother You with it. On the time chart in a model Viewer I can see date from the last year only. Zooming out/in, clicking insanely on every pixel on the screen, did not give any result (apart of broken mouse buttons). Is is possible to browse that data in mining model viewer chart?
Thank You in advance for Your replies!

*This formula suggests how this parameters could work but I would like to know it for sure €“ don't want to make some awful mistakes in my project. :-)
**Of course I plan to reduce the amount of data but the period will stay.

View Replies !

Questions About Sql Server 2005 Timeseries Algorithm
The first question is how to of TimeSeries Algorithm?

Using SQL Server 2005 TimeSeries Algorithm ,I build a data mining model.But after three days,it is still training.The data has 2,200,00 rows.

So what can i do to improve the processing speed.

Thanks!

The second question is parameters in Data Mining Query Task.

Data Mining Query Task is used to get data from data mining model.In the mining model form, i choose a mining model . And in the query form,i wrote a dmx ,"select flattened top 100 predicttimeseries([Xssl],1)
from [Time Series XSSL]".Last i choose a table that is for the data from mining model.

If the "100" is variable , how can i do ?

Thanks a lot!

View Replies !

Few Questions Regarding SQL Reporting Service 2005. (PageBreak)

Hi,

During last year, I developed more than 200 Reports using SQL Reporting Service. It is really fantastic and in many ways it has reduced lot of work.

But still I am not able to find out solution of following issues,

1)     Where to set portrait or landscape printing mode? It takes based on paper size, if 8.5 x 11 then portrait else landscape.
Now I want to set myself in report irrespective of page size then HOW TO DO IT?
2)     I want to set Height, Width and Merge cells options based on Expression like many other things we do, ex. Font, Text Align, Visibility, etc€¦ HOW TO DO IT?
3)     I am not able to find out option for Vertical Cell merging? Is it available or is there any trick?
4)     If entire group or table can be printed within a page then it is fine but if page break occurs then I want to print Entire Group or Table on next page.
In many cases you can€™t allow page break like, Pay Slip of Salary, Purchase Order Month Wise Schedules, etc€¦
So some option should be there like €œInsert Page break if table or group is not able to fit on current page€? HOW TO DO IT?
5)     Is there any way to know that there is page break in this Table or Group?
6)     Can I Insert Page Break based on Expression?

Theses problems really create headache. There must be some solutions.

Kindly Help,

Nilesh

View Replies !

I Want The Sites For ASP.NET 2.0 And SQL SERVER 2005 Interview Questions.
I want the sites for ASP.NET 2.0 and SQL SERVER 2005 interview questions.

2) Sites for SQL SERVER 2005 concepts

View Replies !

SQL Server Express 2005 Questions And Issues...

So I am fairly new to Express and I have installed it on my development machine; much tio my chagrin it is quite difficult to import data into SQLEXPRESS. I have a 'sa' account setup and I have created a new database and table within that database, however, when I try to import data into that table by setting up a link server to excel I am having some major issues!

I ran this code first to create the linked server...

DECLARE @RC int

DECLARE @server nvarchar(128)

DECLARE @srvproduct nvarchar(128)

DECLARE @provider nvarchar(128)

DECLARE @datasrc nvarchar(4000)

DECLARE @location nvarchar(4000)

DECLARE @provstr nvarchar(4000)

DECLARE @catalog nvarchar(128)

-- Set parameter values

SET @server = 'XLTEST_SP'

SET @srvproduct = 'Excel'

SET @provider = 'Microsoft.Jet.OLEDB.4.0'

SET @datasrc = 'c:Anchor_Hocking blactionlist.xls'

SET @provstr = 'Excel 11.0'

EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider, @datasrc, @location, @provstr, @catalog

Next I try to run any of the statement below and I get the errors pasted below...

SELECT * FROM Anchor_Hocking...Sheet1$

EXECUTE SP_TABLES_EX 'Anchor_Hocking'

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=c:Anchor_Hocking blactionlist.xls;User ID=sa;Password=sa;Extended Properties=Excel 8.0')...Sheet1$

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Anchor_Hocking" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Anchor_Hocking" reported an error. Authentication failed.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Anchor_Hocking".

The file is not open. I have granted full access rights to all users....I am really frustrated!

Also, how can I get SSIS on this machine with SQLEXPRESS?

-Brian

View Replies !

64 Bit SQL 2005 Memory
Hello,I have two servers running SQL 2005.1. Windows Server 2003 x32 with SQL 2005 Enterprise x32 with 3GB memory2. Windows Enterpise 2003 x64 with SQL 2005 Enterprise x64 with 8GBmemoryUsing taskmgr.exe my 32 bit machine shows 700mb being used bysqlservr.exe, which I expect.However, my 64 bit machine shows sqlservr.exe using 27 mb, which seemsreally low. After I build my data warehouse, I see memory usage at1.5GB on my SQL 2000 machine, so I'd expect more than 27mb used on SQL2005 after I build my warehouse.Additionally, taskmgr says PF Usage is 8.33 GB. Where is the missingmemory, why is SQL 2005 x64 using so little memory??The memory configuration for the x64 server is 0 minimum and 2147483647max KB (defaults)Any thoughts?TIARob

View Replies !

SQL 2005 Not Using Memory
Hi I am using SQL 2005 64 Enterprise edition with 30GB memory.
I have allowed SQL to use min 0 memory and maximum 20GB but sql is only showing it can use 100MB of memory

Anyone know the answer
Ap

View Replies !

SQL 2005 64 Bit Only See 2GB Of Memory
We are running Win2003 SP1 64 bit and SQL Server 2005 64 bit. We are only able to set SQL's memory allocation to 2GB even though we have 6GB installed. How do we make more memory available to SQL Server?

View Replies !

Sql Server 2005 Standard And Express Connection Questions
Hi all, i have standard edition of sql server, on a server hat doesnt have sql server standard would i be able to connect to it using my connection string. Or does the server has to have standard edition too. Is this same for express edition, and if possible to do this whats the difference between express connection string from standard edition thanks

View Replies !

Questions On Use Of SQL Server 2005 Functionality In Gridview Paging
I have a webpage that displays 4000 or more records in a GridView control powered by a SqlDataSource. It's very slow. I'm reading the following article on custom paging: http://aspnet.4guysfromrolla.com/articles/031506-1.aspx. This article uses an ObjectDataSource, and some functionality new to Sql Server 2005 to implement custom paging.There is a stored procedure called GetEmployeesSubestByDepartmentIDSorted that looks like this:ALTER PROCEDURE dbo.GetEmployeesSubsetByDepartmentIDSorted( @DepartmentID int, @sortExpression nvarchar(50), @startRowIndex int, @maximumRows int)AS IF @DepartmentID IS NULL -- If @DepartmentID is null, then we want to get all employees EXEC dbo.GetEmployeesSubsetSorted @sortExpression, @startRowIndex, @maximumRows ELSE BEGIN -- Otherwise we want to get just those employees in the specified department IF LEN(@sortExpression) = 0 SET @sortExpression = 'EmployeeID' -- Since @startRowIndex is zero-based in the data Web control, but one-based w/ROW_NUMBER(), increment SET @startRowIndex = @startRowIndex + 1 -- Issue query DECLARE @sql nvarchar(4000) SET @sql = 'SELECT EmployeeID, LastName, FirstName, DepartmentID, Salary, HireDate, DepartmentName FROM (SELECT EmployeeID, LastName, FirstName, e.DepartmentID, Salary, HireDate, d.Name as DepartmentName, ROW_NUMBER() OVER(ORDER BY ' + @sortExpression + ') as RowNum FROM Employees e INNER JOIN Departments d ON e.DepartmentID = d.DepartmentID WHERE e.DepartmentID = ' + CONVERT(nvarchar(10), @DepartmentID) + ' ) as EmpInfo WHERE RowNum BETWEEN ' + CONVERT(nvarchar(10), @startRowIndex) + ' AND (' + CONVERT(nvarchar(10), @startRowIndex) + ' + ' + CONVERT(nvarchar(10), @maximumRows) + ') - 1' -- Execute the SQL query EXEC sp_executesql @sql ENDThe part that's bold is the part I don't understand. Can someone shed some light on this for me? What is this doing and why?Diane

View Replies !

ASP.Net 2.0 Application Connection To SQL Server 2005 - Setup Questions
All:
I am writing an Internet/Extranet based (ASP.Net 2.0) web application that uses SQL server 2005 as the database. I am using forms authentication on my web application. I am also storing the connection string to SQL server in my web config file. The conn string is encrypted using DPAPI with entropy. I currently have created a SQL login account on my SQL server for use by the web application. This is the user ID I am using in my conn string. The reason for this is because all persons using the application will NOT have a windows login.
Here is my question: The login I created currently has defaulted to the "dbo" role and therefore has "dbo" rights to the database. I want to setup up this login account so that all it can do is execute stored procedures. I dont want this SQL login to be able to do anything else. In my application I am using stored procedures for ALL data access functions, via a data access layer in my application. Can someone guide me step by step as to how to setup this type of access for this SQL login.
Thanks,
Blue.

View Replies !

Service Stop/start/restart Questions 2005 SP2
A few service stop/start/restart questions on SQL Server 2005 SP2, whichI'll call SQLS.It looks as if there are *potentially* 6 ways to start/stop SQLSServices like the engine itself, integration services, reportingservice, Agent..-SQLS Configuration Manager-SQLS Surface Area Configuration (for Services and Connections)-Mgmt Studio Local (on server)-Mgmt Studio Remote (on client)-Windows Control Panel->Admin Tools->Services-Command Prompt (ala net start MSSQLSERVER)By policy, I am /not/ Administrator on the server. But I am SysAdminrole in SQLS. I have had various levels of success starting/stoppingservices in the ways listed above. In some I get Access denied, and inothers I get no msg and it simply doesn't work.Is there some special non-Admin OS group I need to be in to start/stopservices? Is this handled differently in the different interfaceslisted above?It seems like my best success for starting/stopping the engine and Agentis in /local/ Mgmt Studio, but /not/ remote Mgmt Studio - the optionsare greyed out on a remote client. Is this by design? Is it a SQLSbug?I'm sure I'm not the only SQLS DBA who does not have Admin rights on hisserver who wants to start/stop services. Generally speaking, how isthis intended to work?Any help appreciated.Allen JantzenA freshly minted DQLS DBA

View Replies !