.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

SQL Server 2008: Running Sum

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 

Microsoft,

Why have you once again flaunted the conventions for standard and much needed functionality that your users have requested.  On this occasion I am talking about the aspect of a running sum, you have already included SUM OVER etc so its a huge step forward, but see that you have not followed other SQL engine implementation that will allow running sums to be created.  Yes I know there are other ways round this, but come on: it has been long long enough you need to respond and get this added without further delay.

THANKS!




View Complete Post


More Related Resource Links

SQL server management studio 2008 freezes when running a query to Grid result

  
Hello, I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx 6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess. Suggestions anybody? Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.3798.0 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 4.0 5.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4952 Operating System      6.0.6001 regards, Pim

Error when running an SQL script to restore a database on SQL Server 2008 R2 Express

  
Hi, At work, I use SQL Server 2008 Express running on Windows XP Professional Service Pack 3. At home, I also use SQL Server 2008 Express running on Windows XP Professional Service Pack 3. Whenever I do work on the database at work, I usually restore the database at home (or vice versa) I have been using the following SQL scripts to back up the database and to restore the same database (at work or at home). BackupRealEstate.sql USE Master BACKUP DATABASE [RealEstate] TO DISK = N'F:\My Documents\My Database\RealEstate.bak' WITH NOFORMAT, INIT, NAME = N'RealEstate-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO RestoreRealEstate.sql USE Master RESTORE DATABASE [RealEstate] FROM DISK = N'F:\My Documents\My Database\RealEstate.bak' WITH  FILE = 1, NOUNLOAD, REPLACE, STATS = 10 GO Everything worked fine until I replaced my 8yo home computer with a newer and faster one. My new home computer is running Windows 7 Home Premium and I use the latest SQL Server 2008 R2 Express. When I tried to run the above restore SQL script, I got the following error message: Msg 3101, Level 16, State 1, Line 2 Exclusive access could not be obtained because the database is in use. Msg 3013, Level 16, State 1, Line 2 RESTORE DATABASE is terminating abnormally. There was no other application/process using this database. Can someone please help me? Regards,

What are the memory limits of SQL Server 2008 Workgroup edition (32 bit/non-R2) running on Windows S

  

We have a situation where one of our customers is running Windows 2003 Enterprise Edition 32bit with 8 GBs of physical RAM. Upgrading to Windows Server 2008 64bit is not an immediate option (although I wish it were). All the documentation about SQL Server 2008 Workgroup edition indicates that the new version will address 4 GBs of memory however it does not distinguish between 32bit vs 64bit.

Previously we have run SQL Workgroup 2005 under Windows 2003 and have applied the /3gb switch in boot.ini to get SQL to recognize the maximum amount of memory possible. Now that we are using SQL 2008 with the /pae switch, do we need to still specify the /3gb switch or can SQL 2008 32bit actually see more than the 3GBs and address 4? I haven't been able to find any information on this configuration.

 

 

 


SQL Server 2008 Management Studio locking up while not running anything

  

Scenerio:

Restart Server that DB is running on

Restart workstation that SQL Server 2008 Management Studio is running on

Start SQL Server 2008 and open file I'm editing

Edit the SQL file while while monitoring memory and processor usage on the workstation

Processor starts to spike, intellisense stops working, memory usage begins to climb to an absurd amount ~7G, management studio becomes almost nonresponsive (i.e. I can type and the text takes 30 seconds to 5 minutes to show up)

After about 30 mintues, memory usage drops to around 1.5G and management studio becomes semi-usable again.  Intellisense sometimes goes back to working, sometimes everything has to be restarted again.

I've been working on this exact setup for 7 months now and this problem is new.  No, I am not executing any statements - I am editing text only.


SQL Server 2008 R2 Standard edition running from one Core

  

Hi, I have a client who we just upgraded to Win 2008 R2 Standard Edition and SQL 2008 R2 Standard Edition

They are complaining about System performance. 

Looks like SQl runs only on 1 core, maybe sometime 2 which is maxed out.

"Automatically set Processors affinity mask for all processors" is checked and also

"Automatically set I/O affinity mask for all processors" is checked...

The server was maxed out with memory a few days ago but looks to me that that is something taht SQL 2k8 R2 does. The server has got 16GB ram

Pretty urgent. Got 3 hours to solve it.


Thanks

 


Failures in running Repair for 2008 SQL Server standard edition

  

Dear users,

2008 SQL Server Standard edition.

 

While running Repair I got below failures,

1. Upgrade failed due to the following error. The error code is :-214747259.Message:Unspecified error

2. The process cannot access the file 'C:\Windows\system32\perf-SQLSERVERAGENT-sqlagtctr10.0.1600.22.dll' because it is being used by another process.

3. The service did not start due to a logon failure.

I wonder what causes the failures and what I should do to fix them.

 

Could you tell me what to do?

Thank you,

 


Can I install SQL 2008 on a server running SQL 2005 to install Sharepoint 2010 Enterprise (Productio

  

Hi,

Sharepoint 2010 Upgrade Question - A customer is currently running sharepoint 2007 on a 64bit windows 2003 OS with SQL 2005 sp2, they are looking to install/upgrade to Sharepoint 2010 and want to use the current SQL server,for the upgrade a new SharePoint 2010 environment will be built and for a short while they will have two instances of SharePoint running SP2007 and SP2010. The plan is to then manually migrate the data from SP2007 to SP2010 (ENT), the web and application servers will be newly built. From research I think they have three options

1) Upgrade the current SQL 2005(SP2) instance to SQL 2008 R2 standard.

2) Install a new instance of SQL 2008 R2 on the same server and have both SQL 2005 & SQL 2008 running on the same server (Is this an option? Will sharepoint happily run from a SQL server running two SQL instances, do I have to be careful regarding the installation and configuration, could I break the existing sharepoint farm doing this?)

3) Upgrade the current SQL server to SP3 and install a new instance of SQL 2005 SP3 and install SharePoint 2010 Enterprise here, again I have all the questions from point 2 above.

We are thinking of trying option 1, then 2, then 3, and obviously only moving to the next option if we come across a show stopper. H

SQL Agent - Running SSIS Package - Windows Server 2008/Windows 7 - Messenger Services

  

We have tried to run a SQL job for SSIS Package. But it failed during the execution with the error "[364] The Messenger service has not been started - NetSend notifications will not be sent". But in the job, no notifications have been configured and in windows server 2008/Windows-7 there is no messenger service at all.

When we search for the the messenger service in windows 7/windows server 2008, we found that service is not in both the OS and it was replaced by msg.exe. 

Any help or workaround would be appreciated.

Thanks in advance.

PS: The normal SQL jobs other than SSIS are working fine without any error.


Vijay Pandurangan

Running ASP.Net 2.0 on Windows 2008 Server

  

Hi - I've got an ASP.Net 2.0 application running on a Windows 2003 server.  It makes use of the Microsoft.ApplicationBlocks.Data reference, but there are no special bells and whistles, no AJAX, or other add-ins.  The application connects to a SQL 2000 database on a different server.  My boss wants to know if we can upgrade the server where the ASP.Net application runs to Windows 2008.  Are there any issues I should be aware of?

Thanks much! 


SQL Server 2008 - Alerts for Long Running Jobs

  

All,

Back in SQL 2000, we had crazy queries that captured and notified long running jobs.

What is your solution for SQL 2008? Is there anything out of the box or should we still develop our own, using DMVs?

My company just got rid of SCOM, which had an alert for long running jobs right out of the box, and I need to create a new solution for this issue.

Let me know how you're handling this on your environment.

Thanks in advance for the help.


--- Best Regards, Igor Santos - DBA igor.santos@citrix.com

Processes running lond queries are killed by SQL Server 2008

  

Hi,

We recently upgraded a server from 2005 to 2008. We have some long running SP's (1 or 2 min) that used to run ok on 2005. Since the upgrade, whenever we run those SP's after some time, the process ID is no longer up on the server and the SSMS on the client indicates that the query is still running. Is there a new timeout parameter or something like that on 2008 that drops the long running procedures?

Thanks


Running licensed SQL Server 2008 Analysis Services with SQL Server Express editon?

  

Hi,

We have a SQL Server 2008 Standard Edition. We've also installed Analysis Services and are using cubes.

Is it possible to have the Analysis Services on another server, to take some of the load of the "relation engine" server?

Do we need a relation engine on this server? Will SQL express be sufficient for this?

 

Thank you,

Marcel


Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e

  

Hi,

I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

'TDS Protocol stream is not valid' error when running SQL Server 2008 with jdbc driver of version

  

I am using SQL Server 2008 on Windows Server 2008 R2 and one of our servers running as a windows service (on Windows Server 2008 R2) contacts the SQL Server 2008 in a timely fashion to get some information. During one of these runs, we encountered the following error logs in the service logs and thereby we took a hit in serving client requests. The jdbc jar that is used for database connectivity is of version 3.0 (sqljdbc.jar).

 

I can provide more details on this issue. Can someone please let us know why this can be occurring ? Just so you know, the set of errors repeats itself after sometime although on a different JDBC Connection (with different ConnectionID). We have a reconnection algorithm running in case the JDBC Connection is lost for some reason (but I would be surprised if this issue relates to the re-connect algorithm).

 

INFO   | jvm 1    | 2011/02/28 22:26:54 | Feb 28, 2011 10:26:54 PM com.microsoft.sqlserver.jdbc.TDSParser throwUnexpectedTokenException
INFO   | jvm 1    | 2011/02/28 22:26:54 | SEVERE: TDSReader@4686d ( ConnectionID:25 TransactionID:0x0000000000000000): FetchBufferTokenHandler: Encountered unexpected TDS_RET_STAT (0x79)
INFO   | jvm 1    | 2011/02/28 22:26:54 | Feb 28, 2011 10:26:54 PM com.microsoft.sqlserver.jdbc.TDSReade

Reports are deployed to Windows server 2008 and not running

  

Reports are deployed to Windows server 2008 and not running

Our reports were design in VS2005 and Reporting Services 2005 and deployed to Windows Server 2003 with SQL Server 2005. Our web application is running on Windows Server 2003 and using ReportViewer to show the data in the web.

Now we have upgraded both our Web server with IIS7 and IIS6 compatibility and database server to Windows server 2008 and installed SQL Server 2008 and Reporting Services 2008. We deployed our reports directly to this new server. When we run reports in the report manager in Reporting Services 2008 there is no problem we are able to run report but application could not run it, it times out. We are wondering if anybody had te same experience, is report viewer in VS2005 able to pull data from Reporting Services 2008? Is there any setup we need to do in web server or database server?

 


Sql Server 2008 Tutorials

  
This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

  
Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend